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

Hiding Columns and Rows

If you’re having trouble fitting your worksheet on the desired number of pages, or you want to prevent someone viewing the printout from seeing some confidential data, you can hide selected columns or rows. To hide columns or rows and prevent Excel from printing them, follow these steps:

1.
Drag over the column or row headers for the columns or rows you want to hide.

2.
Open the Format menu and select Column, Hide or Row, Hide. (Alternatively, right-click one of the selected columns or rows and select Hide from the context menu.) The selected columns or rows disappear, and a dark line appears on the worksheet to indicate that rows or columns are hidden.

3.
Click the Print Preview button. Excel displays the worksheet, omitting the hidden columns or rows.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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