Printing: Tips & Tricks - III

Keep It Simple

Many ink jet printers offer a draft or fast mode. If you aren't too concerned with print quality, draft mode may not only save you time, but ink too.

Switching from color mode to black and white can also add to your savings.


Print Area [In Excel]

By default, an entire worksheet is printed in Excel unless you indicate a specific print area. To limit the printed area,

1) Highlight the cells you want to print,

2) Choose File > Print Area > Set Print Area.

The new print area remains in place until changed.

To clear the current print area, pick File > Print Area > Clear Print Area.




Fit to Page [In Excel]

Unlike Word documents, content is not limited by the paper size or orientation. A worksheet can be split into as many pages as needed to display the content but sometimes you might want to fit all data into one page by height or width. To do this, first choose File > Page Setup, set margins to the smallest size that will work for your layout. Change paper size and orientation if you want. Next, select the Page tab and under the Scaling category pick Fit to For instance, if you want to fit all data columns on one lengthwise page, change orientation to landscape and choose Fit to 1 page wide by 999 pages tall. Try it, this setting won't stretch pages to 999 pages but will make sure that a low value won't accidentally shrink the pages to a much smaller size. Another option under Scaling is to adjust the size to a percentage of the normal size.

To be Continued...

Printing: Tips & Tricks - II

Duplex Printing

Many larger printers offer an automatic duplexing option, allowing you to easily print on both sides of a sheet of paper.

Unfortunately, the option is not always enabled by default.

To set this option on a per print basis, go to File -> Print, Select the Printer and then select Properties button to get the Printer Properties.






N-Up Printing

Some programs and printers allow users to shrink documents so that multiple pages can be printed onto a single sheet of paper. So called N-up printing can be convenient for reference documents, especially if you don't want them taking up a lot of space.

You may not want to read an entire book at 16 pages per sheet, but it can be convenient to have your address book crammed onto just a few sheets of paper to carry in a notebook or wallet.

Microsoft® Office Word offers a Pages per sheet option when printing that allows up to 16 pages to be printed onto a single sheet of paper. Similarly, Microsoft® Office PowerPoint's handouts can be printed with up to 9 slides per page. For even more flexibility, some printers have n-up capabilities built into the printer driver, allowing n-up printing regardless of the application.

To set this option on a per print basis, go to File -> Print, Select the Printer and then select Properties button to get the Printer Properties.


To be Continued...