Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Navigator Window for Excel Speadsheet
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/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Navigator Window for Excel Speadsheet
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 On Fri, 14 Nov 2008 15:57:02 -0800, Ryan wrote: 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/comm...et.f unctions |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Navigator Window for Excel Speadsheet
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 "Ryan" wrote: 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/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import from Excel speadsheet | Excel Discussion (Misc queries) | |||
Excel Speadsheet GONE! | Excel Discussion (Misc queries) | |||
Excel Speadsheet | Excel Discussion (Misc queries) | |||
how do I protect a formula in an excel speadsheet | Excel Worksheet Functions | |||
How do I widen the Name Box Navigator in Excel? | Excel Worksheet Functions |