ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Make an option to have two rows of tabs in Excel so they don't ex. (https://www.excelbanter.com/excel-discussion-misc-queries/61295-make-option-have-two-rows-tabs-excel-so-they-dont-ex.html)

James

Make an option to have two rows of tabs in Excel so they don't ex.
 
If you make two rows of tabs in Excel, then it would be much easier to switch
between two sheets that are at the beginning and end of the tab order.

There should be an option to specify the number of tab rows that should be
displayed in the application

----------------
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...lic.excel.misc

Gord Dibben

Make an option to have two rows of tabs in Excel so they don't ex.
 
James

Until that option comes along...........

Right-click on one of the Sheet navigation arrows at bottom left corner to get
a list of sheets(16) to choose from.

If you have more, select "more sheets".

If interested, there are VBA methods of creating a Table of Contents or a
listing of sheets that you just click on to go to the one desired.


Gord Dibben Excel MVP

On Tue, 20 Dec 2005 14:05:02 -0800, "James"
wrote:

If you make two rows of tabs in Excel, then it would be much easier to switch
between two sheets that are at the beginning and end of the tab order.

There should be an option to specify the number of tab rows that should be
displayed in the application

----------------
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...lic.excel.misc



All times are GMT +1. The time now is 04:49 PM.

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