"table of contents" senario
 

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?

"table of contents" senario
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RGlade" wrote:
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?

"table of contents" senario
 

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

"Max" wrote:

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RGlade" wrote:
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?

"table of contents" senario
 

Welcome, RGlade
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RGlade" wrote in message
...
I do believe that is going to work. Thank you so much!!!!!!!!!!!!!
Awesome.

"table of contents" senario
 

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

"Max" wrote:

Welcome, RGlade
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RGlade" wrote in message
...
I do believe that is going to work. Thank you so much!!!!!!!!!!!!!
Awesome.

"table of contents" senario
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RGlade" wrote in message
...
But wait, I want it to do that on each tab/sheet. I don't want it to
cross
over sheets.

"table of contents" senario
 

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

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RGlade" wrote in message
...
But wait, I want it to do that on each tab/sheet. I don't want it to
cross
over sheets.

"table of contents" senario
 

No problem.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RGlade" wrote in message
...
Seems a bit unuser friendly. Oh well, thank you for your quick response.