- #Unable to change print area in excel 2010 how to
- #Unable to change print area in excel 2010 download
Here we discuss how to set a Print Area in Excel along with practical examples and a downloadable excel template. This has been a guide to Print Area in Excel. If that new area is non-adjacent to the existing print area, it will create a new print area and print on a different page.While adding more area under the print area, and if those cells or area is adjacent to the existing print area, it would be merged and print.When you save the workbook, it saves the Print area as well.You can define more than one print area in the worksheet by providing different names to that area.These steps will clear all the print areas from the worksheet. Click on Clear Print Area from the list as shown in the below screenshot.
Click on Print Area under the Page setup section.Click on any cell in the worksheet in which you want to clear the print area.
How to Remove/clear the Print Area in Excel?įor clearing the print area, follow the below steps:
Choose the Add to Print Area option as shown in the below screenshot.Īnd this would add that selected range of cells in the Print Area. Click on Print Area under the Page Setup section. Select the cells that you want to add in the already set print area. To add more areas for printing, follow the below steps: Suppose in the above example we want to include the Salary field. If you have already set the print area, but after some time, you realize that you need to include more data in the report, then you need to make some changes in the print area setting. How to Make changes in the Print Area in Excel? Now when you give the print command, only the set print area will be printed. You also can change the name of the Print Area as required. This option would set the selected range of cells or area as Print Area and also gives the name of that area under Name Box. Click on the Set Print Area option as shown in the below screenshot. It will open a drop-down list of options. Click on the Print Area option under the Page Setup section, as shown in the below screenshot. Select the range of cells that you want to print or set as the print area in that worksheet. Then it resizes print area, and there is only one page to print. Step 2: Change both of Width and Height to 1 page. Step 1: Go to the Scale to Fit group under the Page Layout tab. This method is valid in Microsoft Excel 2007 later version. We have given some employee data, and we want to print the whole data, excluding the Salary of the employee.įor setting up the print area in the Excel worksheet, follow the below steps: Actually, we can resize the print area and fit to one page by changing the Scale to Fit settings. #Unable to change print area in excel 2010 download
You can download this Print Area Excel Template here – Print Area Excel Template Example #1
0 kommentar(er)
