+ Reply to Thread
Results 1 to 8 of 8

Place Tabs in Vertical direction without using any external add ins

  1. #1
    Registered User
    Join Date
    08-04-2014
    Location
    Chennai
    MS-Off Ver
    MS Office 2010
    Posts
    14

    Place Tabs in Vertical direction without using any external add ins

    Hi All,

    Can anyone help me if there is an option to place all tabs in a sheet in Vertical position without using any external add ins. Add ins of Microsoft however can be installed. Being a company user, we have restrictions to install add ins from external sources.
    Request your kind help.

  2. #2
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    9,331

    Re: Place Tabs in Vertical direction without using any external add ins

    an option to place all tabs in a sheet in Vertical position without using any external add ins
    Do you mean place tab names vertically?
    Dave

  3. #3
    Registered User
    Join Date
    08-04-2014
    Location
    Chennai
    MS-Off Ver
    MS Office 2010
    Posts
    14

    Re: Place Tabs in Vertical direction without using any external add ins

    Hi Dave,

    I meant to say place all sheets/tabs (Sheet1, Sheet2, Sheet3, Sheet4) within one file in vertical manner, rather than what it is placed by default in horizontal position. I have more than 10 sheets within one file which makes viewing them a bit complicated as the user has to scroll across. Just wish to make their life easy if I can place them in a vertical manner as it will also ensure that none of my sheets miss the attention of end users.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,946

    Re: Place Tabs in Vertical direction without using any external add ins

    Also not totally sure what you mean here

    If you want the sheet "tabs" to be shown up the side of the window, instead of at the bottom - dont think that is possible.

    If you want to just show the tabs SHOWN stacked 1 on top of the other at the bottom, instead of SHOWN side by side at the bottom, I dont think this is a (permanent) option either.

    However, if you rt-click on the the small square just above the "Ready" sign, it will list all sheets in a vertical manner to allow you scroll through and click 1
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,946

    Re: Place Tabs in Vertical direction without using any external add ins

    hmm another option would be to have an "index" sheet, which will give you a list of "clickable" sheet names

  6. #6
    Registered User
    Join Date
    08-04-2014
    Location
    Chennai
    MS-Off Ver
    MS Office 2010
    Posts
    14

    Re: Place Tabs in Vertical direction without using any external add ins

    Thanks Ford for your guidance. I am using Index sheet for the timebeing but was just wondering if Add-ins like Kutools can give such solutions, why no such solution by Microsoft has not been developed so far or some Add in has been developed but i am not aware of

  7. #7
    Registered User
    Join Date
    08-04-2014
    Location
    Chennai
    MS-Off Ver
    MS Office 2010
    Posts
    14

    Re: Place Tabs in Vertical direction without using any external add ins

    Sorry if I have not myself clear. yes, would like to have sheet tabs to be shown up the side of the window, instead of the bottom.

  8. #8
    Forum Contributor
    Join Date
    08-08-2005
    Location
    Kansas, USA
    MS-Off Ver
    2016
    Posts
    274

    Re: Place Tabs in Vertical direction without using any external add ins

    If you right-click on the tab navigation arrows to the left of the tabs, recent versions of Excel will provide a vertical list from which you may select the desired sheet. Does this do what you're after?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1