MS-Excel / General Formatting

Save your Graphic

If you create a graphic in Excel using Shapes, SmartArt, or WordArt, you may want to save the graphic as a separate file for use in another program. Unfortunately, Excel does not provide a direct way to export a graphic, but here is a trick you can use. Make sure that your graphic appears the way you want it and then follow these steps:

  1. Save your workbook.
  2. Choose Office> Save As to save your workbook as a Web Page. In the Save As dialog box, select Web Page (*.htm; *.html) from the Save As Type drop-down list.
  3. Close the workbook.
  4. Use Windows Explorer to locate the HTML file you saved in Step 2. You will notice that Excel also created a companion directory for the HTML file. If you save the file as myart.htm, the directory will be named myart_files.
  5. Open the directory, and you'll find *.png graphic files-one for each graphic object in your workbook. The *.png files have a transparent background.
[Previous] [Contents]

In this tutorial:

  1. Excel Graphics, Shapes WordArt and Text Boxes
  2. Using Shapes to Display Cell Contents
  3. Create a Custom Shape
  4. Formatting Shapes
  5. Reshaping Shapes and Printing objects
  6. Adding text boxes
  7. WordArt for Interesting Titles and Headlines
  8. Constructing SmartArt
  9. Add Clip Art
  10. Manipulate Graphics
  11. Adding Pictures to a Worksheet
  12. Crop an Image
  13. Picture Borders, Effects, and Styles
  14. Align Multiple Graphics
  15. Save your Graphic