The Sisyphus Comments

Hiding Rows And Columns In Excel

At the academy, we use an “electronic grade-book” which is really nothing more than a spreadsheet. Like most agencies, we also use a spreadsheet to develop our budget. When a spreadsheet is used for these purposes, normally more than one staff member is given editing privileges for the document. Of course, the spreadsheet designer must build in safeguards to protect formula cells from being accidentally overwritten. Although cell protection is one method for protecting cells, hiding cells is another option for concealing columns until you need them later. Hiding rows and columns is easy:

Method 1
– Select one or more row/column headings
– Right-click, and choose Hide

Method 2
– Select the row/column heading(s)
– Choose Format/Row (or Column)/Hide (Excel 2002/2003) or;
– Move to the Home tab (2007)
– In the Cells group choose the Format option and select Hide & Unhide from the drop-down menu.

Method 3
– Highlight a cell in each row or column you want to hide.
– Press Ctrl + 9 to hide the row(s) or press Ctrl + 0 (zero) to hide the column(s).
– Works in Excel 2002, 2003, and 2007