Spreadsheets

Unit 2: Creating More Effective Spreadsheets

Lesson 4: Formatting


How do you adjust page breaks?

A worksheet can grow very wide and very long. You can add much more data to a worksheet than can be printed on one page. By default Excel prints as much as can be printed on each page in the order: top-to-bottom, right-to-left. For example, the following worksheet has the pages labeled in the order they will be printed:

In Page Break Preview you can adjust the location of the page breaks.

The following animation shows an example.

Adjusting page breaks

One comment about adjusting page breaks: You can also go to the Page Break Preview mode from the Print Preview mode.

Previous Next


Copyright 1997 by the Curators of the University of Missouri