Results 1 to 13 of 13
  1. #1
    Lounger
    Join Date
    Apr 2001
    Location
    Johannesburg
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Saving a spreadsheet image

    1. Is it possible to save a selected area in a spreadsheet as a bmp or jpg file from Excel.

    2. Can I copy a selected area in a spreadsheet to a mail message without losing formats.

    I am using Office 2000, win98 and MS Outlook

    Thank You

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Saving a spreadsheet image

    Excel does not have the facility to save graphic formats, but you can take a bitmap snapshot of a given area, start MSPaint or Photo Editor (or any other bitmap editing tool) and paste the image into that and save as the required format. To do this, select the area you wish to save, and holding down the Shift key, goto Edit, Copy Picture, and when prompted set the format to Bitmap. Then paste into your paint program and save as jpg or bmp etc.

    Question no 2 depends on what settings you have in place. Experiment by cutting and pasting, but most basic formatting should be ok.

    Andrew C

  3. #3
    Lounger
    Join Date
    Apr 2001
    Location
    Michigan, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving a spreadsheet image

    you may want to looks at a shareware program called 'SnagIt'. It works very well for capturing a section of a window an creating an image.

    <A target="_blank" HREF=http://www.techsmith.com/products/snagit/default.asp>http://www.techsmith.com/products/snagit/default.asp</A>

    I think there may be some other freeware screenprint utilties that allow you to crop a captured screen image (PrintKey may be one of them)

    HTH

    Mark

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,469
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Re: Saving a spreadsheet image

    Have you tried using the CAMERA under Tools|Customize, Commands|Tools|Camera?

  5. #5
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving a spreadsheet image

    I didn't realise you could use camera to do that. Can you provide a little eddification for me?

    Brooke

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,469
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Re: Saving a spreadsheet image

    Well, the camera doesn't actually make either a bmp or jpg, but I thought the original poster just wanted to capture a snapshot of a formatted section of a sheet. If you drag over the section you want and then click the camera icon (if you've placed it on a toolbar), click the mouse elsewhere in the sheet and the image is inserted. While it's selected you can copy it, move to Word, say, and paste the snapshot. Cute.

  7. #7
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Saving a spreadsheet image

    Hey! Cool! <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  8. #8
    Brian Roby
    Guest

    Re: Saving a spreadsheet image

    That is really great, but can the image be used on a vb form so that a user could see a picture of a section on the spreadsheet prior to moving there?
    Brian.

  9. #9
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving a spreadsheet image

    I was actually looking for a recent post by Legare but found this on the same subject instead. Any good?

    Brooke

  10. #10
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving a spreadsheet image

    I didn't know about the camera, but I did use the following technique in the past:

    1) Select the region you want, Ctrl-C to copy.
    2) Open Word, choose Edit (menu), Paste Special..., then choose "Picture (Enhanced Metafile)" from the "As:" list and click OK.

    This is a great technique for "icing" portions of Excel workbook for a summary report. It works on graphs, too.

    After trying the camera, it looks like the same functionality in Excel, but it requires the camera button because the Paste Special choices for Excel are more Excel-specific and less generic.

  11. #11
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving a spreadsheet image

    Hi:
    I might as well throw in another little trick here. Here is a way that can capture a portion of the spreadsheet without even having to load the CAMERA function:
    Select the portion of the spreadsheet you want and with the
    your shift key depressed, go to Edit>Copy picture Accept
    the defaults and click Ok and then Paste anywhere in EXCEL or WORD or where ever.

  12. #12
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving a spreadsheet image

    Way cool!

  13. #13
    Star Lounger
    Join Date
    Feb 2001
    Location
    Virginia Beach, Virginia, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving a spreadsheet image

    Lets not forget the the alt-Print Screen. Copies the active window into the clipboard. Paste into photo editor and crop. Fast, simple, and you already have all the parts. Works for any application

Posting Permissions

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