Office 2010 Excel: two sheets


  1. Posts : 125
    Ten
       #1

    Office 2010 Excel: two sheets


    I have Office 2010 and I know there is some trick to do this, but I cannot find it anywhere. I have two monitors and at work I have the same setup. Person who use to work there I heard said it was a hack that they added to my system so I don't know what that is.

    Here is what I currently do at home though. Two Excel files, let's say one is called Bulbs and the other Roof. To view both files I would open Bulb first, then go to run and type excel. A blank excel launches, then I go to File > Open and then I locate the Roof file and then I have both files open in two different windows where I can move one to one monitor and the other to another. This way I can see both at the same time

    At work though because of the hack all I do is launch excel files and they all open in their own windows. Can someone explain how I can do this for my home system? Can this also be done with different versions of Office Excel? I believe the one at work is Office 2013
      My Computer


  2. Posts : 11,247
    Windows / Linux : Arch Linux
       #2

    Hi there
    Just have the 2 different worksheets in one workbook - then just move the sheet you are interested in to the other monitor.

    Seemples !!!!

    Office 2010 Excel: two sheets-excel.png

    Cheers
    jimbo
      My Computer


  3. Posts : 125
    Ten
    Thread Starter
       #3

    Well, The file data is not that simple; I have to have separate Windows; just like what my work does. Question still remains, how is this done. If the guy at work who knew how to use some sort of hack was there I would ask, but he is no longer with the company. Thank you for the reply, but I need to have them separate.
      My Computer


  4. Posts : 9,765
    Mac OS Catalina
       #4

    You have to take Excel out of Fullscreen mode to be able to detach a sheet to move to your other monitor. No hack required.
      My Computer


  5. Posts : 11,247
    Windows / Linux : Arch Linux
       #5

    Hi there
    even in Single Monitor mode you can view multiple worksheets in different Windows or Freeze part of a spreadsheet while scrolling etc -- no hacks needed at all -- just use the Window option in the View part of the menu.

    Cheers
    jimbo
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 05:40.
Find Us




Windows 10 Forums