Flipping the data back and forth among various file types (copying to Word, over to Outlook, then re-copying back to Excel) is bound to cause formatting issues. Under Before sheet, specify where to put the copy. To place a copy into a new workbook, select (new book). In the Move or Copy dialog box, do the following: Under To book, choose the target file. But the system you describe sounds maddeningly over-engineered to me. Right click on the tab that you want to copy, and then click Move or Copy. Or you could let your supervisor write on a hard copy and you type the changes. In Excel, select the cells you want to copy and press Ctrl +. Or your supervisor should get/learn Excel and “edit” your sheet when you turn it in. The most popular shortcut for copying and pasting can be used in Excel and other programs as well. Your pasted data will fill up the cells below and to the right of your starting cell. Select the upper-leftmost cell that you want your pasted data to appear in. 2 Select the cell in Excel that you want to paste into. It sounds to me like your company needs the services of a good IT professional to set up some sort of environment in which your supervisor has direct access to the data that needs editing. Two steps are required: Step 1- Get all email addresses into their own cells Get all the email addresses to be in their own cells- you can do this using the Text to Columns tool and splitting them based on whatever differentiated one email from another. Select all of the text you want to copy to Excel and copy it to your clipboard.
![cut and paste list into excel cut and paste list into excel](https://img.wonderhowto.com/img/82/58/63475694961272/0/get-data-from-excel-table-with-filter-copy-paste.1280x600.jpg)
![cut and paste list into excel cut and paste list into excel](https://deskbright-media.s3.amazonaws.com/static/cms/images/articles/excel/using-tables-in-excel/image8.jpg)
How did you two come up with this way of doing things? You can copy one or more rows from a list or a single field on a page, and then paste what you copied into the same page, another page, or an external document.
#Cut and paste list into excel how to
This may sound a little harsh, but … can your supervisor not simply edit the file in Excel? Does s/he not have Excel? Or has it but doesn’t know how to use it? What’s the barrier to simply attaching the Excel sheet to the outgoing email, rather than dumping the text into the body of the email? I don’t really get how this copy-and-paste process you describe evolved.