The simplest way to combine two worksheets

The fastest way to merge two worksheets is to copy all the data from one sheet and paste it into the other. Open both worksheets side by side, select all the data in the sheet you want to move (use Ctrl+A to select everything), copy it with Ctrl+C, click into the sheet where you want it to go, and paste with Ctrl+V. Excel will add the data below or to the right of what is already there, depending on where you click first.

If your worksheets have headers — row 1 with column names like "Date" or "Customer Name" — delete the header row from the second sheet before pasting. That way you do not end up with two header rows in the middle of your data. Most people find it easier to keep the headers in the first sheet only.

This method works best when both sheets have the same column structure. If one sheet has columns in a different order, you will need to rearrange them first so the data lines up correctly.

Key Takeaways

  • Copy all data from the second worksheet using Ctrl+A and Ctrl+C, then paste it into the first worksheet with Ctrl+V to combine them in seconds.
  • Delete the header row from the second sheet before pasting if both sheets have column names, so you do not end up with duplicate headers in your merged data.
  • Make sure both worksheets have columns in the same order before merging, or rearrange the columns in one sheet to match the other.
  • If you need to keep the original worksheets unchanged, create a new blank worksheet first and copy both sheets into it instead.

Merging worksheets with different column orders

When the two worksheets have the same information but in different column orders, copying and pasting will put data in the wrong columns. The safest approach is to rearrange one sheet to match the other before you merge them.

Open the worksheet with the columns in the wrong order. Right-click on a column header (the letter at the very top) and select "Delete" to remove columns you do not need, or drag column headers left and right to reorder them. Once the columns match the layout of your other sheet, you can copy and paste normally.

If you have many columns and rearranging feels tedious, you can instead create a new blank worksheet and use formulas to pull data from both sheets in the correct order. This takes longer to set up but leaves your original worksheets untouched.

Keeping your original worksheets and creating a merged copy

If you want to preserve the original worksheets and create a separate merged version, start by creating a new blank worksheet. Right-click on any sheet tab at the bottom of Excel and select "Insert Sheet" to add a new one. Name it something like "Combined Data" so you remember what it contains.

Copy all the data from your first worksheet (Ctrl+A, then Ctrl+C) and paste it into the new sheet starting at cell A1. Then copy all the data from your second worksheet, click on the cell just below your first dataset, and paste. Excel will stack the data one after the other, and you will have a complete merged worksheet without changing the originals.

This approach is especially useful if you think you might need to update the original worksheets later. You can always go back and create a fresh merged copy if the source data changes.

Using formulas to pull data from multiple worksheets

Instead of copying and pasting, you can use formulas to reference data from other worksheets. This is more work upfront but means your merged sheet updates automatically if you change data in the original sheets.

In a new worksheet, click on cell A1 and type a formula like =Sheet1!A1 (replace "Sheet1" with the actual name of your first worksheet). Press Enter, and Excel will pull the value from that cell. You can then copy this formula down and across to pull an entire range of data. Once you have the formula set up for one sheet, you can modify it to reference the second sheet in the rows below.

This method takes longer to set up than straightforward copy-paste, but it is worth learning if you work with data that changes regularly. The merged sheet will always show the current information without you having to manually update it.

Handling duplicate rows when merging

If both worksheets contain some of the same records — for example, the same customer appearing in both lists — you may end up with duplicates after merging. Excel has a built-in tool to find and remove them.

First, merge your two worksheets using any method above. Then select all your data (Ctrl+A). Go to the Data menu at the top and look for "Remove Duplicates" (in newer versions of Excel) or "Filter" options. Click "Remove Duplicates" and Excel will show you which columns to check. If your data has a unique ID column like "Customer ID" or "Invoice Number", check only that column. Excel will delete any rows where that column value appears more than once, keeping only the first occurrence.

Before you remove duplicates, make a backup copy of your merged data. This way, if Excel removes something you wanted to keep, you can undo the change or restore from your backup.

Merging worksheets with different numbers of columns

Sometimes one worksheet has more columns than the other. You can still merge them, but you need to decide whether to keep all columns or only the ones that appear in both sheets.

If you want to keep all columns, copy and paste as normal. The sheet with fewer columns will have blank cells in the rows where those extra columns do not exist — this is fine and does not cause problems. If you want only the columns that both sheets share, delete the extra columns from one sheet before merging.

A third option is to create a new worksheet and use formulas to pull only the columns you need from each source sheet. This takes more time but gives you the most control over which data ends up in your final merged worksheet.

Merging more than two worksheets

If you need to combine three or more worksheets, the process is the same — just repeat it. Merge the first two sheets, then copy the third sheet and paste it below the merged data. Continue until all sheets are combined into one.

For very large projects with many worksheets, create a new blank worksheet first and paste each source sheet into it one at a time. This keeps your original worksheets intact and gives you a single place to see all your combined data. If you use formulas instead of copy-paste, you can reference as many worksheets as you need in a single merged sheet.

Frequently Asked Questions

What happens to the original worksheets after I merge them?

The original worksheets stay exactly as they are. Copying and pasting does not delete or change the source data — it only creates a copy in the destination sheet. If you want to remove the original worksheets after merging, you can right-click on the sheet tab and select "Delete Sheet".

Can I undo a merge if I make a mistake?

Yes. Press Ctrl+Z when ready after pasting to undo the last action. You can undo multiple times to go back several steps. If you have already closed the file, the undo history is lost, so it is a good idea to save a backup before merging large datasets.

What if the two worksheets have different data types in the same column?

Excel will paste the data as-is without converting it. If one column contains dates and the other contains text that looks like dates, they will not sort or calculate together properly. Before merging, check that matching columns have the same format — dates should be dates, numbers should be numbers, and text should be text.

Is there a way to merge worksheets without manually copying and pasting?

Yes, using formulas with sheet references (like =Sheet1!A1) lets you build a merged view automatically. This takes longer to set up but updates on its own if the source data changes. For very large or complex merges, some people use pivot tables or data consolidation features, though these are more advanced.

Can I merge worksheets from different Excel files?

Yes. Open both files at the same time, arrange them side by side, and copy from one file and paste into the other just as you would with sheets in the same file. You can also use formulas that reference another file by typing the file path in the formula, though this is more complex.