'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Hide Excel Cell Values from Printing but Keep Them Visible
Question details
The user needs a way to prevent specific cell data (such as part costs and calculated totals) from appearing on printed pages, while still displaying those values on the spreadsheet screen.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Preparing a financial or operational spreadsheet for printing where certain sensitive calculations should only be visible to the digital user, not the recipient of the physical printout.
- Observed behavior
- By default, Excel prints all visible cell values exactly as they appear on the screen, meaning sensitive costs and totals are included on the printed page.
Identify the exact ranges or cells containing the costs and totals you want to exclude from the printout, and note their original font colors so you can easily restore them.
Temporarily Change Font Color to Match the Background
The most straightforward method to hide cell values from printing is to temporarily change their font color to match the worksheet background (usually white) right before you print.
Because Excel does not have a native 'Do Not Print' property for individual cells, matching the text color to the background color renders the text invisible on the printed page. After printing, you simply undo the action to restore visibility on your screen.
Highlight the specific cells containing the costs and calculated totals you want to hide.
Navigate to the 'Home' tab on the ribbon. Click the 'Font Color' dropdown and select the color that matches your cell background (e.g., White).
Go to File > Print (or press Ctrl + P) and print your spreadsheet. The hidden values will not appear on the paper.
Immediately press 'Ctrl + Z' (Undo) or manually change the font color back to Automatic/Black to keep the values visible on your screen.
Use a Non-Printing Text Box
If you want a more permanent setup without having to change colors every time you print, you can display the sensitive values inside a text box and disable its print property.
Group Sensitive Data into Dedicated Columns and Hide Them
By restructuring your spreadsheet to keep sensitive costs in specific columns, you can simply hide those entire columns before printing.
Control Your Print Output Easily in WPS Spreadsheet
WPS Office provides seamless formatting and printing controls, allowing you to manage exactly what appears on your printed spreadsheets while retaining full data visibility on screen.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet containing the data you want to print.
- 2. Highlight the sensitive cells: Select the cells containing the costs or totals that should be excluded from the printout.
- 3. Change font color: Go to the Home tab and change the font color to match your worksheet background (e.g., White).
- 4. Print the document: Press Ctrl + P to open the Print Preview. Confirm the values are hidden, then click Print.
- 5. Restore visibility: Press Ctrl + Z immediately after printing to undo the color change and restore the values on your screen.
Frequently Asked Questions
Can I use the `;;;` custom number format to hide cells from printing?
Yes, applying the `;;;` custom number format will hide the cell value from printing. However, this also hides the value on your screen. The data will only be visible in the formula bar when you actively click on the cell, which may not be ideal if you need to view the entire spreadsheet at once.
Is there a native 'Do Not Print' button for individual cells in Excel?
No, Excel does not have a native feature to flag specific cells as non-printable. You must rely on workarounds like changing the font color, hiding entire columns/rows, or utilizing non-printing shapes.
Can a macro automate hiding these cells before printing?
Yes. You can write a VBA macro using the `Workbook_BeforePrint` event to automatically change the font color of specific ranges to white right before printing, and a standard macro to restore the original color afterward. This requires saving the file as a Macro-Enabled Workbook (.xlsm).
