Save data as a picture Excel

New Contributor

How do I save the data as a picture WITH the row and column headers? (i.e A,B,C,D,1,2,3,etc.) The headers get cut off whenever I try to save it as a picture.  Thank you in advance. 

3 Replies
like a screen shot? windows key + shift + S works for me
I'm trying to take a screenshot of just the Data on my Excel. I can't do a standard screenshot of the desktop screen because the data extends more than the first page.

@adeits you could use the zoom feature to shrink the data size to fit but guessing that isn't what you want.

you can also print to pdf.  As for showing the headers when you print it is in the print sheet setup:

mtarler_0-1666787815966.png

page layout -> click bottom left corner to bring up this Page Setup window -> Sheet tab -> under the "Print" heading there is a checkbox for "Row and column headings"