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

Making Banners in Word

Word can be used for printing a variety of document types. You may want to use the program to print a festive banner for a ...

Discover More

Can't Sort Imported Data

Import information from an external database, and you'll no doubt want to use Excel's simple tools to manipulate that data. ...

Discover More

Determining Differences Between Dates

Macros are often used to process the data in a worksheet. If that data includes dates that need to be processed, you'll ...

Discover More

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!

More ExcelTips (ribbon)

Pop-Up Comments for Graphics

Excel allows you to add comments to individual cells in a worksheet, but what if you want to add comments to graphics? Excel ...

Discover More

Inserting a Picture in Your Worksheet

Worksheets can contain more than just text and numbers. Here's the low-down on the different types of pictures you can add ...

Discover More

Changing Line Color in a Drawing Object

Don't like the color of the lines that Excel chose for your drawing object? It's easy to choose your own colors, as pointed ...

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 two less than 2?

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.