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

Thread: Copy cells of one size and format as a picture to another pa

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Glenn Balian
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a need to copy several cells to another part of the worksheet (as an image) so that the column settings don't come into play

  2. #2
    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

    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

    NB - may be a disadvantage, may be a bonus : this image is realtime : if your scource cells change, the image will also change, similar to a linked cell

    Hope this helps,
    Chris




    marker camera


    [ This Message was edited by: Chris Davison on 2002-04-18 14:41 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    maybe chris D will smile use the camra simple as that it will update..

    OK dont tell Chris (he tought me this trick) but you can cool edit the fill so gold and all kinds of effect and size and all sorts of tricks weel cool, top trick the font size is set from original data i recall...

    CAMRA .... coll stuff.. update original and BANG snap shot is amended..



    I promised i would never forget to advise this one ... it works trust me


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dam chris beat me ... chris he has given better details above...

    Nice one Chris .. i was else ware...
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  5. #5
    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

    Jack,

    once again you have just BLATENTLY copied another person's posting....

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi Chris

    evidence

    top is you data below is my data as recored my this site

    Posted: 2002-04-18 14:40
    Posted: 2002-04-18 14:47

    so i post 6 minutes and 1 mun to transfer you psot and mine makes 7

    allowing the time you have to read and the time i have to read and the time to reply and they add i have 3 brokern fingers and can hardly read .. and typing hurts, i challenge th e6 minute delay..

    i gues to type that lot i did would take me (not every one ) what 4 or 5 mins so that means im on th ebutton.. i guess i read as you posted...

    remeber i posted in real time.. and most of my post is about you you mad man,,,

    i wonder some times and then i say sorry....

    ... carry on pulling my leg mate i dont mind... copy posts i have no the time.. i have 17 email im working on some huy in Iran keeps posting/ emailing me and asking if i can crack codes?? but ive ask the file and still its not sent>>>>> odd.

    Students seem to love me as well, many not posting on here again i add, but tthey seem frightened, sad that.. i do help them thou:

    Do you get loads of emails???? NO NOT all the stuff i send you i add! or ill post you some live ells! to habg in the gallery

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  7. #7
    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

    just pulling your leg mate



    I couldn't resist it !!

  8. #8
    New Member
    Join Date
    Mar 2002
    Location
    Glenn Balian
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks guys!
    I used the copy--paste picture link drill, but the camera shortcut is a much better option. Thanks for the tip!
    Glenn

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
  •