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.Print Select Areas of Excel Spreadsheets. Share The Knowledge.To define the print area, you need to set and fix the page layout boundaries that will separate all areas. As you can see we could set the size of the excel sheet to match with our printing size and page requirement. To change the size of your excel sheet to A4 and A3 got to Size Under the Page Layout tab. We could set the size of excel to A4 and A3 in a couple of simple steps.

Step 2: Click the Kutools > Show / Hide > Set Scroll Area. But this method will select all print areas in current worksheet. You can manually remove the print area by dragging the border between the gray and white fields.Note: If you canвЂ™t find out the print area quickly, you can press F5 key to open the Go To dialog box, select the print area name and click the OK button as below screen shot shown. If you are in a Page Break Preview view, and all data is located in the gray area, then youвЂ™ll receive a blank document when printing. If the table goes beyond the white area, then everything in the gray area will not be printed. You may need to set your printer to display this feature when you set up the printer.About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features Press Copyright Contact us Creators.

How to add borders (page breaks)? Click on the cell that is in the place where there should be a document break and choose the В«Insert Page BreakВ» option.How to add only a vertical page break? Right-click on the column where the border will be laid, select the same option: В«Insert Page BreakВ». Worksheets('Sheet1').Activate ActiveSheet.PageSetup.PrintArea ActiveCell.CurrentRegion.AddressDo define the print area, you must set and adjust the boundaries. Note that you use the Address property to return an A1-style address. This example sets the print area to the current region on Sheet1.

Enter its name and it will be in the list of custom views.New versions of Excel (starting with Excel 2007) have effective tools for preparing documents for printing. When you select the В«Custom ViewsВ» tool, the Custom View manager is loaded.To save this setting, click the В«AddВ» button. How to save print area settings?All the settings of the areas can be saved in templates, the so-called В«Custom ViewsВ». Use it to start all over again. It allows you to delete all document breaks and adjust the default settings. There is the В«Reset Print AreaВ» option in the context menu.

Set Up Print Area In Excel 2016 For Mac