Hiding and Revealing Columns or Rows


In this topic, you will learn how to hide and reveal columns (or rows) in an Excel spreadsheet.

 


Steps:

  1. To hide a column (or row):

     

    Select a cell within the column to be hidden.

     

    Step 1
  2. Click the Home tab.

    Step 2
  3. In the Cells Group, select Format 

    Step 3
  4. Under the Visibility section, select Hide & Unhide

    Step 4
  5.  Hide Columns

    Step 5
  6. The column is hidden.

    Step 6
  7. To unhide a column (or row):

     

    Select the column adjacent to the hidden column.

    Step 7
  8. While holding the [Shift] key select the other column adjacent to the hidden column.

    Step 8
  9. Click the Home tab.

    Step 9
  10. Click Format in the Cells Group

    Step 10
  11. Under Visibility, select Hide & Unhide

    Step 11
  12. Select Unhide Columns

    Step 12
  13. The column is revealed.

    Step 13

After completing this topic you can hide and reveal columns (or rows) in an Excel spreadsheet.