HOW TO Microsoft Office

HOW TO Copy from Excel and Paste as Picture without gridlines

The title of this post contains exactly the words I used to search on Google.
Why for this simple task I’m writing a post?
Because in this case, as happens often, the task is easy but we should know the logic behind the software and functionalities we want use.
To clarify the concept: we want

"Paste as Picture hiding gridlines"

rather then

"Copy as Picture without gridlines"

HOW TO Copy from Excel and Paste as Picture without gridlines?

The correct tile of the this post should be

HOW TO Copy as Picture without gridlines from Excel

Click Copy -> Copy as Picture…

Copy as Picture

Under Appearance section, select “As shown when printed“, then click OK

Copy Picture As shown when printed

When you’ll paste it, for example in a Word document, the image will be without gridlines.

Note from comments: You may also have to uncheck the ‘Gridlines’ box under ‘View’ when working on Excel on a Mac, unless you want the gridlines to be in the picture you paste.

Did my HOW TO help you? Leave a reply.