How to assign all the Windows shortcuts onto Mac Excel?

[DANIEL S.]

An example: To delete a column on Windows, I use the keyboard shortcut
Cntrl+EDC (meaning, hold Control, type E for EDIT menu, then D for DELETE,
then C for COLUMN).
I would like to set Excel for Macintosh (using OS-X (10.4.4) to enable
this function for all the keyboard shortcuts in this way.

Is it possible to set a Preference or use some other method of enabling this
on Excel for Mac without having to program them individually?

 

[JE McGimpsey]

An example: To delete a column on Windows, I use the keyboard shortcut
Cntrl+EDC (meaning, hold Control, type E for EDIT menu, then D for DELETE,
then C for COLUMN).
I would like to set Excel for Macintosh (using OS-X (10.4.4) to enable
this function for all the keyboard shortcuts in this way.

Is it possible to set a Preference or use some other method of enabling this
on Excel for Mac without having to program them individually?

No, and you can't really do the menus that way, nor use multiple-key
shortcuts. You can use the System Accessibility options to operate the
menus, but it won't be the same (for instance, you need to use arrow
keys to select a menu in the main menu bar).

You might try assigning individual single-key-with-modifiers shortcuts
to commands using Tools/Customize (for instance, perhaps CMD-OPT-C for
Delete Column). It's more efficient than using the menu method.

 

[DANIEL S.]

Many thanks for the prompt reply. Your reply appears at odds with this info
on the Mactopia website:
[[ Customizable keyboard shortcuts. Have it your way. Set the keyboard
shortcuts to function as they did in Excel 98, or customize your preferences
]]

In any case, it's a pity that Microsoft didn't include this in Excel/Mac.
It's a real timesaver on the Windows Excel.

 

[CyberTaz]

And if you don't object to a little use of the mouse, you can, for
example, Ctrl+Click in a column, then type D,C,Return.

Regards |:>)

 

[JE McGimpsey]

In any case, it's a pity that Microsoft didn't include this in Excel/Mac.
It's a real timesaver on the Windows Excel.

It's probably largely a matter of what you're used to. I almost never
use menu commands, so it's hard for me to remember sequential key
sequences. OTOH, I *really* wish MS would implement customizable
single-key shortcuts in WinXL.

The biggest thing for me, however, is that I wish MS would have stuck
with the original keyboard shortcuts, instead of changing them when they
ported XL from Mac to Windows. Even after 15 years, I still get them
wrong when I work in WinXL...