This article shows you how to export an image from a Microsoft Excel sheet and then use it in a document or presentation.
Steps
Method 1 of 2: Use the Copy As Image Function
Step 1. Open an existing Excel file or create a new document
Double-click the program icon marked with the letter " X"green, then enter the menu File located in the upper left of the window and follow these instructions:
- Click on You open… if you want to work on an already existing file;
- Click on New one… to create a new document.
Step 2. Press and hold the left mouse button or keep your finger pressed on the computer trackpad
Step 3. Drag the mouse pointer to select the area of the sheet to export as an image
The portion of cells in the Excel sheet that you have selected will appear highlighted in blue.
Step 4. Release the mouse button or lift your finger from the trackpad
Step 5. Click on Home
It's located at the top left of the Excel ribbon.
Step 6. Click on the down arrow button located to the right of the "Copy" item
It is located within the "Clipboard" group of the "Home" tab of the Excel ribbon.
If you're using a Mac, hold down the ⇧ Shift key while opening the menu Edit located at the top of the screen.
Step 7. Click Copy as Image…
If you are using a Mac, click on the item Copy image … from the drop-down menu that appeared.
Step 8. Choose from the export options
Click on one of the following formats in the "Appearance" section of the dialog box that appeared:
- As shown on the screen - allows you to export the image as it is displayed on the screen;
- As shown in print - the image will be exported as it appears when printed.
Step 9. Click OK
The image has been stored in the computer's "System Clipboard" memory area and is ready to be pasted wherever you want.
Step 10. Open the document where you want to insert the image from Excel
Step 11. Click on the portion of the document where you want to place the image
Step 12. Paste the image
Press the key combination Ctrl + V on Windows or ⌘ + V on Mac. The area of the Excel sheet you have selected will be pasted as an image into the document under examination.
Method 2 of 2: Use the PDF Format
Step 1. Open an existing Excel file or create a new document
Double-click the program icon marked with the letter " X"green, then enter the menu File located in the upper left of the window and follow these instructions:
- Click on You open… if you want to work on an already existing file;
- Click on New one… to create a new document.
Step 2. Click on File
It is displayed at the top of the Excel window on the menu bar.
Step 3. Click Save As…
It is one of the first items listed in the drop-down menu that appeared.
Step 4. Click on "Format:
in the drop-down menu.
It is visible in the center of the newly appeared dialog box.
Step 5. Click on PDF
It is one of the items located at the top of the drop-down menu.
Step 6. Click Save
It is located in the lower right corner of the "Save As" dialog box.
