Financial Planning Software: MS Excel Printing Tips.

First, try resizing rows and columns. You can either drag the row or column borders, or right click on the row numbers or column letters, and then choose height or width. Or using the same menu, you can also hide or unhide rows or columns, or insert new rows or columns. Usually all it takes is resizing to get what you want.

Once you get things to print the way you want to, save the file as the original template, so the next time you use it, you won't have to go through it again.

This page is mostly only for the demos, because everything is password protected, and you can't change row and column sizes to make it print right. It's impossible to format all of the demos to print right because of all of the different kinds of printers. So using Excel to print the exact print ranges you set is the best way to print protected spreadsheets.

When you get the actual programs, you can change row and column sizes to print right on your printer, then save, and then it will always print that way.

If you click on a graph/chart you then selected just that chart. You can then print it on one page.

Also, with Excel, if there's anything in a place outside the print area you want, then it will print a bunch of blank pages in order to print everything. So it's best to do a Print Preview first. Then count how many, or which pages, you actually want to print. Then you can only print the page(s) that you want to. Click File, Print... then in the Print Range section in the middle, click From: then scroll until 1 appears, then click the field To: then scroll until the last number of pages appears. Then click OK.

First, do a Print Preview so you can see the dashed gridlines. Go to File, Print Preview. When it's up, click Close. Now the area is shown on the spreadsheet that will automatically print when you click Print (and not Print... which will bring up another menu, which is needed later).

More than likely, this will not be the area you want to print. If you're using the actual program, and it's only off a little bit, then you can tinker with row and column sizes to make it right. If not, then you have to set and print via ranges.

How To Set and Print Ranges in Excel

Printing a range in Excel is just telling Excel only to print an exact area. This area is called a range.

Words in italic font are actual menu selections.

1) Highlight the area you want to print.

For example, put your cursor in the middle of cell A1, then drag it down and to the right until the area you want to print is only in the black or blue box (highlighted area).

If you don't want the top left corner to be cell A1, then click where you want the top left corner to be. Once you've highlighted a range that you want to print, proceed to step 2.

2) Menus: File, Print Area, Set Print Area

3) Menus: File, Page Setup

On the far left Page tab, in the middle there is a section called Scaling.

Change Scaling from "Adjust to:" to "Fit to:" then click OK.

4) Menus: File, Print... (not Print, you want the one with the three dots after it).

The bottom left section is the Print What section.

Check Selection. Click OK.

5) Menus: File, Print Preview to see what's going on first.

If it looks like it will print only the area you want, then you did it correctly.

At this point, make a note of what page you actually want to print, to prevent it running amok and printing tons of blank pages or wasting paper.

6) Print (or Print... then select only the pages you want to print, then click OK).

How to send financial plans to clients via e-mail, without sending the whole program is explained on the Excel help page, here.