Windows 10: 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

:)

 

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

 

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

 

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.





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.