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?
|