ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   A "Document Map" of worksheet tabs for Excel (https://www.excelbanter.com/setting-up-configuration-excel/31724-%22document-map%22-worksheet-tabs-excel.html)

BCS

A "Document Map" of worksheet tabs for Excel
 
I would find an interface similar to MS Words Document Map to be easier to
navigate than the worksheet tabs currently used.

While the tabs do have benefits (color coding, easy to reorganize, etc),
they are hard to navigate through to find the desired worksheet; especially
in a large workbook when the sheet names are long.

It would be easier if the tabs were organized into a list on the left side
of the screen (like the Document Map) rather than scrolling sideways through
a horizontal list. To save monitor real estate these could also be shown or
hidden through the use of the View menu on the Standard Toolbar.

----------------
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...ic.excel.setup

Anne Troy

Try right-clicking the navigation arrows at the left of the worksheet.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"BCS" wrote in message
...
I would find an interface similar to MS Words Document Map to be easier to
navigate than the worksheet tabs currently used.

While the tabs do have benefits (color coding, easy to reorganize, etc),
they are hard to navigate through to find the desired worksheet;

especially
in a large workbook when the sheet names are long.

It would be easier if the tabs were organized into a list on the left side
of the screen (like the Document Map) rather than scrolling sideways

through
a horizontal list. To save monitor real estate these could also be shown

or
hidden through the use of the View menu on the Standard Toolbar.

----------------
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...ic.excel.setup



Bob Phillips

You can create a Toc. See
http://www.mvps.org/dmcritchie/excel...c.htm#buildtoc

--
HTH

Bob Phillips

"BCS" wrote in message
...
I would find an interface similar to MS Words Document Map to be easier to
navigate than the worksheet tabs currently used.

While the tabs do have benefits (color coding, easy to reorganize, etc),
they are hard to navigate through to find the desired worksheet;

especially
in a large workbook when the sheet names are long.

It would be easier if the tabs were organized into a list on the left side
of the screen (like the Document Map) rather than scrolling sideways

through
a horizontal list. To save monitor real estate these could also be shown

or
hidden through the use of the View menu on the Standard Toolbar.

----------------
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...ic.excel.setup




All times are GMT +1. The time now is 09:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com