How can Copy, as picture, in Excel get 300 dpi?

Question

I need to copy selected cell to save as a picture file of adequate (300 dpi) resolution.

That picture file is them inserted, not pasted, in a Word file. Publisher wants a minimum of 300 dpi for printing quality.

Currently, in Excel using the "Clipboard, Copy, Copy as Picture" does not create a file. Pasting the copied picture into the open Excel spreadsheet, it can then be selected and "saved as picture" to create a file. However, the jpg is low resolution and using photoshop to increase resolution just magnifies the imperfections.

About 2015 I was able to create higher resolution pictures for a book. I've either forgotten how of the process was changed or removed. Anyone know how to save selected Excel cells as a picture file?

Answer 1

Hi!

Welcome to Microsoft Q&A forum.

There is another way, you need to create a file called "Vector" and export it. This keeps the table as vector graphics.(infinite resolution).

First, you need to copy the cells correctly then select the cells you want, go to Home -> Copy ▼ → Copy as Picture. Choose "As shown on screen", "Picture" then click OK.

Second, paste into PowerPoint (not back into Excel)

1. Open PowerPoint
2. Home → Paste ▼ → Paste Special
3. Choose Picture (Enhanced Metafile) ← IMPORTANT
4. Click OK.

Third, save it as High quality image. Right-click the pasted image:

1. Choose Save as Picture
2. Save as EMF or SVG

Note: These formats are vector, so they don’t have DPI limits.

Last step is to Convert to 300 DPI JPG/PNG. Open the EMF/SVG using Photoshop or Illustrator(which is the best to use). When exporting, set the DPI to 300 and choose the required size as it may be inches or centimeter. Because it started as vector, it will be perfectly sharp.

Answer 2

To achieve a higher resolution (300 dpi) when copying selected cells in Excel as a picture, you can use the following workaround:

1. Copy as Picture: Use the "Copy as Picture" feature in Excel to copy the selected cells. You can find this option under the "Home" tab in the Clipboard group.
2. Paste into Word: Instead of saving directly from Excel, paste the copied picture into a Word document. This allows you to maintain better control over the output quality.
3. Save as Picture: After pasting, you can right-click on the pasted image in Word and select "Save as Picture". When saving, choose a format that supports high resolution, such as PNG or TIFF.
4. Adjust DPI: If needed, you can adjust the DPI settings in an image editing software (like Photoshop) after saving the image to ensure it meets the 300 dpi requirement for printing.

Currently, Excel does not directly support saving a copied picture at a specific DPI setting, so using Word as an intermediary is a practical approach to achieve the desired resolution.

Answer 3

The answer from IGYQ permits the best accuracy. I also discovered another way to get a 600 dpi picture of the desired cells.

On the home tab, in the clipboard, select copy as picture, then select "As shown when printed." That appears to default to copy the image at 600 dpi. Next, paste the image in Word, select the image and "Save as picture." Select the file format wanted, give it a name and location for it to be save. When I selected JPG, the resulting file was 600 dpi. Once completed, the image may be deleted from the file where it was pasted.