Turn Excel Data, Charts into JPEGs : FPA Technology Services, Inc.
818-501-3390
Newsletter
Username:  Password:  
Login
Support
Client Resources
What We Do…
Loading...

Managed Services

MSP Alliance for What we do Widget
FPA provides "Worry Free, Fixed Fee" Managed IT Support Services so that our clients take a more proactive and cost effective approach to managing and maintaining their IT Infrastructure.
learn more
Loading...

Managed Services

MSP Alliance for What we do Widget
FPA provides "Worry Free, Fixed Fee" Managed IT Support Services so that our clients take a more proactive and cost effective approach to managing and maintaining their IT Infrastructure.
learn more
Loading...

Network Infrastructure

Microsoft Gold Certified Partner
Did you know that FPA also specializes in assisting small and medium-sized businesses in getting the most from their computer systems and computer system infrastructure?
learn more
Loading...

Development Services

Application and Web Development Services
Did you know that FPA also specializes in providing custom application and web development services to clients requiring unique software, web, and eCommerce solutions?
learn more
learn more
Quote Box Top
Highest praise I can give is to recommend your services. Good people, collaborative, understand our pain points and are an extension of our team.
Quote Box Bottom
Barbara Palmer
The Search Agency
Quote Box Bottom


GENERAL TIPS & TRICKS

Turn Excel Data and Charts into JPEGs

Loading...

Turn Excel Data and Charts into JPEGs

Morph mounds of Excel data into small, easy-to-copy pictures.

by Neil J. Rubenking

In Excel 2003 there's a little trick. Hold down the Shift key and choose Edit from the menu. Note that instead of Copy it offers Copy Picture—select that item. You'll be asked whether to copy as Picture or Bitmap, and whether to copy the image As shown on screen or As printed. You'll almost always want to choose Bitmap and As shown on screen. If you choose Picture, the image will be copied as a resizable Windows Metafile, and not all programs can use that format.

Naturally, it's different in Excel 2007. To copy a range as a picture, in the Home ribbon's Clipboard pane click the Down arrow under Paste, choose As Picture from the menu, and then Copy as Picture. (If you're surprised at having to choose Paste when you want to copy, remember this is coming from the same company that makes you click Start when you want to shut down.) As in Excel 2003, you'll generally want to copy it as Bitmap and As shown on screen.

But wait! In either version it can be easier, much easier. Just highlight the data range, chart, or whatever and press Ctrl-C. Excel puts the data into the clipboard in a variety of formats, so different programs can make use of it. It includes both formatted and unformatted text, as well as a format proprietary to Excel. And it also copies the data area as an image—Excel 2007 supplies four distinct image formats. When you switch to your graphics program and press Ctrl-V, the program will choose the clipboard format that suits it best.