Hide when printing

Copper Contributor

Is there a way to exclude a specific cell with text upon printing like in Open office calc?

3 Replies

@Dy34_ 

In Excel, you can hide specific cells or ranges from printing by using the "Print Settings" options. Here is how you can exclude a specific cell with text from printing:

  1. Select the cell or range of cells that you want to exclude from printing.
  2. Right-click on the selected cells and choose "Format Cells" from the context menu.
  3. In the "Format Cells" dialog box, go to the "Number" tab.
  4. Select the "Custom" category.
  5. In the "Type" field, enter three semicolons (;;;) and click "OK". This custom number format (;;; or ;;;) will make the selected cells appear empty and not print on paper.

Now, when you print your worksheet, the specific cell or range you formatted with the custom format will be excluded from printing. However, it is important to note that the cells will still exist in the worksheet and retain their content—they will just appear empty when printed.

Remember to save your workbook after applying the custom number format to preserve the changes.

Note: Keep in mind that this method will hide the content of the specific cell or range when printing. If you want to hide the cell completely, including its borders and any adjacent cells, you can also consider adjusting the cell properties, such as changing the font color to match the cell background color or resizing the cell to a very small size. The steps were processed with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

But i dont want the text to be invisible. i want the text to be still visible but it will not include in printing. just like in Open office calc.

@Dy34_ 

I apologize for the confusion. So far i know, in Excel, there is no built-in feature to directly exclude a specific cell from printing while keeping the text visible.

Here are some links on how to do this with workarounds.

How to prevent selected cells from printing, but have them visible?

How to prevent cell contents from printing in Excel?