ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing without formulas showing (https://www.excelbanter.com/excel-discussion-misc-queries/185359-printing-without-formulas-showing.html)

saltnsnails

Printing without formulas showing
 
I have a spreadsheet that has several formulas in it. Most people simply
enter the data and I print. However a few employees who are offsite need to
handwrite on the sheet. Is there an easy way to print my worksheet with the
formula cells appearing blank? This would save me a lot of time. Thanks!
--
-CRM

Gary''s Student

Printing without formulas showing
 
Easy:

Edit Goto Special Formulas OK
Format Cells... Font Color and pick the same color as the cell
background

The cells with formulas will appear blank.
--
Gary''s Student - gsnu200781


All times are GMT +1. The time now is 11:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com