Monday, December 26, 2011

How to Copy a Worksheet As a Picture in Excel 2007


1. Highlight the area that you want to copy as a picture. Click in the uppermost left cell and drag to the lowermost right cell while holding down the mouse button.
2. Click the 'Copy' drop-down menu on the 'Home' tab. Select the 'Copy as Picture' option. This action will launch a separate dialog window.
3. Select 'As shown on screen' to copy the selection as a screen shot, or select 'As shown when printed' to copy the selection as it would appear printed on a page. Select the 'Picture' option to copy the worksheet as a scalable image, or select 'Bitmap.' The 'Bitmap' copy will result in more distortion if you need to enlarge the worksheet picture after it is pasted into another document. Click the 'OK' button to copy the worksheet. You may now paste the picture into another document using the 'Paste' option.

Blogger news