short cuts formular view

[Sšören Horst]

OS 6.1.3 Office 2008 12.

Hello Folks,

Is there any shortcut for to view the formulas, such as strg + '#' in
excel 2007

Thanks for your help

Soeren

 

[John McGhie]

Yeah: Look in the formula bar.

OS 6.1.3 Office 2008 12.

Hello Folks,

Is there any shortcut for to view the formulas, such as strg + '#' in
excel 2007

Thanks for your help

Soeren

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[Sšören Horst]

Yeah: Look in the formula bar.

I know that the formulas are visible in the formular bar, but in Office
2007 you can view the formulas in all cells by pressing ctrl + "#" in
2008 you have to click on excel --> preferences and so on, thats 5
clicks instead of one shortcut..
So i'm looking for this shortcut

 

[John McGhie]

Hi

To show or hide formulas on a sheet, press CONTROL+`(grave accent).

See the Excel Help topic "Print with formulas displayed"

Sorry, doesn't look like you can re-assign that one.

Cheers

I know that the formulas are visible in the formular bar, but in Office
2007 you can view the formulas in all cells by pressing ctrl + "#" in
2008 you have to click on excel --> preferences and so on, thats 5
clicks instead of one shortcut..
So i'm looking for this shortcut

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]