jump around a spreadsheet

J

Joel

Hi I was wondering if there was a way of placing anchors on a spreadsheet so
i could jump from certain points. thank you

Joel
 
G

Gord Dibben

You can give a cell or range a defined name and jump to that using F5 and click
on the name.

Set up a bunch of these names to select from.

Insert>Name>Define will get you started.


Gord Dibben MS Excel MVP
 
D

David McRitchie

Hi Joel,
My guess is that you are not looking for hyperlinks
or going to a named cell/range. If you want to go to
a specific cell you can type in the address into the name
box Gord mentioned, the defined name is further refinement.

My guess is something more along the lines of jumping
from one column to another. See
Worksheet_SelectionChange (#ws_sc)
http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc

Another way would be to protect cells so that one cannot
enter data into them, but that keeps you from inserting and
deleting.
 
Top