Disappointments About Excel for MAC

[c308682]

Some of the features that are entrenched in the Windows version of
Excel were left off when Microsoft developed Office 2004 for MAC. F4
was the default shortcut key to make give a cell reference absolute
properties. From reading the Help in Excel 2004 for MAC, it sounds
like the $-signs have to be manually entered now.

- Has anyone found a comparable shortcut key to do make a cell
reference absolute?

- - I will add more of these shortcomings to this thread. Feel free to
add your discoveries that disappointed you.

 

[JE McGimpsey]

Some of the features that are entrenched in the Windows version of
Excel were left off when Microsoft developed Office 2004 for MAC. F4
was the default shortcut key to make give a cell reference absolute
properties. From reading the Help in Excel 2004 for MAC, it sounds
like the $-signs have to be manually entered now.
Nope.

- Has anyone found a comparable shortcut key to do make a cell
reference absolute?

Lots of folks. From Help ("Microsoft Excel keyboard shortcuts"):

CMD+T Toggle the formula reference style between
absolute, relative, and mixed

(And note that, since XL came out first on the Mac - before Windows,
much less WinXL - it's WinXL that introduced the incompatibility.)

- - I will add more of these shortcomings to this thread. Feel free to
add your discoveries that disappointed you.

You might want to check the archives first to make sure that the
"shortcomings" haven't already been addressed:

http://google.com/advanced_group_search?as_ugroup=*mac.office.excel*

 

[c308682]

Indeed