Scaling print in excel for mac5/26/2023 ![]() You can manually remove the print area by dragging the border between the gray and white fields.ĭo define the print area, you must set and adjust the boundaries. 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. 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. To define the print area, you need to set and fix the page layout boundaries that will separate all areas. The second option is to click on the third switch in the right side of the status bar of the Excel window. To enter the mode for managing borders and areas, you need to go to the «VIEW» tab and in the Workbooks View section, select the «Page Break Preview» tool. Let’s consider how to set, change, increase, reduce, or delete the print area. The situation is completely under your control. You see all the document with the optimal scale, like miniatures of medium size. In addition, this mode provides the most convenient preview before printing. It also gives you a possibility to customize and optimize tables to the size and orientation of paper sheets. ![]() Page Break Preview view allows you to fix the boundaries of the printable area of the document on all pages simultaneously. Adjusting a print area in page break preview view Excel
0 Comments
Leave a Reply. |