Hiding and Unhiding Rows and Columns

Contact Us or call 1-877-932-8228
Hiding and Unhiding Rows and Columns

Hiding and Unhiding Rows and Columns

Hiding Rows and Columns

To hide rows or columns in a Microsoft Excel worksheet:

  1. Select a cell in your worksheet in the row or column you wish to hide. To hide multiple rows or columns, simply select multiple cells.
  2. On the HOME tab, in the Cells group, click the Format command.
  3. Select Hide & Unhide and then Hide Rows or Hide Columns:

Unhiding Rows and Columns

To unhide rows or columns in a Microsoft Excel worksheet:

  1. Select cells on either side (above and below or to the left and right) of the row(s) or column(s) you wish to unhide. Note: use your Shift key or make sure you have the whole range. Example:If you hide column E, then you must select column D thru F (including E).
  2. On the HOME tab, in the Cells group, click the Format command.
  3. Select Hide & Unhide and then Unhide Rows or Unhide Columns:
Next