Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Create a picture from cells, a chart, or an object
 
  1. Clear cell gridlines if you do not want them displayed in your picture.

    ShowHow?

    • Click Options on the Tools menu, click the View tab, and then clear the Gridlines check box.

  2. On the worksheet or chart sheet, select the cells or click the chart or object you want to copy as a picture.
  3. Hold down SHIFT and click Copy Picture on the Edit menu.
  4. For the best picture quality, make sure As shown on screen and Picture are selected, and then click OK.

    Note  To preserve picture quality, an item copied using the As shown on screen and Picture options is pasted at 100% of its original size. For example, if you scale a worksheet at 75%, an item copied from it may appear larger when pasted because it is pasted at actual size. The display of some items in charts— such as vertical as opposed to angled axis text— may also be affected.

  5. Click the worksheet or other document where you want to paste the picture.
  6. Click Paste Button image.

    You can use the Picture toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.) to change the image.

ShowTip

To paste information you've copied from another program as a picture in Microsoft Excel, hold down SHIFT and click Paste Picture or Paste Picture Link on the Edit menu.

© 2009 Microsoft Corporation. All rights reserved.