In the Page Setup group, click Page Setup. HINT: For more information about the Page Setup dialog box Sheet tab options, refer to Sheet Tab Options. Defining the Print Area: Dialog Box Option However, you can define a specific print area from the Page Setup dialog box or the Print Area command. In the Print what section, select Entire workbook.īy default, Excel prints all data on the current worksheet. Printing the entire workbook will print all worksheets that contain data. In the Print what section, select Active sheet(s). In the top left corner of the Excel window, click the Office Button » select Print. To activate sheets that are not adjacent to the first one you selected, press while you click the tabs of all sheets you want selected. To activate sheets adjacent to the first one you selected, press while you click the tab of the last sheet you want selected.Īll sheets between the first and last tabs selected are active.Click the tab of the first sheet you want to activate.(Optional) To make more than one worksheet active,.To activate the worksheet you want printed, click the tab of that worksheet. As explained below, however, it is possible to activate specific multiple worksheets for printing. Unless you select multiple worksheets, the active worksheet is the visible worksheet (i.e., the top worksheet the worksheet whose tab is selected). Right click the printer you want as your default printer » select Set as Default Printer.Ī checkmark appears next to the new default printer.Įxcel lets you print the active sheet(s) in your workbook without having to print the rest of the workbook. The Printers and Faxes dialog box appears. In the bottom left corner of your Windows screen, click Start » select Printers and Faxes. If you want to use the same printer for all your documents, you can set a default printer. For information on adding Quick Print and other buttons to the Quick Access toolbar, refer to Customizing Toolbars: Customizing the Quick Access Toolbar. NOTE: Quick Print may not be visible on your Quick Access toolbar. WARNING: If you click Quick Print on the Quick Access toolbar, your document prints without letting you customize settings in the Print dialog box. For more information, refer to About the Page Setup Dialog Box. The Page Setup dialog box lets you modify various document properties, such as footers and headers, page alignment, and more. For more information, refer to Customizing Page Layout: Changing the Orientation. To verify how the printout will look, use Print Preview.įor wide worksheets, you may want to print the information in landscape orientation (11" x 8.5") rather than portrait orientation (8.5" x 11"). This document introduces some helpful printing options and techniques. When printing in Excel 2007, you can print all or part of the current workbook or worksheet. This article is based on legacy software. Now, when you need to set a print area, you simply choose the area on the screen and click on the Set Print Area button.(Legacy) Microsoft Excel 2007: Printing Basics The command is now listed in the box at the right side of the dialog box. In the list of Commands, scroll down until you see the Set Print Area command.Use the Choose Commands From drop-down list to choose All Commands.The Customize area of the Excel Options dialog box. At the left side of the dialog box click Customize (Excel 2007) or Quick Access Toolbar (Excel 2010 or a later version).In Excel 2010 or a later version display the File tab of the ribbon and then click Options.) (In Excel 2007 click the Office button and then click Excel Options. You may be interested in speeding things up a bit by adding a tool to the Quick Access toolbar that defines the print area. If you need to change print areas quite often, these steps may get tiresome. The normal way you do this is to select the range of cells you want in the print area, display the Page Layout tab of the ribbon, click the Print Area tool (in the Page Setup group), and then choose Set Print Area. If you have the need to define different areas of a worksheet to print, you know that you can do so by simply defining different print areas in your worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |