Windows 10: Office 2010 Excel: two sheets

Discus and support Office 2010 Excel: two sheets in Microsoft Office and 365 to solve the problem; 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.... Discussion in 'Microsoft Office and 365' started by AirPower4ever, Apr 5, 2019.

  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

    :)
     
    AirPower4ever, Apr 5, 2019
    #1

  2. Find Replace in Excel Mobile 2010

    i have the german market place version installed. This is what I've done:



    - Open existing excel file

    - Search for a string that is part of some cells in the excel sheet

    - Result: Excel seems to search some seconds then it returns to the sheet. No found cell marked no dialog to search further



    Then created a new sheet with excel, added some words to some cells, searched for them and same result. No response that something was found and no dialog to search further.



    I use an official wm6.5 rom with office 6.1 preinstalled and updated over market place to office 2010.

    The preinstalled version does not have this problems and if i uninstall office 2010 the search with the restored office 6.1 works as it should
     
    Thunder 141, Apr 5, 2019
    #2
  3. Mithin_EJ Win User
    How can I print a Half Sheet (5.5 x 8.5 inch) paper in Excel Office 365

    Hi MarshaTravis,



    Thank you for posting your question in the Microsoft Community.



    I would suggest you to follow the below steps, to print a Half Sheet paper in Excel.



    1. Open the Excel Spreadsheet.
    2. Go to File, click on Print.
    3. Under the Print Settings, select the option "Custom Scaling".
    4. Then select the option "Custom Scaling Options".
    5. Under Page tab, select the option "Adjust to:" Change the value to 50%.
    6. Click OK, and try to print the Excel paper.


    Hope it helps,

    Let us know if you got the help you needed by clicking Yes Or No
     
    Mithin_EJ, Apr 5, 2019
    #3
  4. Rajesh S Win User

    Office 2010 Excel: two sheets

    Better overview of different sheets in Microsoft Excel

    I would like to suggest you a simple method to create Hyperlink of Sheet Name for easy navigation.


    Office 2010 Excel: two sheets Tzy3c.png


    How it works:

    • Press Ctrl+K to open the Insert Hyperlink dialog box.
    • Click the Place in This Document button.
    • Then link to the sheet, select Sheet name from Cell Reference & press OK.
    • In Type the Cell reference write the Cell address which you want to
      attach with Sheet's Hyperlink.

    Note,

    • Repeat Step 1 to 3 for other Sheets.
    • Using this method you can create Sheet's Name list in desire order.
     
    Rajesh S, Apr 5, 2019
    #4
Thema:

Office 2010 Excel: two sheets

Loading...
  1. Office 2010 Excel: two sheets - Similar Threads - Office 2010 Excel

  2. office 2010

    in Microsoft Windows 10 Store
    office 2010: After a reset of windows 10 I lost many apps. Microsoft Office 2010, Excel 2010 & Power Point 2010. If I can find the same version will it be supported by windows 10. https://answers.microsoft.com/en-us/windows/forum/all/office-2010/54c65a2f-beeb-4b84-99ab-7fb74c5fae9d"
  3. Deleted apps for word 2010, excel 2010, powerpoint 2010

    in Windows 10 Software and Apps
    Deleted apps for word 2010, excel 2010, powerpoint 2010: My PC had to be reset today. After I noticed my Microsoft Word 2010, Excel 2010 & Powerpoint 2010 were gone. I do have my original receipt but not the original packaging. How can I reinstall these apps....
  4. Excel Starter 2010

    in Windows 10 Network and Sharing
    Excel Starter 2010: After each automatic download from microsoft my Aspire Lap top locks up with a blank black screen after I log in with my pass code. I generally have to shut down and restart my computer in safe mode. Apparently the Task Manager does not start in the initial startup. The last...
  5. Updated computer with Excel sheet opened and now the excel sheet is deleted.

    in Windows 10 Installation and Upgrade
    Updated computer with Excel sheet opened and now the excel sheet is deleted.: I updated my computer on Friday and I believe I left an excel sheet I was working on open when I set it to "update and shut down". Now, on Monday, I tried to open the document. it opened, I saved it, and then the whole document went white and the mouse showed it was loading....
  6. Excel Office 2010 error 2147417848 in Windows 10 1809

    in Windows 10 BSOD Crashes and Debugging
    Excel Office 2010 error 2147417848 in Windows 10 1809: After the upgrade to Windows 10 1809 on a HP Pavilion Power Laptop 15-cb0xx 64 bits 8 GB Excel 2010 is giving problems. On different places in my macros I have errorcode 2147417848, randomly with commands copy, paste and clear. Also found: 'Automatiseringsfout. Er is een...
  7. Restore Excel file sheet

    in Windows 10 Network and Sharing
    Restore Excel file sheet: Working in an Excel file I mistakenly deleted a "sheet" is it possible to restore it? I've looked in the Recycle Bin, I've tried "restore previous version." https://answers.microsoft.com/en-us/windows/forum/all/restore-excel-file-sheet/7f8a11d4-0a49-45df-8396-c0d21791c1bc"
  8. Office 2010

    in Microsoft Office and 365
    Office 2010: Hi. I have had office 2010 for a long time working okay. Today I went to use word to make a presentation with some clip art and on the right side of the word page the clipart side pane had gone, So went to the top bar and selected clipart and yes it came back. Did what I...
  9. Office 2010

    in Microsoft Office and 365
    Office 2010: Today I did a clean install. When I tried to install my copy of Office 2010 I could not register it and had to call the 866 number and it said the copy was not valid. transferred to a real person. He had me read the Key three times to him and then told me to go to...
  10. Office 2010

    in Microsoft Office and 365
    Office 2010: Done a clean install of windows 10 on a new PC. Installed my Office 2010, but now I can not open some of my excel files. They are designated XLSX, and when I try to choose a app to open them excel is not listed. I need these files, anyone got ideas. Thanks. 55046