Abstract: A method for hiding and showing spreadsheet cells of a worksheet being displayed on a computer system display means. The hiding and showing is based upon hierarchical relationships among the spreadsheet cells. This technique is implemented by first determining hierarchical relationships among cells based on cell indentation, content, and formulas. A group of contiguous cells having a common hierarchical relationship is then selected and hidden. Totals for the group of cells may then be shown in place of hidden cells. The hidden group of cells may be stored in a memory location other than main memory such as a magnetic or optical disk. The group of cells may then be retrieved from memory and shown on the display means.