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

Chapter 4. Enhancing Your Spreadsheets > Hiding Rows and Columns

Hiding Rows and Columns

There may be occasions when you want to hide certain rows or columns in a spreadsheet, both on the screen and when you print the spreadsheet. For example, you may want to print out a phone extension list of your employees (to be used by everyone in the office), but that same spreadsheet lists the salary of each employee (which is sensitive information; not to be seen by everyone).

All you have to do is hide the row or column that contains the sensitive information. The information will “disappear” from the screen and in your printout. Be advised, however, that hiding rows or columns is a very easy process to reverse. If you wish to hide elements of a spreadsheet and then password-protect this action, you will need to use the Cell Protection feature discussed later in this chapter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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