Hiding Rows and Columns

On some worksheets, you need to use rows or columns to hold data used in calculations, but you don’t need to clutter up the rest of the worksheet by showing it. Click any cell within the row or column you want to hide (you don’t need to select the entire row or column). Then click the Home tab, click Format (in the Cells group), click Hide & Unhide, and choose Hide Rows. To make a hidden row visible again, select cells in the row above and below the hidden row, go back to the Format command, click Hide & Unhide, and then choose Unhide Rows.

Use similar procedures to hide and unhide columns. To hide a column, for example, select one of its cells, click Format in the Cells group of the Home tab, click Hide & Unhide, and then choose Hide Columns.