How to resize Excel print area to fit A4 paper format

Many friends want to adjust the print area size after editing the table, but they don’t know how to adjust the print area size in excel. They are very distressed, so they came to this site to ask the editor, and the editor collected relevant information. , I finally found out how to adjust excel printing to A4 paper. The specific content is in the article below. If you need it, please come to this site to have a look.

How to adjust the size of excel printing area?

The specific steps are as follows:

1. Double-click to open an Excel table;

2. Select the content that needs to be set as the print area, click the "Print Area" button in "Page Layout" and click "Set Print Area" in the sub-option;

3. If you need to cancel later, you can click "Cancel Print Area" under "Print Area";

4. After setting the print area, press the Ctrl P key on the keyboard to view the print preview. Click the drop-down arrow at "Settings" to select "Print Active Worksheet", and the print area we set will be printed. Click "Page Setup" below. " button to set the desired printing parameters;

5. You can also select the content that needs to be printed without setting the printing area, and press the Ctrl P key Click the drop-down arrow at "Settings" to select "Print Selected Area", and then you can also set the desired printing parameters. After the settings are completed, click the "Print" button in the upper left corner to print.

The above is the detailed content of How to resize Excel print area to fit A4 paper format. For more information, please follow other related articles on the PHP Chinese website!