Microsoft Office Tutorials and References
In Depth Information
Change the name of Sheet1 to Report. To do so, double-click on
the text Sheet1 in the worksheet’s tab, and then enter Report .
To get a rough idea of the size of the page you need to fill, mark the
preliminary print area of your Report page. To do so, choose File,
Print Preview. If your worksheet is new, Excel will launch an error
dialog that says, “Microsoft Office Excel did not find anything to
print.” Press the Esc key. Your worksheet now displays the
boundaries of your default print area.
This print area will be easier to manage if you define it formally.
Select the default print area as it’s marked in your spreadsheet, and
choose File, Print Area, Set Print Area. When you do so, Excel
assigns the name Print_Area to the print area. You can modify it by
changing the definition of Print_Area or by selecting a new area
and choosing File, Print Area, Set Print Area.
Usually, your report will be easier to design if you set up the left and
right columns of your print area with narrow borders. Therefore, set
the width of these columns to 1.
To insert another column in your print area, choose an entire
column within the area by clicking on its column header. Hold down
the Ctrl key and press the + (plus) key. To remove a selected
column, hold down the Ctrl key and press the – (minus) key.
As you create your mockup, you probably will add and delete
columns several times. To see what your current report actually
looks like use the Print Preview command.