paste as picture/object?

[chouston]

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]

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]

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

 

[Chris Davison]

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