Shortcut to show formulas on screen

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gordon - 17 Sep 2004 14:56 GMT

Hi,

Someone once showed my how to do this but I can't remember
the shortcut. It shows formulas on the screen instead of
having to go to the formula bar and look at each cell.

THanks

Gordon

Reply to this Message

Bernard Liengme - 17 Sep 2004 15:00 GMT

CTRL+` (the key to left of 1 on top line of 'typewriter' keys)

Signature

Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

> Hi,
>
[quoted text clipped - 5 lines]
>
> Gordon

Reply to this Message

Gordon - 17 Sep 2004 20:19 GMT

THats what I was looking for

Thanks

Gordon

>-----Original Message-----
>CTRL+` (the key to left of 1 on top line of 'typewriter' keys)
[quoted text clipped - 10 lines]
>
>.

Reply to this Message

Max - 17 Sep 2004 15:02 GMT

Press CTRL + ` ("grave" key just above the "Tab" key)
to toggle between formula view and "normal" view

Alternatively:
Tools > Options > View tab > Check box for "Formulas" > OK

Signature

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

> Hi,
>
[quoted text clipped - 5 lines]
>
> Gordon

Reply to this Message