Monday 6 August 2007

Hiding a cell in Excel

Have you ever found yourself wanting to hide a single cell in Excel so the content is not visible? Hiding a column or row is easy enough (Right-click on the header and choose Hide). But Excel does not provide an easy way of hiding a single cell.
The answer is to format the cell so that its content is not displayed.
To hide a single cell:
1. Select the cell
2. Format menu, Cells, Number tab
3. Select the Custom category
4. In the Type field, replace the content with ;;; (three semicolons)
5. Click on OK
Note that you can still see the cell's content in the Formula Bar, just not in the worksheet.
If you ever wanted to display the cell's content again, just apply one of the regular Excel formats to the cell.

No comments:

Analytics and Statistic

Blog Archive