Hiding Data on an Excel Spreadsheet

Suppose you need to hide a small section of data in Excel, but you still want to calculate with it.

  1. Highlight the cells, right-click, and select Format Cells.
  2. Click the Number tab, and select the Custom category on the left.
  3. Type three semicolons (;;;) in the Type: field, and click OK.

The numbers are invisible, but you can still use them.


Leave a Reply

Your email address will not be published. Required fields are marked *