To print a worksheet in Excel, execute the following steps. Excel displays the Page Setup dialog box.
#How to change print area in excel 2010 how to#
To do this, click the appropriate paper tray in the First page list and in the Other pages list.Ħ.If you want to change the page orientation or its page margins, click the Finishing tab.ĩ.Repeat steps 2 to 8 for each sheet of your workbook for which you want to specify settings. This chapter teaches you how to print a worksheet and how to change some important print settings in Excel. An alternate (and more difficult) way to set the print area is to follow these steps: Select the worksheet you want to print. ◦If the printer cannot automatically select the correct paper tray to use, you may have to select the paper tray that contains the paper size that you selected in step 4. Print Active Sheets serves as the default in the first of. Watch how the print area for the table below (depicted by the dashed line around the data), dynamically updates as new rows are added to the bottom. Often an Excel model needs a dynamic print area, as data that we wish to print may change over time. Click Options button and in Printing Shortcuts tab, in the Paper source area, perform one of the following steps: ◦If the printer can automatically select the correct paper tray to use, click Default tray in the First page list, and then click Defaultĭefault tray is the default setting in both of these lists. The Settings area features a number of important fields, its options presented in drop-down menus. The following Excel Factor entry was sent in by Daniel Ferry, founder of Excel enthusiast blog, Excel Hero.
In the Page Setup group, click Page Setup to open the Page Setup dialog box.Ĥ.Under Paper size, click the paper size that you want.ĥ. In this article, you will learn how to remove dashed print area lines in Excel. To specify these settings, follow these steps:ġ.Start Excel, and then open the workbook you want to change.Ģ.In Microsoft Office Excel 2010, click the sheet that you want to print, and then click the Page Layout tab. Instead, specify these settings in your workbook.
#How to change print area in excel 2010 driver#
To work around this issue, do not specify the paper size, page orientation, or page margins in the printer driver properties. This issue occurs because the Page Setup settings that you specify in your file override the settings that you specify in the printer driver properties.