excel formulas

[G. Marvis]

Is there a way to view all of the formulas in a
spreadsheet at once?

 

[kemal asad]

you can turn the option formula under tools, option. view click formula that
should show you all the formula of a worsheet instead of the calculated
results.
good luck
kemal

 

[Nick Hodge]

Press Ctrl+` It is keyboard specific, so it's always Ctrl + the key to the
left of the 1 on the top row of key. Pressing it again takes you out of
'formula view'

 

[Paul B]

One way Ctrl+` to toggle formulas and valves

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[J.E. McGimpsey]

One way:

Type

CTRL-`

(accent grave - to the left of the 1 and above the Tab key on a US
keyboard)In article <[email protected]>,

 

[mike w]

-----Original Message-----
Is there a way to view all of the formulas in a
spreadsheet at once?
.
yes try Ctrl~ (which is next to the number 1)