"table of contents" senario

[RGlade]

In Word, you can scroll through pages of information but have a hyperlink set
up so if you want to return to a particular section, it takes you right
there. I would like to do this in Excel. I have the top pane frozen, so I
can put a button or a formula in any particular cell. Then, while inputing
data in the spreadsheet, I want to move from one section to another without
having to SCROLL forever, I would like to be able to click the hyperlink or
cell to take me there. One thing, I will be needing to insert rows
throughout the document, so....as of now, I have not been able to make it
point to that "string" of text, if I reference one particular cell. Should I
make it search for a string of text to find the cell? if so, how?

 

[Max]

One play is to use single cell defined names for the quick navigation from
point to point, even across sheets. Use the namebox (just to the left of the
formula bar) to quickly create the names, with the point cells selected. Eg
suppose your 1st waypoint is X2. Select X2, then click inside the namebox,
input: _1, then press Enter. Suppose the 2nd waypoint is CH2. Name this in
the same manner as: _2, and so on. Then to navigate quickly to X2 from
wherever you are, just click the namebox's droplist, choose: _1 and you'll be
whisked there in an instant.

 

[RGlade]

I do believe that is going to work. Thank you so much!!!!!!!!!!!!! Awesome.

 

[Max]

Welcome, RGlade

 

[RGlade]

But wait, I want it to do that on each tab/sheet. I don't want it to cross
over sheets.

 

[Max]

Name it a little different on each sheet, then.
Eg for sheet: a, you could have it as: _1a, _2a, etc
for sheet: b, you could have it as: _1b, _2b, etc

 

[RGlade]

Seems a bit unuser friendly. Oh well, thank you for your quick response.

 

[Max]

No problem.