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. Need Excel 2010 Macro to insert image over 31 sheets on same cell.

    in Microsoft Office and 365
    Need Excel 2010 Macro to insert image over 31 sheets on same cell.: I have 15 spread sheets. Each one with a front page (sheet = the tabs at the bottom). Tab 2 to tab 32 on the same cell (46 F) I need to insert an image (My digital signature). This means 15 X 31 whereby I have to insert this. I was thinking that perhaps there is a way of...
  3. Unable to Refresh Excel Sheet

    in Windows 10 Network and Sharing
    Unable to Refresh Excel Sheet: I have a DAQ system that's sending data to the computer and creating a .csv file. I want to have the sheet refreshed every X seconds/minutes without having to close the file and open it every time. This file is read-only. And when I go to the Data tab and click the arrow on...
  4. office 2010

    in Windows 10 Updates and Activation
    office 2010: Hi, I want to install online office 2010 on my computer. Pay one time. Can I do this today? If yes, through which procedure? Thanx Rosemarie https://answers.microsoft.com/en-us/windows/forum/all/office-2010/1626eb65-af13-4c78-84d4-8b6e7572643c"
  5. Excel sheet is automatically open

    in Windows 10 Customization
    Excel sheet is automatically open: Why Excel sheet is automatically pop-up many sheets when I turn on my PC https://answers.microsoft.com/en-us/windows/forum/all/excel-sheet-is-automatically-open/998d27e4-30b4-46a4-a225-0c8361ec18c6
  6. Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

    in Microsoft Office and 365
    Excel 2010 Document Inspector reports hidden sheets, not shown in VBA: I have a worksheet with 14 tabs along the bottom. I've had the worksheet for many years - creation date is 16 November 1997 -and it's evolved over time to be more and more useful. Obviously been through many versions of Excel. It has several user functions and VBA procedures....
  7. 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...
  8. 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....
  9. 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"
  10. 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...