Create a picture from cells, a chart, or an object

If needed, you can copy worksheet data, charts, or objects and paste them as a static picture anywhere in a worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) or chart. You can also paste data that you copied from another program and paste it as a picture in Microsoft Office Excel.

What do you want to do?


Copy data as a picture in Excel

  1. To clear cell gridlines if you do not want them displayed in your picture, do the following:
    1. Click the Microsoft Office Button Button image, and then click Excel Options.
  1. In the Advanced category, under Display options for this worksheet, clear the Show gridlines check box.
  1. On the worksheet or chart sheet, select the cells or click the chart or object that you want to copy as a picture.
  2. On the Home tab, in the Clipboard group, click the arrow below Paste, click As Picture, and then click Copy as Picture.

Excel Ribbon Image

  1. In the Copy Picture dialog box, do the following:
    1. Under Appearance, click the option that you want to use.
    2. Under Format, click the option that you want to use.
    3.  Tip   For the best picture quality, make sure that the As shown on screen and Picture options are selected. However, to preserve picture quality, items that you copy by using the As shown on screen and Picture options are always pasted at 100% of their original size. For example, if you scale a worksheet at 75%, a copied item from that worksheet may appear larger because it is pasted at actual size.

  2. Click OK.
  3. On the worksheet or other document, click where you want to paste the picture.
  4. On the Home tab, in the Clipboard group, click Paste Button image.
    1. Keyboard shortcut  You can also press CTRL+V.
  1. If you want to format the picture, do the following:
  1. Select the picture.

 Tip   This displays the Picture Tools, adding the Format tab.

  1. On the Format tab, in the Adjust group, Picture Style group, Arrange group, or Size group, click the formatting options that you want.

Top of Page Top of Page

Copy data from another program and paste it as a picture in Excel

  1. In another program, such as Word, use that program's Copy command to copy the data that you want to paste as a picture in Excel.
  2. In Excel, click anywhere in a worksheet or chart where you want to paste the copied data as a picture.
  3. On the Home tab, in the Clipboard group, click the arrow below Paste, click As Picture, and then click Paste as Picture or Paste Picture as Link.

Excel Ribbon Image

  1. If you want to format the picture, do the following:
    1. Select the picture.

 Tip   This displays the Picture Tools, adding the Format tab.

  1. On the Format tab, in the Adjust group, Picture Style group, Arrange group, or Size group, click the formatting options that you want.

Top of Page Top of Page

 
 
Applies to:
Excel 2007