command key to anchor fornula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fairgreen - 31 Oct 2007 16:12 GMT

Does anyone know command key to anchor formula? With windows excel,
it was F4. I can't seem to find it in help for Mac Excel...gracias!

Reply to this Message

CyberTaz - 31 Oct 2007 16:22 GMT

Command+T

For this & more see Excel Help on: shortcuts.

Regards |:>)
Bob Jones
[MVP] Office:Mac

On 10/31/07 11:12 AM, in article
1193843546.415143.101250@y42g2000hsy.googlegroups.com, "Fairgreen"
<byrna@btinternet.com> wrote:

Does anyone know command key to anchor formula? With windows excel,
it was F4. I can't seem to find it in help for Mac Excel...gracias!

Reply to this Message

Fairgreen - 31 Oct 2007 16:56 GMT

> Command+T
>
[quoted text clipped - 11 lines]
> Does anyone know command key to anchor formula? With windows excel,
> it was F4. I can't seem to find it in help for Mac Excel...gracias!

Yes...hd already done that. it should be the apple key + T. But it
doesn't work on a UK keyboard...where does one find UK shortcuts?

Reply to this Message

JE McGimpsey - 31 Oct 2007 18:36 GMT

> Yes...hd already done that. it should be the apple key + T. But it
> doesn't work on a UK keyboard...where does one find UK shortcuts?

Hmm.. wasn't aware it was different. Was the cell reference selected in
the formula bar when you tried it?

Reply to this Message

Mac Forum / Applications / Excel / October 2007

command key to anchor fornula