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

Changing the Size of a Drawing Object

Documents are often made up of more than just text. If you have drawing objects in your document, you will doubtless need to ...

Discover More

Hanging Indent Shortcut

You can use the tools on the ribbon to adjust the indent applied to a paragraph. If you want to format a hanging indent, Word ...

Discover More

WindowsTips Annual Archives

WindowsTips is a weekly newsletter that provides tips on how to effectively use the latest Windows operating ...

Discover More

Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!

More ExcelTips (ribbon)

Resize Graphics Outside of Excel

Graphics are a common addition to almost any workbook. If you need to change the size of your graphics (which Excel lets you ...

Discover More

Creating a JPG File from a Chart

Excel provides some great tools that allow you to create amazing charts based on data in your worksheets. Once your ...

Discover More

Changing a Shape

Need to change a shape you previously added to your worksheet? It's easy to do using the graphics tools provided by Excel. ...

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. 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 eight minus 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.