Hiding Columns, Rows, and Cells in Excel (Hiding Cell Contents)

You have the ability to hide the contents of individual cells if you do not need to view their contents or you simply do not want to print certain cells.

1.      Select the cell(s) to be hidden

2.      From the Home command tab, in the Cells group, click FORMAT » select Format Cells...
The Format Cells dialog box appears.

3.      Select the Number tab

4.      Under Category, select Custom

5.      In the Type text box, type three semicolons ( ;;; ) 

6.      Click OK
The cells are now hidden.

To redisplay cell information:

1.      Select the cell(s) to be redisplayed

2.      From the Home command tab, in the Cells group, click FORMAT » select Format Cells...
The Format Cells dialog box appears.

3.      Select the Number tab

4.      Under Category, make the appropriate selection
The dialog box refreshes to display options corresponding to the selected category.

5.      Select the desired options

6.      Click OK
The cell(s) reappear.

Related Posts by Categories