How to change cmd-`

[B-r-u-ce]

In all of MS Office '04, cmd-` rotates the windows. Even works in Finder.

This *doesn't* work in Excel - is there a way to delete Excel's command? (it
is listed under help as "Display Formulas or Values" but there is apparently
no equivalent menu command). I'd like to remove Excel's internal command and
reassign it so that the universal cmd-` would work in Excel as it does
everywhere else.

Thanks.

 

[Neill Massello]

In all of MS Office '04, cmd-` rotates the windows. Even works in Finder.

This *doesn't* work in Excel - is there a way to delete Excel's command? (it
is listed under help as "Display Formulas or Values" but there is apparently
no equivalent menu command). I'd like to remove Excel's internal command and
reassign it so that the universal cmd-` would work in Excel as it does
everywhere else.

Command + ` does cycle through windows, but Excel doesn't correctly
switch the focus to follow the front window. To do that, you have to use
Control + Tab. (Control + ` switches between the display of formulas and
values.) I don't think there's any way to change this. Maybe the next
version of Excel will get it right. At least we can now edit *some* of
the keyboard shortcuts.

 

[JE McGimpsey]

In all of MS Office '04, cmd-` rotates the windows. Even works in Finder.

This *doesn't* work in Excel -

This works for me in XL04, too. Have you reassigned the keyboard
shortcut?

is there a way to delete Excel's command? (it
is listed under help as "Display Formulas or Values" but there is apparently
no equivalent menu command).

Display formulas or values is the command assigned by default to CTRL-`,
not CMD-`.

Using CTRL-` is equivalent to checking the Formulas checkbox in
Preferences/View.

I'd like to remove Excel's internal command and
reassign it so that the universal cmd-` would work in Excel as it does
everywhere else.

if you find it at Display Formulas or Values, delete it - I believe it
should then revert.

If not, try, with XL closed trashing your XL preferences
(com.microsoft.Excel.prefs.plist in the ~:Libraryreferences:Microsoft
folder). Empty the trash before restarting XL.

 

[B-r-u-ce]

Command + ` does cycle through windows, but Excel doesn't correctly
switch the focus to follow the front window. To do that, you have to use
Control + Tab. (Control + ` switches between the display of formulas and
values.) I don't think there's any way to change this. Maybe the next
version of Excel will get it right. At least we can now edit *some* of
the keyboard shortcuts.

I tried this again. Command + ` is the same as control + ` on my Excel. I
then deleted the Excel prefs in my home directory and emptied the trash; it
made no difference. So I logged in as another user; the other user has the
SAME problem.

Control + tab works, so I'll have to use that in Excel until I find out what
the heck is going on.

 

[B-r-u-ce]

This works for me in XL04, too. Have you reassigned the keyboard
shortcut?

No, the OS X default is to assign command-` to "Rotate windows" and I have
left it like that.

Display formulas or values is the command assigned by default to CTRL-`,
not CMD-`.

OK, but cmd-` does this for me and other users on my machine (10.3.6)

Using CTRL-` is equivalent to checking the Formulas checkbox in
Preferences/View.

For all users, CTRL-` is the SAME as cmd-` only in Excel.

if you find it at Display Formulas or Values, delete it - I believe it
should then revert.

Couldn't find it anywhere except in help.

If not, try, with XL closed trashing your XL preferences
(com.microsoft.Excel.prefs.plist in the ~:Libraryreferences:Microsoft
folder). Empty the trash before restarting XL.

I deleted the plist file after quitting Excel. Emptied the trash. Still
happens.

This is the ONLY weirdness on my machine. Hmmm.

 

[Neill Massello]

Command + ` does cycle through windows, but Excel doesn't correctly
switch the focus to follow the front window.

I checked again and was pleased to see that this bug in Excel X has been
fixed in Excel 2004: Command + ` now switches the focus along with the
window.