6/21/2023 0 Comments Excel set print area 2010![]() Beside the Name Manager (which as JJ says is where you can check the defined names within the workbook, to prevent conflicts), click Define NameĦ. ![]() In the Ribbon, select the Page Layout tabĤ. ![]() In Excel, select the worksheet area you want to display (for me, this was the cells containing/around two PivotCharts and two slicers)Ģ. If the table goes beyond the white area, then everything in the gray area will not be printed. ![]() To do this, click on the blue dotted line in the Page Break Preview view, and move it to the necessary position, holding down the left mouse button. If you are looking to print labels from within Excel, check out our guide specifically designed to help you out with the task. How to change a print area in Excel To define the print area, you need to set and fix the page layout boundaries that will separate all areas. Note for anyone else using JJ's elegant solution who may not be as familiar with print areas in Excel:ġ. These instructions apply to Excel 2019, 2016, 2013, 2010, and Excel for Microsoft 365. The slicers are visible and work, and overall it is a much cleaner look to a Web part to NOT to be so Excel-like! Moving the supporting PivotTables to way down on the page). JJ78 you are my hero - the print-area idea works wonderfully! I'd been looking for a way to just display my PivotCharts and slicers in a "clean" view (without the Excel row and column headers, or the unappealing necessity of hiding gridlines and
0 Comments
Leave a Reply. |