Excell 2000

Is there a way that you can print out a worksheet with only formulas. If so how?. (If you know of any web-sites that have information like this please post it) Thank You.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I don't have Excel 2000 on the machine I'm using at the moment, but I believe this still works with their 2000 product -

Go to Tools, Options.  In the View folder tab, put a check in front of FORMULAS.  Click OK.

Your screen will now show the formulas rather than the values.  You may, at this time, want to adjust your column widths to show the entire formulas.  When you print this spreadsheet, the formulas will print.

NOTE: This setting in Tools, Options was just for this worksheet -- you will not need to go back and change unless/until you want this particular worksheet to go back to values (and not show formulas).

Hope this helps!



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows OS

From novice to tech pro — start learning today.