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.Format in Cells Group of Home Tab
  3. Select Hide & Unhide and then Hide Rows or Hide Columns:Hide Rows or 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.Format in Cells Group of Home Tab
  3. Select Hide & Unhide and then Unhide Rows or Unhide Columns:Unhide Rows or Columns
Next