The sheet’s tab includes a (2) to highlight that it’s a second copy.Įxcel has a built-in Consolidate option that you can select to merge more specific cell ranges from alternative spreadsheets together into a single worksheet. Now the spreadsheet you selected to move to will also include the sheet.

Press the OK button to close the window.

If you do not select that option, the sheet moves from one spreadsheet to the other. Choose the sheet (book) you want the file moved to by using the drop-down list and click the Create a copy checkbox to copy the selected sheet.Open the files you want to move and a spreadsheet to copy them to, and then right-click a sheet tab at the bottom of Excel’s window and select Move or Copy.The option does not enable you to select cell ranges, but it is fine for merging full sheets. Thus, you can copy or move numerous sheets from different files into one spreadsheet. The Move or Copy tab option is one you can select to copy full sheets to another Excel spreadsheet. This scenario demonstrates the potential need for advanced copy-and-paste functions.Ĭombine Sheets in Excel Files with the Move or Copy Option More specifically, the cell widths were the same in the pasted spreadsheet whereas they were different in the original. If you did not notice the difference in the images above, you see that the basic paste option placed the content in the new spreadsheet’s current format. Alternatively, you can right-click and select Paste from the context menu. Select a cell and press the Ctrl + V hotkey to paste to it. Pasting: Open a blank spreadsheet to include the merged data.You can also right-click within the cells and select Copy. Press Ctrl + C to copy the selected sheet area. Hold the left mouse button and drag the cursor over the cell range to select it. Copying: Open the sheet you need to copy cells from and select the cells you need.For more advanced pasting, Excel offers multiple options such as Values, Formulas, Keep source formatting width, and several more.

Excel includes Copy and Paste options in its menus. You can copy a range of cells in one sheet and paste them into a new spreadsheet file. The good old Copy ( Ctrl + C) and Paste ( Ctrl + V) hotkeys might be all you need to combine Excel files. Copy and Paste Cell Ranges from Multiple Spreadsheets Follow along in this article to learn all about the various ways to merge excel files.

How to combine excel workbooks