[ Pobierz całość w formacie PDF ]
Choosing a Printer and Changing Settings
To select a " From the File menu, select Print to display the Print dialog box.
printer " From the Printer Name list box, choose the printer you wish to use.
" Select OK.
To change the " From the File menu, choose Page Setup to display the Page Setup dialog
printer settings box.
SAMPLE ONLY
" Choose the Options button to display the Properties dialog box for the
printer.
" Change the options required. The options will vary depending on what type of
printer you have.
" Select OK, and then select OK to close the Page Setup dialog box.
NOT TO BE
To set the print " From the File menu, choose Page Setup to display the Page Setup dialog
area box.
" Select the Sheet tab.
" In the Print area text box, enter the print area, or select the worksheet range
USED FOR
by clicking in the Print area text box and dragging through the worksheet to
select the areas you wish to print.
" Select OK.
TRAINING
SAMPLE ONLY NOT TO BE USED FOR TRAINING
© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200
Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/
86 Printing
1998 - Cheltenham Computer Training
© Excel 2000 Foundation
Printing a Worksheet
" From the File menu, select Print
" Or press Ctrl+P
Which displays the Print dialog box
Note that clicking on the
Print icon WILL NOT
display the Print dialog
box, but will send the job
directly to the printer
© Cheltenham Computer Training 1995-1999 Excel 2000 Foundation - A First Look at Excel - Slide No. 65
Printing a Worksheet
To print " From the File menu, select Print to display the Print dialog box.
" Select what you want to print in the Print what area, i.e. Selection, Active
sheet(s), or Entire workbook.
" Specify the number of copies you want to print in the Number of Copies spin
box.
" In the Page range area, select whether you want to print All pages in a range,
SAMPLE ONLY
or enter the starting and ending page numbers in the From and To spin
boxes.
" Select OK.
To print column " From the File menu, choose Page Setup to display the Page Setup dialog
NOT TO BE
or row titles on box.
every page " Select the Sheet tab.
" Click the Rows to repeat at top text box and then select the rows you want to
repeat by dragging over the rows in the worksheet. Click on the Columns to
repeat at left text box and select the columns to repeat in the same way.
USED FOR
" Select OK.
To print " From the File menu, choose Page Setup to display the Page Setup dialog
sideways box.
" Click the Page tab and click on Landscape in the Orientation area.
TRAINING
" Select OK.
To preview a " From the File menu, select Print Preview to display the preview window for
worksheet the sheet.
" Select the Close button when you have finished.
SAMPLE ONLY NOT TO BE USED FOR TRAINING
© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200
Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/
Printing 87
Excel 2000 Foundation ©
1998 - Cheltenham Computer Training
Printing Multiple Files
" Choose Open from the File menu and select files
to be printed (Ctrl and Click)
In the example
shown, 4 files have
been selected
Right click and
select Print from
the pop-up menu
© Cheltenham Computer Training 1995-1999 Excel 2000 Foundation - A First Look at Excel - Slide No. 66
Printing Multiple Files
To print a " Click on the File drop down menu.
number of files " Click on the Open command.
at the same
" Whilst holding down the Ctrl key select the files to be printed.
time
" Right-click on the files to display a pop-up menu.
" Select the Print command from the pop-up menu.
SAMPLE ONLY
NOT TO BE
USED FOR
TRAINING
SAMPLE ONLY NOT TO BE USED FOR TRAINING
© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200
Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/
88 Printing
1998 - Cheltenham Computer Training
© Excel 2000 Foundation
Review Questions
© Cheltenham Computer Training 1995-1999 Excel 2000 Foundation - A First Look at Excel - Slide No. 67
Review Questions - How Would You ...
1. Change Page Setup options?
2. Set print quality?
3. Change the margins?
4. Change header and footer margins?
5. Change margins in Print Preview?
6. Change the way the data is centered on the page?
SAMPLE ONLY
7. Center your printed output on a page?
8. Use standard headers and footers?
9. Create custom headers and footers?
10. Change sheet options?
11. Select a printer?
NOT TO BE
12. Change the printer settings?
13. Set the print area?
14. Print column or row titles on every page?
15. Print sideways?
16. Preview a worksheet?
USED FOR
17. Print multiple worksheets?
18. Print a number of files at the same time?
TRAINING
SAMPLE ONLY NOT TO BE USED FOR TRAINING
© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200
Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/
[ Pobierz całość w formacie PDF ]