Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: paste as picture/object?

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Arizona
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Minnesota
    Posts
    821
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Arizona
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ::

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •