Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Exporting a Graphics Group.

Exporting a Graphics Group

by Allen Wyatt
(last updated August 22, 2015)

4

As you know, Excel allows you to add simplistic graphics to your worksheets through the use of shapes. It is not unusual for these graphics to become rather complex over time as you add to them and edit them to get them looking just the way you want them. After putting in the time for the desired result, you may want to export a graphics group as a single GIF file so you can use it in other programs or on the Web.

Unfortunately, there is no way to do this in Excel. Even in VBA the group cannot be exported as a graphic. (Individual objects can, but not the group as a whole.) The only workaround that we could come up with seems rather old-fashioned. Follow these steps:

  1. Display the worksheet containing the graphics group you want in the GIF file.
  2. Make sure the Excel program window is maximized.
  3. Display the View tab of the ribbon.
  4. Click the Full Screen tool in the Workbook Views group. Excel hides many of its on-screen accoutrements.
  5. Press the Print Screen key on your keyboard. The entire image of the screen is copied to the Clipboard.
  6. Minimize or exit Excel.
  7. Start your favorite graphics editing program.
  8. Paste the contents of the Clipboard into the graphics program.
  9. Edit the graphic as desired, so that it contains only the grouped items.
  10. Save the image as a GIF image.

You might also try using Andy Pope's Graphics Exporter add-in, which may fit your needs. You can find it here:

http://www.andypope.info/vba/gex.htm

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9899) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Exporting a Graphics Group.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Conditionally Highlighting Cells Containing Formulas

Excel's conditional formatting feature allows you to create formats that are based on a wide variety of criteria. If you ...

Discover More

Easily Changing Links

If you have linked information in your worksheets, you may want a way you can easily change the targets to which those ...

Discover More

Text Truncated in PivotTable

When you create a PivotTable based on data that contains lots of text, you may be surprised to find that your text is ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More ExcelTips (ribbon)

Adding Drop Shadows

Want your shapes to really "pop" off the page? Add a drop shadow to them, as described in this tip.

Discover More

Placing a Picture in a Comment

When editing a worksheet, you can place comments that are associated with individual cells. If you want, you can format a ...

Discover More

Pasting a Graphic to Multiple Worksheets

Do you need to add a logo or other graphic to a bunch of worksheets? Here are a couple of short macros that can make ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is five more than 8?

2016-05-09 00:02:25

Darren E

For shapes, groups, charts, ranges and other elements in your workbook (i.e. not things like menus) you can also use Copy As Picture.
Then open Paint or whatever graphics program you use, and Paste.

All the other methods work too and have their pros and cons but it is not correct to say there is no way to do this in Excel.


2016-03-29 11:20:01

Danielle

Thank you, Peter. I'm actually not a fan of the Snipping Tool either, but included it for those who might be.

Nice to know about the Faststone Image Viewer - will check that out!


2016-02-26 09:35:10

Peter Atherton

Danielle

The snipping tool is great for simple rectangles but I can't get it to handle more complicated shapes. The free Faststone Image Viewer is better for cutting things like menus and sub-menus


2016-02-25 10:25:45

Danielle Reed

Although I generally prefer to accomplish that type of task the way that you suggest (with Paint, which will do things that many other graphics editors will NOT do, like pixel-by-pixel repair/editing - nice for repairing scans of physical photos), newer versions of Windows also have something called Snipping Tool, which opens with on-screen instructions. If you do a search from the Start menu or an App Search for SNIP, it will come up.


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.