paste as picture/object?

chouston · Apr 29th, 2002, 10:52 AM

Hi! I have about sixty-five spreadsheets that store data and generate bills for about 500 people on each one, at the end of each spreadsheet I have a summary for that property. I would like to copy the summaries from several of these workbooks onto one spreadsheet. When I was playing around, I somehow managed to paste the summary as a picture/object that couldn't be modified and didn't try to link to the original spreadsheet. However, I can't figure out how to do this again!! Can anyone help me?

klb · Apr 29th, 2002, 11:55 AM

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 best picture quality, make sure As shown on screen and Picture are selected, and then click OK.

Click the worksheet or other document where you want to paste the picture.

Click Paste

You can use the Picture toolbar to change the image.

chouston · Apr 29th, 2002, 11:59 AM

Thanks KLB this is exactly what I wanted,
although I have no idea how I managed to do this on accident...

Chris Davison · Apr 29th, 2002, 01:32 PM

If you like the functionality of being able to paste pictures like this, I'd strongly recommend looking into Excel's "camera" utility..... it does this exact same thing but updates the picture automatically if the scource cells are changed... (like a link)

very very useful if you're using snapshots of different areas of your worksheet and pulling htem all together ina summary or something...

view
toolbars
customise
commands
tools.......... scrolldown the options

click the camera icon and drag it to your toolbar, you should now have a camera sitting on your toolbar

now highlight your cells in question and click the camera, this will take a snapshot of those cells

now go to where you want to show them as an image, click and drag to max size

if you don't like the format (opaque-ness, lines etc etc) right-click the new image and play around with the formats

Apr 29th, 2002, 01:32 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	If you like the functionality of being able to paste pictures like this, I'd strongly recommend looking into Excel's "camera" utility..... it does this exact same thing but updates the picture automatically if the scource cells are changed... (like a link) very very useful if you're using snapshots of different areas of your worksheet and pulling htem all together ina summary or something... view toolbars customise commands tools.......... scrolldown the options click the camera icon and drag it to your toolbar, you should now have a camera sitting on your toolbar now highlight your cells in question and click the camera, this will take a snapshot of those cells now go to where you want to show them as an image, click and drag to max size if you don't like the format (opaque-ness, lines etc etc) right-click the new image and play around with the formats __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 10:52 AM	#1
chouston Board Regular Join Date: Apr 2002 Location: Arizona Posts: 68	Hi! I have about sixty-five spreadsheets that store data and generate bills for about 500 people on each one, at the end of each spreadsheet I have a summary for that property. I would like to copy the summaries from several of these workbooks onto one spreadsheet. When I was playing around, I somehow managed to paste the summary as a picture/object that couldn't be modified and didn't try to link to the original spreadsheet. However, I can't figure out how to do this again!! Can anyone help me?

Apr 29th, 2002, 11:55 AM	#2
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	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 best picture quality, make sure As shown on screen and Picture are selected, and then click OK. Click the worksheet or other document where you want to paste the picture. Click Paste You can use the Picture toolbar to change the image.

Apr 29th, 2002, 11:59 AM	#3
chouston Board Regular Join Date: Apr 2002 Location: Arizona Posts: 68	Thanks KLB this is exactly what I wanted, although I have no idea how I managed to do this on accident...