[ Pobierz całość w formacie PDF ]
.Alternatively, to move more quickly through a longdocument, drag the scroll box.As you drag, Excel displays the current page number inthe lower left corner of the Print Preview screen.Ï% Click Zoom to display the page in roughly 100 percent Zoom the same size that yousee in Normal view.Click Zoom to return to the normal Print Preview whole-pageview.Alternatively, you don t need to use Zoom at all.Click anywhere (except on a dis-played margin line) and the preview zooms in; click anywhere in zoomed mode andthe preview returns to whole-page view.343Part 4: Adding Graphics and PrintingChapter 11 Microsoft Office Excel 2003 Inside Outf11ie08Figure 11-8.You can change the margins of a worksheet displayed in Print Pre-view by clicking the Margins button.Ï% Next to the Close button is a button entitled either Normal View or Page Break Pre-view, depending on the view you were using when you went into Print Preview.If youwere working in Normal view when you opened Print Preview, the button is entitledPage Break Preview.If you were in Page Break Preview when you opened Print Preview,the button is called Normal View.This button opens the corresponding view when youclick it.After you re satisfied with the appearance of your document, you can click Print to print thedocument, or you can click Close to leave Print Preview and return to the previous view.Specifying What and Where to PrintClick the Print button on the Standard toolbar, and the entire active area of the current work-sheet is immediately sent to the printer.For all but the most basic of worksheets, you ll prob-ably need to provide a bit more information, beginning with specifying exactly what youwant to print.To do so, choose File, Print to display the Print dialog box.You can print only a particular range of pages by entering the starting and ending page num-bers in the From and To boxes in the Print Range area of the Print dialog box, shown inFigure 11-9.344Part 4: Adding Graphics and PrintingChapter 11 Printing and Presentingf11ie09Figure 11-9.Use the Print dialog box to tell Excel what you want to print and how manycopies you want.The Print dialog box contains these additional options for specifying what, where, and howyou want Excel to print:Ï% Entire Workbook.Print the entire workbook, not just the current worksheet.Ï% Active Sheet(s).Print a group of worksheets but not the entire workbook.To do so,first select the worksheets you want to print as a group before choosing File, Print.Formore information about selecting a group of worksheets, see Editing Multiple Work-sheets on page 183.Ï% Selection.Print any selected range of a worksheet.Ï% Copies.Specify the number of copies you want.You can instruct Excel to print up to32,767 copies at a time.Ï% Collate.If your worksheet is more than one page long and you plan to print multiplecopies, have Excel collate the copies for you.For example, instead of printing 5 copiesof page 1, followed by 5 copies of page 2, Excel prints page 1 and page 2 together, printsthe next set, and so on.Collated copies are more convenient but might take slightlylonger to print.Ï% Print to File.Send the selected data to a file on disk, instead of to the printer.Tip Find a printer on the networkThe Find Printer button shown in Figure 11-9 is useful when you are connected to a net-work, running Windows 2000 or later, and using Windows Active Directory Service.Clickthis button to search for all the printers that are available anywhere on your network.The Name box of the Print dialog box displays the name of your default printer.To use a dif-ferent printer, click the down arrow to display a list of available printers and then select theprinter you want to use.345Part 4: Adding Graphics and PrintingChapter 11 Microsoft Office Excel 2003 Inside OutPrinting to a FileThe Print To File check box is in many ways an anachronism a remnant of computing daysof yore.It was often used to facilitate batch printing that is, unattended printing of multi-ple files back when print spooling was less widespread.You can still use Print To File ifyou want to print a document from a different computer on which Excel isn t installed.When you print to a file, Excel sends the same stream of data that would normally gostraight to your printer into a file on your hard disk.This isn t an Excel document file, but aprinter document file.Excel saves all the necessary information from your document sothat line and page breaks, spacing, and fonts (hopefully) remain the same.Unfortunately,your results can vary depending on the type of printer, the fonts you use, and the complexityof your document.For this reason, it s advisable to test printer files before relying on themfor critical work.Here s the key to making this process work: you have to use MS-DOS to send the file to yourprinter.In Windows XP, choose Start, All Programs, Accessories, Command Prompt.At thecommand prompt, typecopy lpt1: /bThis assumes that the printer file is located in the same directory where you are issuing thecommand.You can, of course, get around this assumption by specifying a full path nameinstead of just a file name
[ Pobierz całość w formacie PDF ]