Go To Special... Shortcut Key

[Airfreeze]

My apologizes if this has already been answered. I looked all over and couldn't find it.

I am using Excel 2008 for a Mac. My goal is to select all blank cells in a section I've highlighted. I know that I can press Control+G, then Command+S to get to the Go To Special page, which provides the ability to select 'Comments', 'Constants', 'Formulas', 'Blanks', and so on. From this window, I don't know how to use my keyboard to move the selection from the default of 'Comments' down to 'Blanks'. I've tried the up and down arrows, pressing Tab, and a bunch of other possible solutions, but I can't find how to get to the 'Blanks' option without using my mouse.

Anyone know how to do this without using a mouse?

Thanks!

 

[Scott Huish]

I'm not on a MAC, but maybe something like this will work like it does on a PC.

CTRL-G, ALT-S, k

 

[mikerickson]

On my Excel 2011, I can't find a way to set an individual hot key to GoTo Blanks.
Excel 2008 doesn't support VBA, so that route is out. You could write an AppleScript to do this, but invoking the A.S. would be almost as tough as using Excel's interface.

You want this to apply to all workbooks, correct?

 

[Airfreeze]

Thanks for the suggestion. I tried that - CTRL-G, ALT-S, k - and pressing the 'k' doesn't select the 'blank' option. Bummer.

 

[RoryA]

I'm not at a Mac at the moment, but do you have Full Keyboard Access set to 'All Controls' in the System preferences?

 

[Airfreeze]

Yeah, I want it to apply to all workbooks.

 

[Airfreeze]

I tried to find 'All Controls' in System Preferences and couldn't find it. Is that under a category in System Preferences?

 

[RoryA]

As best I recall, it's:
System preferences
Keyboard
Keyboard shortcuts, then it's an option at the bottom.

 

[Scott Huish]

Is there any letter that is underlined in the word Blanks when you get to the GoTo Special menu?

 

[RoryA]

No underlines but f5, Cmd+SK still works.