This one’s a real time saver. While writing tutorials, I used to do a screenshot, and paste image into an image editor to get all the column and row headings into an image. This requires a lot of work, such as moving and cropping the image. Now, I can just copy from Excel and paste into an image file into a image editor with the column headings directly. You can do this for both Excel 2003 and 2010.
Solution for Excel 2010
Here’s how to do it:
- Set up the page so that the page will be printed with headings. Page Layout tab -> Headings -> Check “Print”
- Highlight cells to be copied
- On the Home tab, click on the arrow beside “Copy”
- Click “Copy as Picture”
- Select “As shown when printed”
- Press “OK”
- Paste the image into Excel
- Cut the image and paste into image editor (For example, Gimp)
Solution for Excel 2007
The solution for Excel 2007 is very similar to the solution for Excel 2010. Only that the window has moved to the Paste menu instead of the Copy menu.
- Repeat Excel 2010 – steps 1 and 2.
- Go to Home tab -> click Paste arrow (to load the drop down menu)
- Click “As Picture”
- Click “Copy as Picture” You will now see the same menu as in Step 5 in the previous solution for Excel 2010.
- Repeat Excel 2010 – Step 5 and onward.
3 thoughts on “How to copy Excel into image file with column letter and row number headings?”
😛 Excellent! Helped me a lot! Thanks!
Did the trick, while Microsoft Help was useless. Thank you. 😮
Thank you so much! It has been so difficult trying to figure out how to do this from other sources. This saved me so much time and energy.