tritaya.blogg.se - Excel set print area

#EXCEL SET PRINT AREA MANUAL#
#EXCEL SET PRINT AREA WINDOWS#

(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.

#EXCEL SET PRINT AREA WINDOWS#

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. The printed data will not exceed your specifications, but the data will not expand to fill any empty space.(Legacy) Microsoft Excel 2007: Printing Basics When you change the values for Fit to, the data will shrink to fit the specified number of pages.

#EXCEL SET PRINT AREA MANUAL#

If you have set any manual page breaks, these will be ignored when you use the ‘fit to’ option To view how the data will look on the page, view a print preview first Now all you need to do is print as normal. On the Page Layout tab > Page Setup group > Orientation > choose either ‘ Portrait’ or ‘ Landscape’ In order to use this setting, the height and width options must be set to automatic.ĭepending upon the size and shape of your data, it may be better to change the orientation of the page to print your spreadsheet landscape rather than portrait. Scale the dataĪlternatively, in the same group settings here you can set the ‘scale’ percentage, which is set to 100% by default, to stretch or shrink your data to a percentage of it’s actual size. Note: you will see the the ‘scale’ option is greyed out once you have changed settings for the width and height – the percentage will be altered automatically for best fit to your requirements. In this example, we want the data to fit one A4 page, so we will select 1 page wide and 1 page high as in the example below. By default these are set to ‘automatic’ but if you click the dropdown arrows here you are able to choose how many pages high or wide you want your data to be. There are two dropdown boxes – one for width and one for height. On the Page Layout tab > Scale to fit group you will see a number of options Define the number of pages to print onįirst, open the worksheet the you want to print Now and again you might want to print out the contents of a spreadsheet worksheet, perhaps for an attendance list or address database for an event.Įxcel spreadsheets don’t really have default settings to have them print nicely on a standard A4 page, as you might find in Word, and you will have probably experienced the issue of printing your spreadsheet to find the rows split over multiple pages – often wasting paper and making the information hard to read.īy scaling a worksheet in page setup before you print, you can control its width and number of pages, there are two ways of doing this: 1.