It is a common activity in Microsoft Office programs to copy and paste data between spreadsheets, documents, and presentations. There is a lot of compatibility between these different file types, which often makes them easy to work with.
But you may find that data you copy and paste from Excel 2013 to another program is difficult to deal with, due to the formatting restrictions of the target document or presentation. One good way to avoid problems like this is to copy your selection as an image in Excel 2013, then paste the image instead of the cells themselves.
Copy a Selection as a Picture in Excel 2013
The steps in this article will show you how to make a selection in Excel 2013, then copy that selection as a picture. You can then paste that copied picture into another program, such as Powerpoint or Word.
- Open your spreadsheet in Microsoft Excel 2013.
- Use your mouse to select all of the cells that you want to include in the copy.
- Click the Home tab at the top of the window.
- Click the arrow to the right of Copy in the Clipboard section of the ribbon, then click the Copy as Picture option.
- Specify whether you wish to copy the selection as it appears on your screen, or as it would appear when printed, choose a picture format, then click the OK button.
- Navigate to the program in which you wish to paste the copied picture, then press Ctrl + V on your keyboard to paste the image.
Using the merge and center tool in Excel 2013 can help you to make data in your spreadsheet easier to read. But cells that have been merged and centered can be difficult to format or edit, so you may be looking for a way to achieve the appearance created by merge and center, but to keep the data in its original, unmerged cell. Learn how to center across multiple cells in Excel 2013 and see if that effect is more helpful for you.