Stop a cell from displaying and printing
You can use a Custom number format to stop a cell or range from displaying and printing.
Select the cell or range
Press Ctrl + 1
Use the 1 on the keyboard not the numeric keypad. In the Number tab click the Custom option (bottom left-hand side)
In the Type box enter
;;;
Click OK
This doesn’t stop the contents of the cell from displaying in the Formula bar.
Please note: I reserve the right to delete comments that are offensive or off-topic.