How to Paste Into MS Excel

Paste Data Individually
1. Open the document you want to copy from. This could be a document in another Office program, such as Word, an email or a folder on your computer.
2. Select the text you want to copy. You can select plain text or a formatted table. For instance, to copy a table you made in Word, select the rows and columns you want to paste.
3. Press 'Ctrl C' to copy the text.
4. Open Microsoft Excel.
5. Select the top left data cell in which you want to paste the text.
6. Press 'Ctrl V' to paste. Alternatively, click the 'Home' tab and click the 'Paste' button in the 'Clipboard' group. A small icon will appear next to the text you just pasted.
7. Click the icon ('Paste Options') to change the formatting of the text. Click 'Keep Source Formatting' to format the text as it was previously formatted in the original document, or select 'Match Destination Formatting' to adapt the formatting to the Excel worksheet.
Paste Data All at Once
8. Open Microsoft Excel.
9. Click the 'Home' tab. In the 'Clipboard' group, click the small arrow at the bottom to launch the Clipboard Task Pane. This will show each item that you copy, as many as 24 items at once.
10. Repeat steps 1 to 3 from the above section for as many items that you want to copy.
11. Click in the Excel document where you want to paste the data.
12. Click the 'Paste All' button on the Clipboard Task Pane. Press 'Clear All' to clear the Clipboard before copying and pasting more items.