Microsoft Office Tutorials and References
In Depth Information
The colors and contrast of the AutoFormat design do not complement the background, so
you will revert to the format you created.
4. Click the Undo button
on the Standard toolbar to remove the AutoFormat design.
Although you will not use AutoFormat in this case, you can see how an AutoFormat
design can be a starting point. You could start with an AutoFormat design and then make
modifications to the worksheet to fit your own needs.
Formatting the Printed Worksheet
You have settled on an appearance for the Sales worksheet—at least the appearance that
is displayed on your screen. But that is only half of your job. Joan also wants you to for-
mat the appearance of this worksheet when it is printed out. You have to decide on the
position of the report on the page, the size of the page margins, the orientation of the
page, and whether the page will have any headers or footers. You can make many of these
choices using the Page Setup dialog box, which you can open from the File menu or from
within Print Preview.
Defining the Page Setup
As you learned in Tutorial 1, you can use the Page Setup dialog box to change the page
orientation, which determines if the page is wider than it is tall or taller than it is wide.
You can also use the Page Setup dialog box to control how a worksheet is placed on a
page. You can adjust the size of the margins , which are the spaces between the page con-
tent and the edges of the page. You can center the worksheet text between the top and
bottom margins (horizontally) or between the right and left margins (vertically). You can
also use the Page Setup dialog box to display text that will appear in the area at the top of
a page or at the bottom of a page for each page of a worksheet. You can open the Page
Setup dialog box using the File menu or using the Print Preview toolbar. Working from
within Print Preview can be helpful. Each time you close a dialog box in which you have
made a change or selected an option, you will see how that action impacts the worksheet
before printing it.
By default, Excel places a one-inch margin above and below the report and a 3 ⁄ 4 -inch
margin to the left and right. Excel also aligns column A in a worksheet at the left margin
and row 1 at the top margin. Depending on how many columns and rows there are in the
worksheet, you might want to increase or decrease the page margins or center the work-
sheet between the left and right margins or between the top and bottom margins.
You will increase the margin size for the Sales worksheet to one inch all around. You
will also center the worksheet between the right and left margins.