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
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.
Huh, I guess there’s no easy way out of this 
Thank you for your suggestions. I’ll mark it as resolved.
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?)
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.