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

Chapter 7. Creating a Worksheet with Exc... > Hiding and Unhiding a Column or Row

Hiding and Unhiding a Column or Row

Not all the data on a worksheet should be available to everyone. You can hide sensitive information without deleting it by hiding selected columns or rows. For example, you can hide the patient name and address columns so that they are not readily displayed. Hiding columns and rows does not affect calculations in a worksheet; all data in hidden columns and rows is still referenced by formulas as necessary. Hidden columns and rows do not appear in a printout either. When the hidden data is needed, you (or other users) can unhide the sensitive information.

Hide a Column or Row

Click the column or row header button of the column or row you want to hide. (Drag to select multiple header buttons to hide more than one column or row.)

Click the Format menu, point to Column or Row, and then click Hide.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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