Ask Your Question
0

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

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

Tobruk gravatar image

Hi,

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
0

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

Lupp gravatar image

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

Basically I see five ways:
-1-
Rearrange your columns to better meet your needs.
-2-
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.
-3-
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.
-4-
Enter the target address into the Name Box and hit Enter.
-5-
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

Comments

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

Stats

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

Seen: 22 times

Last updated: Mar 16