Find and Copy an Excel Column by Header Name
Question details
Find and copy an Excel column using its header text, including the header in the copied data.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Selected columns must be copied from exported data to another worksheet, but their positions can change between exports.
- Observed behavior
- The desired column should be located by its header name rather than a fixed column position and copied in full.
Check which row contains the headers and confirm the exact text of the header you need. The formula example below assumes headers are in row 1 on Sheet1 and that each target header is unique.
Find the Header and Copy Its Column in Excel
Use Find when you need to copy a column once or only occasionally.
On Sheet1, click the row 1 heading to select the header row, then press Ctrl+F and enter the header text.
In Find and Replace, open Options, select Match entire cell contents, and click Find Next. Close the dialog after Excel selects the matching header cell.
Click the column letter above the selected header, then press Ctrl+C to copy the entire column, including the header.
Open the destination worksheet, select a cell in row 1, such as A1, and press Ctrl+V.

Use MATCH and OFFSET to Select a Column by Header
Create a reusable named range that locates a column from a header entered on another worksheet.
Find and Copy a Header Column in WPS Spreadsheet
Use Find in WPS Spreadsheet to locate a header, then copy its entire column to a destination sheet without relying on a fixed column position.
- 1. Open the workbook: Open the exported workbook in WPS Spreadsheet and select the source worksheet.
- 2. Find the header: Select the header row, press Ctrl+F, enter the header text, and use Find Next to locate it.
- 3. Copy the column: Close Find, click the column letter above the matching header, and press Ctrl+C.
- 4. Paste into another sheet: Open the destination worksheet, select a cell in row 1, and press Ctrl+V.

Frequently Asked Questions
How do I find a column if its position changes in each export?
Select the header row and use Ctrl+F to search for the header text. Alternatively, use MATCH with the header row and an exact-match argument of 0 to find its current position.
Why does MATCH return #N/A for my header?
MATCH cannot find an exact match. Check the header text in the source row and the search cell for spelling differences or extra spaces.
What happens if two columns have the same header?
MATCH returns the position of the first matching header. With Find, use Find Next to inspect additional matches before copying the correct column.
Can I copy the header and all rows at once?
Yes. Click the column letter above the header and press Ctrl+C, then select a destination cell in row 1 and press Ctrl+V.




