SOLVED

Can't open 2 worksheets in the same workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2999269%22%20slang%3D%22en-US%22%3ECan't%20open%202%20worksheets%20in%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2999269%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Microsoft%20Office%20Home%20and%20Student%202019%20version%202110%20with%20Windows%2011.%26nbsp%3B%20I%20open%20Excel%2C%20then%20I%20open%20the%201st%20worksheet.%26nbsp%3B%20I%20then%20click%20open%20within%20Excel%2C%20and%20select%20another%20worksheet.%26nbsp%3B%20Excel%20opens%20the%20worksheet%2C%20but%20in%20a%20second%20Excel%20workbook.%26nbsp%3B%20Now%20I%20have%201%20worksheet%20in%20Excel%201%20and%20the%20second%20worksheet%20in%20Excel%202.%26nbsp%3B%20I%20want%20both%20worksheets%20in%20Excel%201.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20do%20exactly%20the%20same%20thing%20on%20my%20older%20laptop%20using%20Microsoft%20Excel%20Starter%202010%2C%20the%20same%20worksheets%20open%20correctly%20in%20a%20single%20Excel%20workbook.%3C%2FP%3E%3CP%3EI%20can%20find%20nothing%20under%20%22options%22%20in%20Excel%20Home%20and%20Student%20to%20fix%20this%20problem%2C%20so%20I%20don't%20know%20how%20to%20fix%20this%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2999269%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2999292%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%202%20worksheets%20in%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2999292%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1186945%22%20target%3D%22_blank%22%3E%40rober860%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStarting%20with%20Excel%202013%2C%20each%20workbook%20opens%20in%20its%20own%20application%20window.%20You%20cannot%20change%20that.%3C%2FP%3E%0A%3CP%3EYou%20can%20still%20copy%20between%20workbooks%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am using Microsoft Office Home and Student 2019 version 2110 with Windows 11.  I open Excel, then I open the 1st worksheet.  I then click open within Excel, and select another worksheet.  Excel opens the worksheet, but in a second Excel workbook.  Now I have 1 worksheet in Excel 1 and the second worksheet in Excel 2.  I want both worksheets in Excel 1.  

When I do exactly the same thing on my older laptop using Microsoft Excel Starter 2010, the same worksheets open correctly in a single Excel workbook.

I can find nothing under "options" in Excel Home and Student to fix this problem, so I don't know how to fix this problem.

1 Reply
best response confirmed by rober860 (New Contributor)
Solution

@rober860 

Starting with Excel 2013, each workbook opens in its own application window. You cannot change that.

You can still copy between workbooks etc.