Excel has a trick for ‘hiding’ cells. With the cells selected, right-click, choose Format Cells and then set the format as Custom under the Number tab. Enter ;;; (three semicolons) as the format. The cell contents disappear but they’re still there and can be used in formulas.

Leave a Reply