Separate Pages When Printing – Page Breaks

You can spend a lot of time inserting and deleting rows in your worksheet so that when you print it your information stops and restarts on the next page where you want it to. This can be very frustrating and cost you a lot of ink and paper when testing each adjustment.

Help is on the way! Simply design your worksheet without concern about printing it. When you’re done, now you can define how it will look on paper.

Now, go to one row below where you would like the printer to restart on a new page and do the following:

1. Go to the Insert drop down on the main menu at the top of the page
2. Choose Rows and press Enter… a blank row will be inserted into your worksheet
3. Make sure the first cell in the new row is the active cell and return to Insert drop down on the main menu at the top of the page
4. Choose “Insert Page Break” … you’ll see a dotted lin appear in that row… This is cool because when you print your worksheet a new page will start at this “break”.

Now you have “Design Power”. Use Print Preview from the File menu…oops! don’t like what you see? Let’s change it.

1. Go to the row where you inserted a Page Break
2. Go to the Insert drop down on the main menu at the top of the page
3. Choose “Remove Page Break”
4. The page break is gone and you can repeat the steps above to define a new row where you would like a new Page Break to be inserted.

Any problem with this procedure?

Call Peter at PAS Administration Support Services…

We Can Help!

613-347-9893