Printing formulas in ExcelXp 1

[Waxaholic]

Is it possible to print formulas in an ExcelXp spreadsheet?Preferably a range of cells instead of just one. I want to use this to validate them against external formulas that are on paper.

Thanks,

Waxaholic

 

[Dreamboat]

Should be Tools-Options, Print tab and choose Formulas.

Using it that way, you can't really do it for a range, just the whole thing.

If you want to do it for just a range, you could (save the workbook and) put an apostrophe (') in front of all the cells that have formulas you want to print, print it (this causes the formulas to be seen as text, so no print settings need to be changed), close it and don't save it.
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[Waxaholic]

Thanks Dreamboat but ExcelXp doesn't have a Print tab under Tools:Options. There is a check box to show formulas in normal view so i guess i will try that. Should be similair to the apostrophe tip you mentioned above. Thanks again.

Waxaholic

 

[Dreamboat]

Gee. Neither does 2000. Doh!

Yep, show formulas and then print. LOL
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[vbMax]

Another fast way to display formulas is to press
CTRL + `. (Note: ` is the accent mark, above the
tab key on your keyboard - and not an apostrophe.)

 

[Waxaholic]

Thanks vbMax. That will come in handy.

Waxaholic

 

[Dreamboat]

Nice one, Max.
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[MrsTFB]

So much XP knowledge here, please read my XP OUtlook post from today, pressure from boss to figure this one out.

Thanks for ANY help!
Bsimm