Data Import & Export

Copy a Worksheet Range to the First Empty Row in Excel

Nimra MalikNimra Malik Nov 18, 2026 868 views

Question details

Copy A1:F30 from SHEET2 to the first row below the existing data on SHEET1.

Copy a Worksheet Range to the First Empty Row in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The destination data ends on a different row each time, and the new range needs to be appended below it.
Observed behavior
The copied range should start in column A immediately after the last existing record on SHEET1.
Before you start

Check whether SHEET2!A1:F30 contains formulas or a header row, and identify the last populated row across the destination columns on SHEET1. Make sure the 30 destination rows are available before pasting.

Solution 1Recommended

Copy and paste the range below the existing data

Use this method for a one-time copy when you can identify the last existing record on SHEET1.

1
Select the source range

Open SHEET2, select A1:F30, and choose Copy from the Home tab or the right-click menu.

2
Find the destination row

Open SHEET1 and identify the last populated row across columns A:F. Select the cell in column A on the row immediately below it.

3
Paste the range

Choose Paste from the Home tab or the right-click menu. To copy displayed values without formulas, choose a Values option under Paste Special.

4
Check the result

Review the pasted rows on SHEET1. If the destination is an Excel Table, click inside it and confirm that the new records are included; if necessary, use Table Design > Resize Table to extend the table.

Copy and paste the range below the existing data
Formulas and headers: A regular paste can adjust relative formula references. If row 1 contains headers that are already on SHEET1, select only the source data rows instead.
Copy ranges in WPS Spreadsheets

Append worksheet data with WPS Spreadsheets

Use WPS Spreadsheets to copy a range from one sheet and paste it directly below existing records on another sheet.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your workbook.
  2. 2. Copy the source cells: Select SHEET2, highlight A1:F30, and choose Copy from the Home tab or the right-click menu.
  3. 3. Choose the destination: Select SHEET1, find the last populated row across columns A:F, and click column A on the next row.
  4. 4. Paste and review: Choose Paste or a values option from the right-click menu, then check that all copied rows appear below the existing records.
Append worksheet ranges without retyping recordsOpen and edit Microsoft Excel XLSX and XLS filesUse paste options to copy values without formulasWork in a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

How do I find the correct row if column A has blanks?

On SHEET1, check all relevant destination columns, such as A:F, and use the row immediately below the last populated record. Do not rely on column A alone if it can be blank.

How can I paste values without copying formulas?

After copying the source range, right-click the destination cell and choose a Values option under Paste Special. This pastes the formula results rather than the formulas.

Will an Excel Table include the pasted rows automatically?

An Excel Table may expand when you paste immediately below it. Check the table boundaries afterward; if the rows are outside the table, click inside it and use Table Design > Resize Table.

Can I automate repeated imports?

For repeated imports, consider a VBA macro or Power Query. The setup depends on how the source data changes and whether you need to append records or refresh a combined result.