Navigator Window for Excel Speadsheet

[Ryan]

It is hard to navigate though big spreadsheets and it would make sense to
have a navigator window to depict roughly where you are in a big spreadsheet.
This would be similar to the solution used for Viso. You can point to a
general area in the navigation window to quickly move to the actual region
referenced in the navigation window. Also you can have a scheme to memorize
the favorite views of a spread sheet and access those areas through some key
and/or mouse click combination. Think about how many times you have to
scroll right or left to get to regions in a big spreadsheet you are
interested in. We should make this process easier for the user.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[Gord Dibben]

Excel already has those features.............

Named ranges can be navigated to with a click of a mouse in the NameBox

Custom Views can be created and any view can be selected from a list.

Right-click on any Sheet tab to get a list of sheets to select from.


Gord Dibben MS Excel MVP

 

[Shane Devenshire]

Hi,

There is nothing in Excel equivalent to Visio's Pan & Zoom window, which is
what I suppose you are refering to? Consider that a Visio page is relative
small, the Pan & Zoom is provided so that if the zoom factor is high you can
navigate the single page relatively easily. In Excel a single sheet is huge
65,536 rows X 256 columns, in 2003 and about 1,048,000 rows X 16,374 columns
in 2007.

On the other hand we do have a couple of Zoom options in Excel depending on
the version you are using and that zoom runs from 10%-400%.

To navigate quickly, even between sheets, you can use range names, the more
descriptive the better. In addition to using the Name Box drop down to see
the possible choices as mentioned already, you can press F5 and see a list of
range names, which when double-clicked take you directly to the desired
range. You can also type cell addresses into the Name Box and navigate
directly to them, for example typing in Z10000 takes you directly to that
cell, or typing in F10:G20 selects that range.

You can keep track of your favories set ups using Custom Views as mentioned
in the previous email, you can also save various sets of data as Scenarios.

You can also setup hyperlinks to any area of your spreadsheet, or formula
links that can be used to quickly navigate to cells by pressing Ctrl+[ or
Ctrl+{

If this helps, please click the Yes button

Cheers,
Shane Devenshire