[Webinar] Streamline your web hosting managementRegister Today


Excell 2000

Posted on 1999-11-03
Medium Priority
Last Modified: 2013-12-28
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.
Question by:mikefromcarson
1 Comment

Accepted Solution

acctsol earned 100 total points
ID: 2181980
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!



Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most folks would know the basics of how Dropbox works, so that’s not the purpose of this article. Security is what it’s all about, so here I’ll share how I choose to secure my Dropbox Account and the Data it contains.
This article provides a step by step guide (with screenshots) showing how to create a new local (test) Administrator user profile in Windows 10 for troubleshooting purposes, and then how to remove it.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question