Copy a Worksheet Range to the First Empty Row in Excel
Question details
Copy A1:F30 from SHEET2 to the first row below the existing data on SHEET1.

- 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.
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.
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.
Open SHEET2, select A1:F30, and choose Copy from the Home tab or the right-click menu.
Open SHEET1 and identify the last populated row across columns A:F. Select the cell in column A on the row immediately below it.
Choose Paste from the Home tab or the right-click menu. To copy displayed values without formulas, choose a Values option under Paste Special.
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.

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. Open the workbook: Open WPS Spreadsheets and use Open to select your workbook.
- 2. Copy the source cells: Select SHEET2, highlight A1:F30, and choose Copy from the Home tab or the right-click menu.
- 3. Choose the destination: Select SHEET1, find the last populated row across columns A:F, and click column A on the next row.
- 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.

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.




