On the features page it says: "Copying data with column headers for quick pasting to spreadsheet"
Is there an option to enable this? When I copy/paste the default behavior is data without column headers.
How-to copy column headers
Re: How-to copy column headers
You would need to right-click in Data Editor and select 'Copy With Header' in the popup menu.
Re: How-to copy column headers
Hi Alexa, is there no keyboard shortcut for this? If not, I'd like to respectfully submit a request!
Re: How-to copy column headers
You can define your own shortcut for this command as follows:
1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Keyboard' branch.
3. Type 'DataView.CopyWithHeader' in the 'Show Commands Containing' field.
4. Find and select the 'DataView.CopyWithHeader' item in the list below.
5. Select 'Data View' from the 'Use new shortcut in' dropdown list.
6. Set the focus in the 'Press shortcut keys' field.
7. Press the key combination you want to assign to the command. This combination will appear in the 'Press shortcut keys' field.
8. Click the 'Assign' button next to this field.
9. Click 'OK'.
1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Keyboard' branch.
3. Type 'DataView.CopyWithHeader' in the 'Show Commands Containing' field.
4. Find and select the 'DataView.CopyWithHeader' item in the list below.
5. Select 'Data View' from the 'Use new shortcut in' dropdown list.
6. Set the focus in the 'Press shortcut keys' field.
7. Press the key combination you want to assign to the command. This combination will appear in the 'Press shortcut keys' field.
8. Click the 'Assign' button next to this field.
9. Click 'OK'.
Re: How-to copy column headers
Wow, great tip Alexa! Did not know these customizations were available but they are awesome.
Re: How-to copy column headers
Hi Alexa, one more follow-up question. I created the shortcut as CTRL-C-S but it seems to be affecting the default copy functionality. Now when I click an individual field it does not copy - did I set this up wrong?
Re: How-to copy column headers
You should use another key combination for the default copy functionality then. Let's say, CTRL+INS or any other which you can define manually.