Results 1 to 3 of 3

Thread: How to turn on View Side by Side Sheet option in Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    59

    How to turn on View Side by Side Sheet option in Microsoft Excel

    I am using Excel 2007. Want to see two sheets in same workbook. Help tells me how to do it with the "View Side by Side" option, but that option is grayed out for me. Help nicely notes that this function works only when the "View Side by Side" option is turned on, but doesn't tell me how to turn it on!

  2. #2
    Join Date
    Jul 2011
    Posts
    623

    Re: How to turn on View Side by Side Sheet option in Microsoft Excel

    Open two workbooks > (will enable the 'View Side by side' option). Now click on the option. (If this do not work click on the 'Restore down' button once and try again). If you want to compare the sheets of same workbook (right click the sheet tab> create a copy).

  3. #3
    Join Date
    Aug 2011
    Posts
    695

    Re: How to turn on View Side by Side Sheet option in Microsoft Excel

    I re-read Help and realized I had skipped a step - opening the new window. Now everything works as expected. This is not a tough job. If you cannot find anything just follow the help below.

    View two or more worksheets at the same time

Similar Threads

  1. How to get side by side row labels in Excel 2007 Pivot Table
    By The-Farmer in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 06:01 PM
  2. Replies: 4
    Last Post: 16-04-2011, 02:49 AM
  3. Cannot open two excel files side by side in Windows 7
    By Badrunath in forum Windows Software
    Replies: 7
    Last Post: 02-02-2011, 02:30 PM
  4. Replies: 5
    Last Post: 23-03-2010, 06:58 PM
  5. Replies: 4
    Last Post: 29-01-2010, 03:28 AM

Tags for this Thread

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
  •  
Page generated in 1,711,678,960.21915 seconds with 17 queries