https://communities.sas.com/t5/ODS-and-Base-Reporting/Get-column-name-when-copy-data-directly-from-SAS-dataset/m-p/32433#M4783 The file getting from Send to &gt; Excel is not really an Excel file because it does not accept the pre-defined cells' format i.e. font or board format. Mon, 18 May 2009 07:09:53 GMT deleted_user 2009-05-18T07:09:53Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Get-column-name-when-copy-data-directly-from-SAS-dataset/m-p/32431#M4781 Hi,<BR /> <BR /> When opening a SAS dataset in SAS EG4, we can use Ctrl+A to select all the data and then copy. However when pasting the data in Excel, it only pastes the actual data value and drops column names. Does anyone know how to get the column names when using this method to export data to Excel? Thanks! Fri, 15 May 2009 01:53:25 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Get-column-name-when-copy-data-directly-from-SAS-dataset/m-p/32431#M4781 deleted_user 2009-05-15T01:53:25Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Get-column-name-when-copy-data-directly-from-SAS-dataset/m-p/32432#M4782 Right click on the dataset in the project explorer, and select Send to &gt; Excel. Fri, 15 May 2009 06:51:22 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Get-column-name-when-copy-data-directly-from-SAS-dataset/m-p/32432#M4782 andreas_lds 2009-05-15T06:51:22Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Get-column-name-when-copy-data-directly-from-SAS-dataset/m-p/32433#M4783 The file getting from Send to &gt; Excel is not really an Excel file because it does not accept the pre-defined cells' format i.e. font or board format. Mon, 18 May 2009 07:09:53 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Get-column-name-when-copy-data-directly-from-SAS-dataset/m-p/32433#M4783 deleted_user 2009-05-18T07:09:53Z