From the Hotel - Page Setup - Multiple Ranges

Good Evening,

I figured I'd spend a couple of minutes this evening to post a quick item related to this weeks topic. By the way - I highly recommend Embassy Suites to anyone traveling.

Today I'm going to keep it brief, but I thought I'd touch on another more advanced method for setting print area.

Click on File-> Page setup, and look at the print area. You will notice that your range is over a single area. In my Example, it's A1:Y7.

If you have a spreadsheet where you want to print two pages, on two areas, but don't want anything else, you can create a custom print area to highlight these two areas. To do this, click one in the print area box. Then click and drag an area on your spreadsheet. Then hold down the ctrl key, and click and drag a second area on your spreadsheet. The resulting range in the print area should look like below.

Now, using the Page Break View discussed yesterday, you can see that two areas are surrounded by the blue box. Now that you have two areas, you can continue to change the range of the print area by clicking and dragging the blue box.

Good Luck