Printing without formulas showing

S

saltnsnails

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!
 
G

Gary''s Student

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing a worksheet with and without formulas showing 1
Formulas not copying to other cells 10
Deleting blank rows with formulas in them 7
How to make a column of formulas all ROUND 1
In Exel 2000, stop the blank cells (with formulas) from printing. 1
automatically show cell references of formulas 2
IF and INDEX functions...I'm lost... 2
paste formulas between workbooks without workbook link 2

Top