Hiding columns and rows

Another way to take the clutter out of a worksheet is to temporarily hide columns and rows:

• Hiding columns or rows: Drag over the column letters or row numbers of the columns or rows that you want to hide. Dragging this way selects entire columns or rows. Then click the Format button on the Home tab, choose Hide & Unhide, and choose Hide Columns or Hide Rows.
• Unhiding columns and rows: Select columns to the right and left of the hidden columns, or select rows above and below the hidden rows. To select columns or rows, drag over their letters or numbers. Then click the Format button on the Home tab, choose Hide & Unhide, and choose Unhide Columns or Unhide Rows.

It's easy to forget where you hid columns or rows. To make sure all columns and rows in your worksheet are displayed, click the Select All button (or press Ctrl+A) to select your entire worksheet. Then click the Format button and choose Hide & Unhide → Unhide Columns; click the Format button again and choose Hide & Unhide → Unhide Rows.