Show/Hide Functions/Formulas

[Smirnoff]

For some reason the keyboard shortcut (Ctrl+`) does not toggle show/hide
function.

Selecting Tools>Formula Auditing>Formula Auditing mode works fine.

I am wondering if it is because I have regional (keyboard) settings set
to UK English Extended.

I know the `(grave) key works and have tried it with both Ctrl keys with
no luck.

Help please.

 

[Smirnoff]

For some reason the keyboard shortcut (Ctrl+`) does not toggle
show/hide function.

Selecting Tools>Formula Auditing>Formula Auditing mode works fine.

I am wondering if it is because I have regional (keyboard) settings
set to UK English Extended.

I know the `(grave) key works and have tried it with both Ctrl keys
with no luck.

Help please.

Sorry, should have added it's Office 2003.

 

[Dave Peterson]

I use a USA keyboard, so this is just a guess.

If you close excel and reopen it in safe mode, does ctrl-` work ok?

Close excel
windows start button|Run
excel /safe
Type in a formula and test it.

If that works ok, then maybe you have a macro that's been assigned to that
combination of keys.

 

[Smirnoff]

Have just tried that, same result I'm afraid.

I certainly don't remember assigning/creating a macro with this key
combination.
Have looked in Tools>Macros>Macros....... and there is none listed.

Thanks anyway.

 

[Smirnoff]

Have tried changing keyboard setting from UK Extended to just UK
keyboard. Ctrl+` toggle still doesn't work.
Can't figure out how selecting Tools>Formula Auditing>Formula Auditing
mode works but the key combination doesn't.
Have searched web but cannot find any references to problem. This is
driving me nuts.

Have just tried that, same result I'm afraid.

I certainly don't remember assigning/creating a macro with this key
combination.
Have looked in Tools>Macros>Macros....... and there is none listed.

Thanks anyway.

 

[Dave Peterson]

If you change to a USA keyboard, does it work?

Is your keyboard programmable? Have you programmed this key (or is it set up to
do something by default)?

(I don't have any guesses.)

Have tried changing keyboard setting from UK Extended to just UK
keyboard. Ctrl+` toggle still doesn't work.
Can't figure out how selecting Tools>Formula Auditing>Formula Auditing
mode works but the key combination doesn't.
Have searched web but cannot find any references to problem. This is
driving me nuts.

 

[Smirnoff]

Yes, changed to US and worked OK.
Seem to remember another poster saying that Ctrl+` worked fine with his
UK settings.
Fortunately, I have the Formula Auditing mode button in the toolbar, I
wouldn't want to keep changing settings.

However, I notice that in Control Panel>Regional
Settings>Languages>Details>Settings, if you highlight one of the
installed services and click Add or Remove, you can choose an input
language AND a keyboard layout.
Perhaps I should try UK English input language with US keyboard layout.
Christ they do make it complicated.
Thanks for your help and would appreciate any further comments

 

[Smirnoff]

Problem solved. I have an extended keyboard and that is what Excel
didn't like.

I have now selected UK English as input language and the normal English
keyboard rather than the extended option.

Can toggle to my hearts content now.
Phew!

Yes, changed to US and worked OK.
Seem to remember another poster saying that Ctrl+` worked fine with
his
UK settings.
Fortunately, I have the Formula Auditing mode button in the toolbar, I
wouldn't want to keep changing settings.

However, I notice that in Control Panel>Regional
Settings>Languages>Details>Settings, if you highlight one of the
installed services and click Add or Remove, you can choose an input
language AND a keyboard layout.
Perhaps I should try UK English input language with US keyboard
layout.
Christ they do make it complicated.
Thanks for your help and would appreciate any further comments

 

[Dave Peterson]

Thanks for posting back.

Now google has it for the next person.

Problem solved. I have an extended keyboard and that is what Excel
didn't like.

I have now selected UK English as input language and the normal English
keyboard rather than the extended option.

Can toggle to my hearts content now.
Phew!