View Single Post
  #1   Report Post  
David McRitchie
 
Posts: n/a
Default How do I create shortcuts to take me to parts of a spreadsheet?

Hi Patricia,
Depends on what you are doing
1) to go to a specific cell, use the name box to left of formula bar
2) to get from a specific cell that you don't want to be on, to get to
another cell that you want to be on there is protection, and there
are event macros.
http://www.mvps.org/dmcritchie/excel/event.htm

3) some macros
http://www.mvps.org/dmcritchie/excel/code/gotostuff.txt

One of my favorites, an event macro:
MATCH Worksheet Function in a macro as a substitute for hyperlinks,
in a a name and address list. (#match)
http://www.mvps.org/dmcritchie/excel/event.htm#match

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Patricia H." <Patricia wrote in message ...
I need to create bookmarks at various points in a spreadsheet to make it
faster to get around. does anyone know how to do it?