Page 5 of 23PREVNEXT

So that's how! Printing options in Excel

The Margins tab in the Page Setup dialog box

In the Page Setup dialog box, on the Margins tab, you can adjust the margins by entering different numbers in the Top, Bottom, Left, and Right boxes.

Another way to fit more data on a single printed page is by adjusting the worksheet margins.

How? In print preview, click Setup to open the Page Setup dialog box (or in normal view, on the File menu, click Page Setup).

The default margins for the top and bottom of the page are 1 inch. For the left and right, the default margins are three quarters of an inch. However, on the Margins tab, you can click in the Top, Bottom, Left, and Right boxes to enter new sizes for the margins. You might make small changes to start with, so that margins are narrowed only by the necessary amount.

You can also drag the margin lines in print preview to change margins. It can be a little easier to control margins precisely by typing than by dragging them. On the other hand, the preview on the Margins tab is smaller and less precise than print preview, so you'll want to check your changes there. You'll see how to use both methods in the practice.

Note     Keep in mind that you can adjust the margins only so far; your printer sets its own limits on just how narrow the margins can be. You'll find out what those limits are when you actually print.

Page 5 of 23PREVNEXT