Excel

[stacyk]

One of the managers today, asked if you can print out the formula in Excel instead of the totals.

I don't think this can be done, but if someone know's how please let me know. As I love showing him how to do thing & being all smart & cleaver. He's one of these people who likes to think he know what he's talking about, he ask today if we used Microsoft, only because someone had mentioned it. (He was talking about MS Project)

Stacy

[andreadebiase]

hi, can you be more precise? if you are asking what I am thinking, all you have to do is go and double click in the cell where the number is, the formula (that gives that number) will appear in tha upper bar, remove the = sign and the formula will not compute any calculation but you should be able to visualize and print it.

[BigBlue66]

Hi Stacy,

As a matter of fact, there is a way to print formulas instead of the calculated number that they provide.

Open Exel. Go to Tools/Options/View. At the bottom of the page, under Windows Options, place a checkmark beside Formula. It will now display formulas in the cells. Of course, it will print like that, too.

One thing I should alert you to though, is that some formulas are quite long. You will have to adjust the width of the columns in some cases to allow for the entire formula in a cell to show up.

If you have several columns with large formulas in them, you may have to print the spreadsheet piecemeal. You will know what I mean when you actually have the formulas showing.

Cheers,

Big Blue 66

------------------
You have the right to remain silent. Anything you say will be misquoted, then used against you in a court of law.

[BigBlue66]

Hi Again Stacy,

I wasn't sure if you understood that you had to have the particular spreadsheet loaded that you want to print formulas from, before you set that option. Setting up the formula option on a blank spreadsheet will of course allow any formulas you type to be immediately seen, but the option is only active for that particular spreadsheet.

If you have a spreadsheet or two that is/are already created, again, make sure you load them before checking the formula option. Sorry to have been so vague before.

Cheers,

BB 66


------------------
You have the right to remain silent. Anything you say will be misquoted, then used against you in a court of law.

[This message has been edited by BigBlue66 (edited 03-23-2001).]

[stacyk]

Thanks everyone!

stacy