[mso] Re: Printing out Cell Formulae

Thanks Linda, You're a S*T*A*R !!

Smiles,

That Guy In Africa...
http://homepages.gds.co.za/northcom/
********************************************
ICQ#  39461303
~ Greetings from Sunny South Africa ~
********************************************

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Linda Johnson
Sent: 29 April 2002 09:40 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Printing out Cell Formulae



Sure, Eric....you can do this from the Tools>Options menu, click on the
View tab and put a check beside "Formulas", then print it and go back
and uncheck Formulas

OR a nifty shortcut is to hold down your control key and hit `  (` is
the key above your tab key which also includes the tilde [~])....this is
a toggle.....so hitting ctrl+` displays your formulas, then hitting it
again turns them off

Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
www.personal-computer-tutor.com
Author/Teacher ~ MS Office EBooks/Classes
www.personal-computer-tutor.com/services.htm


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Eric Skeen
Sent: Monday, April 29, 2002 2:33 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Printing out Cell Formulae



Hi All -

This is a great group and small clueless minds like mine learn a lot
from the mountains of expertise presented here.

I am just wondering if I can print out an Excel sheet with the cell
contents displaying the inserted formulae instead of the result, i.e.:
if I have a formula such as:  =((1000+190)*1.14+(200+b1)*d1+600 in place
of the obtained result.

I have 12 pages of quotes to check for accuracy, and I would rather do
it in hard copy than from the computer screen.

Please note the formula above is for descriptive purposes only, and not
the actual formula.

TIA,


*************************************************************
PLEASE READ!!!!

This is not S*P*A*M!  You are receiving this mail because you either
subscribed to mso@xxxxxxxxxxxxx or to it's earlier version,
MicrosoftOffice@xxxxxxxxxxxxxxxx

To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with a subject line that says "unsubscribe" (without the quotes).  Do not
put unsubscribe IN CAPS.  Screaming doesn't get you out any faster and the
caps prevent the function from working.

To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.

http://www.freelists.org/webpage/mso
*************************************************************
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.351 / Virus Database: 197 - Release Date: 2002/04/19

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.351 / Virus Database: 197 - Release Date: 2002/04/19

*************************************************************
PLEASE READ!!!!

This is not S*P*A*M!  You are receiving this mail because you either subscribed 
to mso@xxxxxxxxxxxxx or to it's earlier version, 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with 
a subject line that says "unsubscribe" (without the quotes).  Do not put 
unsubscribe IN CAPS.  Screaming doesn't get you out any faster and the caps 
prevent the function from working.

To change your email settings to digest or vacation (no mail), visit the 
group's homepage for full instructions.

http://www.freelists.org/webpage/mso
*************************************************************

Other related posts: