How to hide a row or column

To hide a row, first select the row you want to hide

1. Click on the ‘Home’ tab

2. Click on the ‘Format’ Command

A drop-down box will appear

3. Scroll down to the ‘Hide & Unhide’ command

Another drop down box will appear with the options to:

  • Hide rows
  • Hide columns
  • Hide sheet
  • Unhide rows
  • Unhide columns
  • Unhide sheet

4. Choose the ‘Hide rows’ command

how to hide a row or column

5. Excel will hide the row you selected, and a thicker border will appear there signifying a hidden row.

how to hide a row or column 1

You can follow the same steps above to:

  • Hide columns
  • Hide sheet
  • Unhide rows
  • Unhide columns
  • Unhide sheet

 

Lesson 23: How to freeze rows

Submit a Comment

Your email address will not be published. Required fields are marked *