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.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.