"Lock" data before "dragging" data?

J

JusjongKull

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm new to Excel:Mac, and I've been using the "$$"-function, to lock the coloumn chosen, e.g. $A$1 (F4 in Win Excel 03).

Hope you know what I mean? I'm not used to english office either, so haven't been able to search properly, sorry for the inconvenience caused.

What is the hotkey to this command now-a-days in the Macworld? I'd really appreciate it. Thank you!
 
J

JE McGimpsey

I'm new to Excel:Mac, and I've been using the "$$"-function, to lock the
coloumn chosen, e.g. $A$1 (F4 in Win Excel 03).

Hope you know what I mean? I'm not used to english office either, so haven't
been able to search properly, sorry for the inconvenience caused.

What is the hotkey to this command now-a-days in the Macworld? I'd really
appreciate it. Thank you!

The MacXL keyboard shortcut for changing absolute/relative address modes
is the same nowadays as it was before XL for Windows even existed: CMD-t

You can find this and other default keyboard shortcuts by searching for
"keyboard shortcuts" in Excel Help.
 
J

JusjongKull

I'm new to Excel:Mac, and I've been using the "$$"-function, to lock the
coloumn chosen, e.g. $A$1 (F4 in Win Excel 03).

Hope you know what I mean? I'm not used to english office either, so haven't
been able to search properly, sorry for the inconvenience caused.

What is the hotkey to this command now-a-days in the Macworld? I'd really
appreciate it. Thank you!

The MacXL keyboard shortcut for changing absolute/relative address modes
is the same nowadays as it was before XL for Windows even existed: CMD-t

You can find this and other default keyboard shortcuts by searching for
"keyboard shortcuts" in Excel Help.
[/QUOTE]

Thank you so much! I didn't know the name of the command, so I couldn't find the hotkey in Help. Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top