Suppose you need to hide a small section of data in Excel, but you still want to calculate with it.
- Highlight the cells, right-click, and select Format Cells.
- Click the Number tab, and select the Custom category on the left.
- Type three semicolons (;;;) in the Type: field, and click OK.
The numbers are invisible, but you can still use them.