How to change print area in excel 2010
![how to change print area in excel 2010 how to change print area in excel 2010](https://www.howtogeek.com/thumbcache/2/200/53b54126c6a790a8abe084f8fd390b95/wp-content/uploads/2010/02/1print.png)
◦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. 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. Cells are pushed to another page, and depending how we have organized our data, we sometimes need to change the order of the pages manually so it could be easier for the viewer.
![how to change print area in excel 2010 how to change print area in excel 2010](https://db-excel.com/wp-content/uploads/2019/01/daily-calorie-counter-spreadsheet-inside-food-log-template-printable-daily-calorie-counter-excel-parttime-jobs-1338x970.jpg)
Go to Page Layout tab and click on Size button under it. Many times, and Excel Spreadsheet doesn’t fit on one page because it is too large. 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.ĥ. You can also change the size of the page in order to get a proper printing page. However, the printed output may look different than what you see in the preview. The first two methods work well for occasional printing but, if you need to print a specific range or ranges of worksheet frequently, defining one or multiple areas to print, significantly reduce the efforts. Print Preview in Excel 2010 adjusts your workbook so it is easier to read on your monitor. 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. Excel provides three easy ways to print chosen ranges: print the selection, define the print area in the Page Setup dialog, or create the print area. 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. Before printing to PDF, open the spreadsheet, highlight all the cells you want to print then go toFile>Print Area>Set Print area. 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.