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, 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

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.

Unhide a Column or Row

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

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