Big sheet..neeed to jump from place to place

I have received great help from this forum before, so hoping to hit the jack pot twice. :p

I'm a realtive neophyte when it comes to Excel. I have a large worksheet (I need to keep this on a single sheet) and would like to have buttons, or a drop down box, or something that would allow the end user (who will also be Excel newbies) to click use those buttons (or whatver works best) and have it take them to that representative portion of the sheet, i.e. The sheet might have a valve section, copper fitting section, brass fitting section, appliance cord section, etc. The buttons at the top of the sheet would represent each of those categories, and clicking them would wisk the user to that section.

I hope I explained that o.k., and I hope someone can help.

I do appreciate the effort.

Roger

Hi,

The simplest was is to define names ranges. To do this, select the range, or cell you'll want to jump to, and then Insert > Name > Define and type in a name. Repeat for all the ranges / cells.

You can then select them from the drop down name box on the toolbar (just above cell A1.

HTH,

Dave

Buttons are not really necessary
You could name the different sections:
- select the section
- Menu Insert - Name - define
- Give a name to your section
- insert an hyperlink in an empty cell to the section name ( follow the wizard)
( don't forget to add an hyperlink in the section taking the user back to the hyperlinklis

Wow! Thanks for the quick answer and tips guys!

The main thing I have to acheive (besides getting the user to the proper spot) is the function that does this has to be so obvious, that they would have to have their eyes shut to miss it. It's for that reason, I mentioned the buttons idea. Most folks know about depressable buttons from navigating the web now-a-days. From what I know, they can be made any size, and therefore rather obvious.

It's because of this the drop down list from the toolbar won't work. It's to obscure to the novice user of Excel (from my experience as a novice user :p).

It looks like of the two options offered, the Hyperlink will be my best.

Thanks again for the quick response guys. I seem to always be able to count on this excellent forum to get quick helpful advice!

Roger

Thx for the feedback