"Bookmarks" Within a Worksheet

[sassymommacat]

Good morning, all - I'm new here, so please forgive if I make any forum faux pas!

I have an extensive spreadsheet (within a larger workbook) with three distinctive points to which I return frequently. Is there any way to mark these points and set some kind of shortcut key for quick return so I won't have to continually scroll to get to these points?

Many thanks in advance to anyone that can assist!

Best regards,
smc

[Chris 53]

Give the three areas names. You will then be able to select those names from the name box.

Select a single cell for one of the areas. Type a meaningful name into the Name box 'Name1'. Press enter.
Repeat for the other areas.

Then in the Name box drop down list you will see your names and can select them.

Name Box is where the cell address appears at the top left of the sheet.

Hope this helps

Chris

[ChemistB]

Then to return to A1, you can type A1 into name box and Enter or just hit CNTRL + HOME

[ChemistB]

If you are sharing the workbook and you want something that will be easier for everyone, you can insert hyperlinks into 3 cells at the beginning of the worksheet, and maybe at each critical point (see example)
Insert Tab> Hyperlink> "Place in this document"

[sassymommacat]

Thanks so much, Chris - this is exactly what I needed!

Best regards,
smc

[sassymommacat]

Thanks for the tip - appreciated!

[sassymommacat]

I appreciate all of you that responded - I tried to reply to individual responses twice before I realized it wasn't attaching my response to the actual reply

I appreciate all of your input! Chemist B, I'll remember this for future use if I end up sharing with others. For my purposes at the moment, Chris's suggestion is more aligned with my current needs.

Thanks, again! So glad I found this forum!

smc