Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
Set Page and Margin at Page Setup in excel
Are you still not a confident WPS Spreadsheet user and see page setup as a tricky matter? Don't worry.To help out, we've prepared this tutorial just for you.
· Page tab option at Page Setup
Go to the Page Layout tab, and click Settings > Page setup.
In this part, you can set the Orientation. The two most common types of orientation are portrait and landscape, and they are available to be set here.
Page scaling allows you to shrink or enlarge pages when you print. You can check Adjust to and enter a suitable percentage for page size.
If you check Fit to, you can choose to fit sheet,all columns or all rows on one page.
Other quick settings for printing include Printer name, Paper size and Print quality. Changing the number of the first page is also available.
After setting, you can click Print Preview to preview the effect.
· Margins tab option at Page Setup
Margins are the white space between the contents of the spreadsheet and the edge of the printed page and they can be set here.
When editing in the text box, there will be a black line in the preview page at Margins.
The table is arranged to the left by default, but we can check the Horizontally or Vertically according to our needs.
Finally, you can click OK to finish the page setup.
· To explore more about WPS Office:
Click here to see how to set the margins of the table.
The most helpful page setup explanations are free to learn in WPS Academy. There's no denying the fact that skilful use of it can make our lives easier and if you're an Excel user, you can refer to WPS Speadsheet guide to learn other skills. WPS Academy list some of the most important Microsoft Excel skills for Windows, PC, Mac, Linux, Android, and iOS devices to make your work easier.
- 1. How to set the page number position different between odd and even pages
- 2. How to set the slide size in WPS Presentation?
- 3. How to set the page number style?
- 4. Set Row 1 to Print on Every Page in WPS Spreadsheet: A Comprehensive Guide
- 5. How to set new formatting rules in Excel
- 6. Set Header/Footer at Page Setup in excel