Excel 2010 Bible

Part I: Getting Started with Excel

174

Tip
If you’d prefer to not see the page break display in Normal view, choose FIle ➪ Options and select the Advanced
tab. Scroll down to the Display Options for This Worksheet section and remove the check mark from Show Page
Breaks. This setting applies only to the active worksheet. Unfortunately, the option to turn off page break display
is not on the Ribbon, and it’s not even available for inclusion on the Quick Access toolbar. n

Figure 9.1 shows a worksheet in Normal view, zoomed out to show multiple pages. Notice the

dotted lines that indicate page breaks.

FIGURE 9.1

In Normal view, dotted lines indicate page breaks.

Page Layout view .....................................................................................................

Page Layout view is the ultimate print preview. Unlike the preview in Backstage View (choose

File ➪ Print), this mode is not a view-only mode. You have complete access to all Excel commands.

In fact, you can use Page Layout view all the time if you like.

Figure 9.2 shows a worksheet in Page Layout view, zoomed out to show multiple pages. Notice

that the page header and footer (if any) appear on each page, giving you a true preview of the

printed output.