jump around a spreadsheet
 

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
--
N/A

jump around a spreadsheet
 

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.

InsertNameDefine will get you started.


Gord Dibben MS Excel MVP


On Fri, 24 Aug 2007 16:50:00 -0700, Joel wrote:

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

jump around a spreadsheet
 

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.

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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.

InsertNameDefine will get you started.


Gord Dibben MS Excel MVP


On Fri, 24 Aug 2007 16:50:00 -0700, Joel
wrote:

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