Hiding A Specific Cell
You can use Excel to hide and password spreadsheets, but what if all you want to do is hide a cell or two. Well you can hide a cell or a specified range of cells by simply changing their format. Follow these instructions:
- Select the cell or range of cells you desire to hide.
- Then execute a right-click on the cell or range and select Format Cells.
- Then select Custom and highlight the data in the box that is probably all zeros, and replace the data with three semicolons (;;;). Then click the OK button.
Your cell or range of cells is now hid. To get the data back just repeat the process and change the formatting to something else like General or a Number format.
Tip is extracted from Tipworld, visit their website for more tips by clicking on the globe
Just click on the button for the Tiproom's Home Page.
Date of last revision: 29 August 2001.