Last Update: 1/18/2017
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
Since Origin 2015, you can use File:Import:Excel (XLS, XLSX, XLSM)... to specify the column label rows in the Excel workbook to be imported.
Keywords:Excel, copy, paste, row, header, heading