MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to print cell contents as formulas, not results


Posted by Jim on December 19, 2000 5:19 PM

How do I print a worksheet so that only formulas print out. I need to know which cells have formulas so I can change those that don't.

Thanks for any help you might offer.

Jim


Posted by Bruce on December 19, 2000 6:11 PM

Select tools, options, and on the view tab, check the formulas button.


Posted by cutsman on December 20, 2000 10:47 AM

You could also press ctrl+ tilde (cycles formulas on and off) and print.