Thursday, November 17th, 2011

Save space – Compress your images in Word

A reader just asked if they added 50 images to a Word file would that blow out the file size when they send it to their colleagues. Answer: Yep! big time.

Most specially if you use your your beaut iPhone to capture the images, or a good compact camera or if you just insert big pictures. You see, unless you do something those big pictures will be inserted in the file and included in it when you save it – you can end up with a monster Word file (think 5Mb x 50!)

The solution to the problem is to compress the images. To compress all the images in your Word 2010/2007 file so that they take less room, click on any image and choose Picture Tools > Format tab.  Locate the Compress Pictures button and deselect Apply only to this Picture so all images will be compressed.

If there is an Options button click it to see the sizing options (this appears in Word 2007 but not in Word 2010). Then choose the Target output – typically Screen or Print are good options as they will view well and print just fine. Check the Delete Cropped Areas of Pictures checkbox so cropped data won’t be saved. Click Ok. Then save the document.

This compression feature will reduce your file to a better size for sharing without compromising the quality of the document. And the changes affect only the images in the document not the originals on your disk.

Helen Bradley

Monday, March 19th, 2007

Shrink to size Excel Printouts

When you’re working on a very big worksheet in Excel sometimes it happens that when you print it out you get a stray row or column on a single sheet of paper. It’s not only a nuisance but it’s also a waste of paper.

To ensure that this doesn’t happen choose File, Page Setup and click the Page tab. The Fit To option lets you specify the number of pages wide or tall that a worksheet is. Select the measurements that you want to fit, for example fitting to one page wide by one page tall will print everything on a single page.

What if you don’t know both measurements? Don’t worry, if you know you want it one page wide but don’t know how tall that will be, select Fit to 1 Page Wide and leave the Tall box empty – that means delete anything that’s in it.

This works the same if you know how tall you want it to be but not how wide. It’s a smart way of saving trees and frustration and it looks much neater than handing someone something with a skerrick of info on the last page.

Helen Bradley