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. It will also be memorized for that specific workbook if you save it. Then, run the above code and make the same check. 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. In order to check that, please manually print a selection, then look at that specific setting.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.It will open a drop-down list of options.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: Next, go to the 'Page Layout' tab and click on 'Print Area' in the 'Page Setup' group. How to Print Selected Data from a Worksheet in Excel 2016 Find Easy Solution 17. This can be done by clicking and dragging over the desired cells. TEXT and String Functions in Excel (26+)Īnd this would add that selected range of cells in the Print Area. To print a selected region in Excel that contains a drop-down list, you can follow these steps: First, select the range of cells that you want to print.Lookup and Reference Functions in Excel (35+).Excel Conditional Formatting Based on Another Cell Value.SUMPRODUCT Function with Multiple Criteria.Now when you print, only those cells will show up. Compare Two Columns in Excel for Matches Then under the File menu, select Print Area > Set Print Area.Step 2: Click your mouse on the first cell that you want to include in your selection, then drag the mouse to select the rest of the cells. Step 1: Open your spreadsheet in Excel 2010. Now, whenever you print in this worksheeteven when you are using the Quick Print toolExcel limits what is printed to the specified print area. If you are looking for additional ways to customize your printed spreadsheets, then check out our guide to printing in Excel for some tips that can make it much easier. Display the Page Layout tab of the ribbon. With that knowledge in hand, you can elect to print only your selected cells. A selection in Excel is defined by the cells that are highlighted when you click your mouse on a cell and drag the mouse to select additional cells. This tutorial is going to teach you how to print a specific set of cells in Excel 2010 that are defined by what you have currently selected. Click the Print Active Sheets button, then choose Print Selection.įor additional information and pictures for each step, continue to the next section. Double-click the worksheet or go to File > Open in Excel.Step 2, Highlight the cells that you want to print.Code: Sub PrintExample1 () Range ('A1:D14') End Sub. Enter the range in the VBA code to access the PrintOut method. Now, we need to print the report from A1 to D14. Use your mouse to select the cells to print. We have created dummy data for illustration purposes, as shown in the picture below.So continue reading below to learn how to only print your selection in Excel 2010. But if you need to print different elements at different times, then a print area is not the best option. We have previously written about how to set a print area in Excel 2010, which is helpful if you always need to print a specific set of data from a spreadsheet. So when you are printing data that is meant to summarize the contents of a spreadsheet, it is helpful to omit extraneous data in an effort to simplify the print job and make it easier to read. Excel worksheets and workbooks can easily become very large, and a lot of the information that they contain might only be useful in specific situations.
0 Comments
Leave a Reply. |