how to merge two excel files

%3CLINGO-SUB%20id%3D%22lingo-sub-1599488%22%20slang%3D%22en-US%22%3Ehow%20to%20merge%20two%20excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1599488%22%20slang%3D%22en-US%22%3E%3CP%3Ehow%20to%20combine%20two%20different%20excel%20file%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20example%20I%20have%202%20sheets%20in%20(M)%20File%20and%203%20sheets%20in%20(N)%20file%20so%20I%20need%20to%20know%20can%20I%20get%20all%20the%205%20sheets%20in%20one%20file!!!!!!%3F%3F%3F%3F%3F%3F%20%23excel%23msoffice%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1599488%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1599524%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20merge%20two%20excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1599524%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F619805%22%20target%3D%22_blank%22%3E%40suyankjain%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20the%20%22Move%20or%20Copy...%22%20function%20in%20Excel.%3C%2FP%3E%3CP%3EIt's%20at%20the%20bottom%20of%20your%20page.%20Right-click%20on%20Sheet%201.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

how to combine two different excel file 

for example I have 2 sheets in (M) File and 3 sheets in (N) file so I need to know can I get all the 5 sheets in one file!!!!!!?????? #excel#msoffice

 

1 Reply
Highlighted

@suyankjain 

 

Use the "Move or Copy..." function in Excel.

It's at the bottom of your page. Right-click on Sheet 1.