Last Update: 4/9/2021
To effectively copy and paste data from Excel or a plain text file into Origin, first copy in Excel or the plain text file, then select the first row of the first column you want to paste to in the relevant Origin worksheet and then paste there (do not click on the column header and then paste). If headers have been copied from Excel or the plain text file along with data, the headers will also be in the data section of the Origin column. But there is an easy solution to promote the headers up into the proper label rows:
When this is performed, all data within the selected row will be moved up to the respective label row in the Origin worksheet.
Click to View How-To Video
When importing Excel data (Data: Connect to File: Excel or Data: Import from File:Excel you can specify how to handle column labels on import.
Keywords:Excel, copy, paste, row, header, heading