CTRL + H doesn't go to A1

P

Pete

If the first row is frozen; and you use the CTRL + H to go "home",
the cursor jumps instead too A2. Any good way to override that and
get it to A1? Could use F5. . . GO TO , but CTRL + H is so
convenient.
TIA for any ideas.
Pete
 
G

Gord Dibben

That's the price you pay for freezing top row.

I have never heard of a workaround other than GoTo or mouse-click

Save yourself a step and put the GoTo Icon on your Toolbar.

BTW Did you mean CTRL + Home?

CTRL + H opens the Find dialog for me in 2003 and 2007 Excel


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cursor to upper left of frozen cells (in macro) 11
Ctrl+PageUp after Ctrl+H 2
INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then repla 1
Excel 2007 - Macro Shortcut Key Doesn't Work 3
Automatically go to another cell 1
Macro to select last row 1
save as cell A1 to to a specific drive 3
Want only rows with populated data 1

Top