Task: set page
properties and print spread sheet
|
No
|
C8
|
|
No
|
Steps
|
Yes
|
No
|
01
|
Open spreadsheet package
|
||
02
|
Create or open exiting Workbook
|
||
03
|
Load the paper in to the printer
|
||
04
|
Check printer on/off
|
||
05
|
Set paper size
|
||
06
|
Set paper margin
|
||
07
|
Select paper orientation
|
||
08
|
Apply paper header and footer
|
||
09
|
Click print preview option
|
||
10
|
Correct the document than click print
command
|
||
11
|
Select printer name
|
||
12
|
Select print range
|
||
13
|
Select print what
|
||
14
|
Select number of copies
|
||
15
|
Click ok
|
||
Preparing to Print and Printing
1.
To View the
Spreadsheet in Print Preview:
2.
Left-click
the Microsoft Office Button.
3.
Select Print.
4.
Select Print
Preview. The spreadsheet will appear in Print Preview view.
Click the Close
Print Preview button to return to the Normal View. To make previewing your
spreadsheet easier, add the Print Preview command to the Quick Access
toolbar. Exploring Print Preview: Once you are in Print Preview, you can
access many of the same features that you can from the
To Modify Margins, Column Width, or Row Height While in Print Preview:
1.
Click the Print
Preview command on the Quick Access toolbar, or select Print Preview from
the Microsoft Office Button menu. The spreadsheet opens in print preview mode.
Hover your cursor over one of the black margin markers until a double
arrow appears.
2.
Left-click and drag the
marker to the desired location. The change will be reflected in the spreadsheet.
To Modify Margins:
1.
Select the Page Layout
tab.
2.
Left-click the Margins
command.
3.
Choose one of the
predefined settings or enter custom margins.
To Change Page Orientation:
1.
Select the Page Layout
tab.
2.
Left-click the Orientation
command.
3.
Select either Portrait or
Landscape.
Portrait orients the page vertically, while Landscape
orients the page horizontally.
To Use Scale to Fit:
1.
Select the Page Layout
tab.
2.
Locate the Scale to Fit
group.
3.
Enter a specific height
and width, or use the percentage field to decrease the spreadsheet
by a specific percent. Scale to Fit is a useful feature that can help you
format spreadsheets to fit on a page. Be careful with how small you scale the
information -- it can become difficult to read!
To Change the Paper Size:
1.
Select the Page Layout
tab.
2.
Click the Size command.
3.
Select a size option from
the list.
To Define a Print Area:
1.
Left-click and drag your
mouse to select the cells you wish to print.
2.
Click the Print Area command.
3.
Choose Set Print Area.
4.
Now, only the selected cells
will print. You can confirm this by viewing the spreadsheet in Print Preview.
To return to the default setting, which is the entire worksheet, click the
Print Area command and select Clear Print Area.
To Insert a Break:
1.
Select a cell below where
you want the break to appear.
2.
Select the Breaks command.
3.
Select Insert Break.
4.
Click Print Preview to
confirm the break appears in the correct place in your spreadsheet.
No comments:
Post a Comment