Is there a way to convert excel tables into a picture?

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,750
Is there a way using only standard microsoft office applications or do I need to download some special sharewares from the net?

Thanks
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Select the range containing your table. Hold down the Shift key then Edit > Copy Picture.

You can then paste the copy into a graphics program (such as Paint) and save in your desired format.
 
Upvote 0
Cool tip Peter!

Should you want a downloaded Add-in for example, Excel Jeanie has a really handy .gif export option too...
 
Upvote 0
Thanks to both of you.

What I actually did (before I saw Vogn's solution) was drag a rectangle (from the drawing toolbar), highlight the excel table and paste in the rectangle.

Seems it results to exactly the same as Vogn's solution.

THanks again.
 
Upvote 0
Actually, having tried to find the equivalent in Excel 2007 (and I can't), simply copying and pasting seems to work. In pre-2007 versions of Excel the Shift + Edit > Copy Picture was necessary (I believe) to copy charts.
 
Upvote 0
This thread is resolved but I found something amusing related to this. Amusing, that is, if you're fanatical about the subject - otherwise read no further. Recently researching OLE transfers I came upon this, and looking at all the neat custom programming they did, and the superb documentation, I thought, what a neat place that must be to work for!
 
Upvote 0

Forum statistics

Threads
1,214,864
Messages
6,121,984
Members
449,058
Latest member
oculus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top