+ 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
    19

    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 Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    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
    19

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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
    19

    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
    19

    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
    293

    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)

Similar Threads

  1. Macro for workbook4 to place above data in a vertical position in cells below
    By Daddy007 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-07-2018, 09:20 PM
  2. [SOLVED] Moving chart vertical grid lines in a horizintal direction with VBA
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2017, 01:30 PM
  3. Replies: 6
    Last Post: 06-24-2015, 12:03 AM
  4. [SOLVED] [How] Place Horizontally Adjacent Cells in Vertical Format
    By chocochoco in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-17-2013, 06:00 PM
  5. Vertical tabs?
    By Tenwaited in forum Excel General
    Replies: 4
    Last Post: 05-31-2013, 11:30 AM
  6. Y-axis title cutting off in vertical direction
    By Martin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-11-2006, 02:30 PM
  7. How do I change my text direction to vertical on EXcell?
    By bibi in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-01-2005, 05:05 PM

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