Excel 2019 Bible

(singke) #1

Chapter 7: Printing Your Work


7


FIGURE 7.2
In Page Layout view, the worksheet resembles printed pages.

When you enter Page Break Preview, Excel performs the following:

■ (^) Changes the zoom factor so that you can see more of the worksheet
■ (^) Displays the page numbers overlaid on the pages
■ (^) Displays the current print range with a white background; nonprinting areas appear
with a gray background
■ (^) Displays all page breaks as draggable dashed lines
When you change the page breaks by dragging, Excel automatically adjusts the scaling so
that the information fits on the pages, per your specifications.
In Page Break Preview, you still have access to all Excel commands. You can change the zoom factor if you find the
text to be too small.
To exit Page Break Preview, just click one of the other View icons on the right side of the
status bar.

Free download pdf