How to adjust EXCEL printing beyond the page range

How to adjust EXCEL printing beyond the page range: first open the Microsoft icon button and select [Print-Print Preview]; then click the [Page Setup] button and select the Page tab; then select the adjustment button. Set all parameters to 1; finally click [OK].

How to adjust EXCEL printing beyond the page range:

1. Click the pattern button on the left side of the menu bar (Would it be better to call it Microsoft's icon button?) Then select "Print" in the pop-up drop-down box, select "Print Preview" in the other drop-down box that pops up on the right, enter the print preview interface, and continue with the next step.

2. Obviously, our interface has two fewer columns than the table we created before. This is due to too many columns in the table. So the next step will be solve this problem. Please read on.

#3. Place the mouse on the button in the blue frame, which is the legendary "Page Setup" button. The software will pop up a small prompt box, that is The content to be displayed next, where you can make the corresponding settings.

4. In the current picture we see a new dialog box with "Page", "Margins", "Header/Footer", There are four tabs in "Worksheet", here select the "Page" tab. Pay attention to the "Scale" part. The software selects "Scale Ratio" by default, and it is 100%. This will cause our table to exceed the printing range. We can change this ratio, but if it is changed directly, it may cause long The width is uncoordinated, so we don't do that here. The next step will be to set it up accordingly.

5. Check "Adjust to", and select "1" page width and 1 page height respectively for the other two parameters, so that we can reduce the entire table to It is on a piece of paper, and it does not affect the coordination of length and width. It is much more pleasing to the eye than adjusting it directly by yourself. After checking, click "OK". The next step shows the results.

#6. You can see that the two columns that were missing before (one is "Remarks" and the other is an empty column) are back! Just print it!

Related learning recommendations: excel basic tutorial

The above is the detailed content of How to adjust EXCEL printing beyond the page range. For more information, please follow other related articles on the PHP Chinese website!