How to fix the data of a cell in the worksheet?

[ZAMITIZ]

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

I want to fix the data of a cell in the excel worksheet by a keyboard comand? The way to do it manually is writing the sign $ in between the cell number, but there is an easy way to do it by just one comand in the keyboard as in windows, but i dont know how to do it in Mac office excel.

 

[CyberTaz]

The keyboard shortcut for an absolute reference is Command+T - for other
keyboard shortcuts do a search in Excel Help on that topic. Mac Excel also
gives you the ability to assign custom kybd strokes of your own to just
about any command or change most of the built-in keystroke assignments.

But before you ask No, F4 can't be assigned - it's owned by the OS.

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