Microsoft Office Tutorials and References
In Depth Information
The Excel user interface
Changing page setup options
Page setup is often the key to making a worksheet more readable. You can adjust the page
orientation and margins to control how a worksheet displays when it is printed. For example,
your workbook data might be too wide to i t on a standard-sized sheet of paper in portrait
(tall) format. You can change the page orientation to landscape (wide) to give the contents of
the worksheet more space, or in case you want to add more columns of data later.
On the Ribbon, click Page Layout > Orientation > Landscape.
Click File > Print to view your page in landscape orientation.
Click the File tab to return to your document. Notice that Excel has marked the edge of
your page with a dotted line. This represents the right margin of the page.
Shading cells and changing Font Color
To give your worksheet some style, you can add shading and color to the cells and text. You
will highlight the i rst two columns of your worksheet with yellow, shade the top line with
blue, and change the top line font color to white.
Select the i rst two columns by clicking column A and then dragging to the right
through column B.
Click the Home tab and in the Font group, click on the down arrow next to the Fill
Color button ( ). Excel displays a menu of possible i ll colors.
Click the yellow square under Standard Colors.
You can change the i ll color of the cells.