jump around a spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Park and Ride in to Central London? 2
Problems entering data in exel spreadsheet 3
How do I select the column cursor jumps to when I hit end enter? 1
Worksheet Jump 1
convert text to hyperlink 2
Windows 7 Scroll lists jumping to top 9

Back
Top