Ask Your Question

Keyboard shortcut to move to a specified column to the right?

asked 2019-03-16 15:00:38 +0100

Tobruk gravatar image


Is there any way to make a shortcut to go to a specified column? I have two often-used columns which have to be separated by many less-often-used columns, so I have to TAB my way to the right all the time.

I tried Control+Right arrow, but that takes me all the way to the end of the spreadsheet. A workaround would be to fill in the right column with probably zeroes, just so that when I press Control+Right arrow, it stops right there.

Any ideas? Thank

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-03-16 15:20:39 +0100

Lupp gravatar image

updated 2019-03-16 15:30:08 +0100

Basically I see five ways:
Rearrange your columns to better meet your needs.
You will most likely have one/some frozen columns/rows. In the frozen ranges you may dedicate a few cells containing "jump-to-links" created using the HYPERLINK() function.
Write a Sub with a few lines of user code and assign the Sub to a sensitive area (text or icon) in the standard toolbar.
Enter the target address into the Name Box and hit Enter.
Create named ranges for the targets and keep the Navigator open. You then can jump by DoubleClick.

If you want to do a far jump to another column, but to stay in the same row, I suppose you will need to use method -4- in a more subtle manner or to rely on user code.

edit flag offensive delete link more


Huh, I guess there's no easy way out of this :/ Thank you for your suggestions. I'll mark it as resolved.

Tobruk gravatar imageTobruk ( 2019-03-16 16:13:44 +0100 )edit

Do you think -4- isn't easy enough? (Or don't you know the Name Box? It's the field left of the little editor for formulas/contents outside of cells. That's directly above the column labels. Or did yo hide the FormulaBar?)

Lupp gravatar imageLupp ( 2019-03-16 16:26:22 +0100 )edit

Concerning -3- I missed to mention that you also can assign the Sub to a keyboard shortcut, and that you can get the needed code in a variant using the dispatcher with the help of the macro recorder. It's really simple in this case.

Lupp gravatar imageLupp ( 2019-03-16 16:28:29 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-16 15:00:38 +0100

Seen: 22 times

Last updated: Mar 16