Hiding and Unhiding a Column or Row

graphics/microsoft20.gif

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, if you want to share a worksheet with others, but it includes confidential employee salaries, you can simply hide the salary column. 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 you need the data, you can unhide the sensitive information.

Hide a Column or Row

graphics/one_icon.jpg

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.)

graphics/tow_icon.jpg

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

graphics/04inf13.jpg

Unhide a Column or Row

graphics/one_icon.jpg

Drag to select the column or row header buttons on either side of the hidden column or row.

graphics/tow_icon.jpg

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

graphics/04inf14.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net