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

baliangn · Apr 18th, 2002, 02:04 PM

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

Chris Davison · Apr 18th, 2002, 03:40 PM

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 ]

Jack in the UK · Apr 18th, 2002, 03:47 PM

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

Jack in the UK · Apr 18th, 2002, 03:48 PM

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

Nice one Chris .. i was else ware...

Chris Davison · Apr 18th, 2002, 04:05 PM

Jack,

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

Jack in the UK · Apr 18th, 2002, 04:17 PM

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

Chris Davison · Apr 18th, 2002, 04:21 PM

just pulling your leg mate

I couldn't resist it !!

baliangn · Apr 18th, 2002, 08:05 PM

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

Apr 18th, 2002, 03:47 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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"

Apr 18th, 2002, 03:48 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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"

Apr 18th, 2002, 04:17 PM	#6
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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"

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

Apr 18th, 2002, 02:04 PM	#1
baliangn New Member Join Date: Mar 2002 Location: Glenn Balian Posts: 3	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

Apr 18th, 2002, 03:40 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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 ]

Apr 18th, 2002, 04:05 PM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Jack, once again you have just BLATENTLY copied another person's posting....

Apr 18th, 2002, 04:21 PM	#7
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	just pulling your leg mate I couldn't resist it !!

Apr 18th, 2002, 08:05 PM	#8
baliangn New Member Join Date: Mar 2002 Location: Glenn Balian Posts: 3	Thanks guys! I used the copy--paste picture link drill, but the camera shortcut is a much better option. Thanks for the tip! Glenn