# Cut/paste with column names **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [January 19, 2011, 7:57am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160 "2011-01-19T07:57:54Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Harold](https://avatars.discourse-cdn.com/v4/letter/h/8491ac/32.png) [@Harold](https://forums.toadworld.com/u/Harold)\ **Post date:** [January 19, 2011, 7:57am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160/1 "2011-01-19T07:57:54Z")
I installed 10.5.1 on a new PC. In my old installation, when I copied rows from a grid and pasted them into Excel, the column names would be included in the copy/paste. Now, only the data is pasted. How do I set up Toad so the column names will also be copied and pasted? Thank you ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [January 19, 2011, 7:57am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160/2 "2011-01-19T07:57:54Z")
Use SHIFT+INSERT instead of Ctrl+C, that will grab the column headers. ---
**Author:** ![Harold](https://avatars.discourse-cdn.com/v4/letter/h/8491ac/32.png) [@Harold](https://forums.toadworld.com/u/Harold)\ **Post date:** [January 19, 2011, 8:25am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160/3 "2011-01-19T08:25:25Z")
More specifically, I run a query in the Editor such as: SELECT \* FROM dm\_ps\_uom This returns 50 rows. I click in the Data Grid, then from the Edit menu, I select “Select All”, then “Copy”. Over in Excel, I rigth click and select “Paste”. In my previous 9.6 version, it would paste with column names. I tried the SHIFT+INSERT, but that didn’t work. ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [January 19, 2011, 8:25am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160/4 "2011-01-19T08:25:25Z")
Not sure why SHIFT+INSERT wouldn’t work for you…sorry, maybe someone else will have an idea. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [January 19, 2011, 8:44am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160/5 "2011-01-19T08:44:55Z")
I made a select query in the grid window I click right mouse button save as from the popup menu then comes the “save grid contents” I take the tab delimiter if I want the column names I check the “include column headers” also can check the submenu (in) lowercase save to - clipboard submit with ok then paste it to excel. work perfect but, if some fields include CR it destroy the order in the tab delimiter. in this case I take the xls instance instead of tab delimiter then I send it to file. and open the file in excel. the fields with the CR comes correctly to excel. sorry my poor English ---
**Author:** ![Harold](https://avatars.discourse-cdn.com/v4/letter/h/8491ac/32.png) [@Harold](https://forums.toadworld.com/u/Harold)\ **Post date:** [January 19, 2011, 9:44am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160/6 "2011-01-19T09:44:35Z")
This is helpful and does bring the column names, but sometimes, I may only want to copy one or two records instead of the entire data set. I would think there is something in Toad Options, but I can’t figure out what it is. ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [January 19, 2011, 9:44am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160/7 "2011-01-19T09:44:35Z")
The way it should work, select the rows you want using multi-select (ensure ROW SELECT is enabled in grid), then just use SHIFT+INSERT, you’ll get just the rows you want and the column headers. You can also just grab the selected rows with the Export/SaveAs dialog – there’s a check box for that, but won’t be as quick as using the KB. ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [January 19, 2011, 9:44am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160/8 "2011-01-19T09:44:35Z")
The shortcut that you are looking for is CTRL+Insert. This will copy with column headers. Shift+Insert is another shortcut for pasting. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [January 19, 2011, 9:44am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160/9 "2011-01-19T09:44:35Z")
There is a checkbox in the Export Data window called “Export only selected rows”. Maybe this is what you’re looking for? ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [January 19, 2011, 9:44am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160/10 "2011-01-19T09:44:35Z")
They’re switched on my KB apparently ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [January 19, 2011, 9:44am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160/11 "2011-01-19T09:44:35Z")
CTRL+Insert 🙂 Not sure why Shift+Insert copies for you, but the standard shortcut for pasting is CTRL+V or CTRL+Insert. ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [January 19, 2011, 9:44am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160/12 "2011-01-19T09:44:35Z")
My brain said shift, but my fingers said ctrl. ---
**Author:** ![Latheesh](https://avatars.discourse-cdn.com/v4/letter/l/85e7bf/32.png) [@Latheesh](https://forums.toadworld.com/u/Latheesh)\ **Post date:** [January 20, 2011, 8:58am UTC](https://forums.toadworld.com/t/cut-paste-with-column-names/10160/13 "2011-01-20T08:58:54Z")
hi Harold, Right click on any cell in the data grid and select export dataset ,select the export format as Excel select the location where you want to save the file and click ok… data with column names will be exported no need to copy/paste option… regards, latheesh