Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create shortcuts to take me to parts of a spreadsheet?
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? |
#2
|
|||
|
|||
How do I create shortcuts to take me to parts of a spreadsheet?
Naming cells is one way to do it.
Select the points on the worksheet (or workbook for that matter) where you want the bookmark. Then click in the Name Box (the box to the left of the Formula Bar) type in a name for your bookmark and hit enter. Once youve built your bookmarks (as named cells) click the down pointing arrow in the Name Box and select the bookmark to which you want to move. "Patricia H." wrote: 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? |
#3
|
|||
|
|||
How do I create shortcuts to take me to parts of a spreadsheet?
This sounds like a job for the "Drawing" toolbar. Click
View-Toolbars-Drawing. This will show the Drawing toolbar, where you can annotate your spreadsheet in many ways, like adding arrows, comments, pictures, etc. "Patricia H." wrote: 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? |
#4
|
|||
|
|||
How do I create shortcuts to take me to parts of a spreadsheet?
I'd use the =hyperlink() worksheet function:
David McRitchie posted this and it might help you: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) Patricia H. wrote: 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? -- Dave Peterson |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Returning values in another spreadsheet | Excel Worksheet Functions | |||
Hyperlinking to Excel 2000 with a linked spreadsheet | Excel Discussion (Misc queries) | |||
Using Excel spreadsheet as input to Access | Excel Discussion (Misc queries) | |||
can i create a shortcut to open a spreadsheet read only? | Excel Discussion (Misc queries) | |||
How do I create spreadsheet that automatically updates numbers/va. | Excel Discussion (Misc queries) |