• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Excel Essentials > Hiding Rows and Columns

Hiding Rows and Columns

On some worksheets, you need to use rows or columns to hold data used in calculations, but you don't need to clutter up the rest of the worksheet by showing it. Click any cell within the row or column you want to hide (you don't need to select the entire row or column) and choose Format, Row, Hide or Format, Column, Hide.

To make a hidden row visible again, select cells in the row above and below the hidden row, and then choose Format, Row, Unhide. To display a hidden column, select cells in the columns to the left and right and choose Format, Column, Unhide.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint