- Clear cell gridlines if you do not want them displayed in your picture.
- Click Options on the Tools menu, click the View tab, and then clear the Gridlines check box.
- On the worksheet or chart sheet, select the cells or click the chart or object you want to copy as a picture.
- Hold down SHIFT and click Copy Picture on the Edit menu.
- 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.
- Click the worksheet or other document where you want to paste the picture.
- Click Paste .
You can use the Picture toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.) to change the image.
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.