+ Reply to Thread
Results 1 to 3 of 3

How to open an Excel file with two tabs side by side

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    San Jose, CA
    MS-Off Ver
    Excel 2010
    Posts
    13

    How to open an Excel file with two tabs side by side

    Is there a way to open an excel file so that it automatically shows two tabs/sheets side by side? I know how to manually do this each time using the Window box of the View tab, but it would be much more efficient to have this done automatically every time I open the file. I'm open to doing this however...VBA is fine if that's the only way.

    The nutshell version of what I'm doing is I've got one worksheet that has planning information (tasks, hours for each task, dates the tasks will be worked on, etc) and another sheet that automatically figures out how much time I've got left available each day after taking all the information from the first sheet into account. At first I just had everything on one tab, which works okay until I start sorting the planning items. When the sort hides certain rows, it obviously hides some of the schedule information with my available time. That's why I moved the schedule to a different worksheet.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: How to open an Excel file with two tabs side by side

    http://office.microsoft.com/en-gb/ex...001217043.aspx
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    10-24-2012
    Location
    San Jose, CA
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: How to open an Excel file with two tabs side by side

    Thanks for the LMGTFY, but not helpful.

    Quote Originally Posted by Aegwyn11 View Post
    I know how to manually do this each time using the Window box of the View tab, but it would be much more efficient to have this done automatically every time I open the file.

+ 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