'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Show More Paper Sizes in Excel Page Setup
Question details
The user needs to find and select additional paper size options that are missing from the default Page Size menu.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Setting up a worksheet for printing on a specific paper format that is not initially visible in the dropdown menu.
- Observed behavior
- Excel's Page Size menu displays fewer paper options than expected, making it difficult to select the required paper format for printing.
Verify that your computer is connected to a printer and the correct printer drivers are installed, as Excel pulls its available paper sizes directly from the capabilities of your active printer.
Access Additional Paper Sizes via Page Setup Dialog
Use this method to open the full Page Setup dialog box, which contains extended paper size options beyond the quick-access menu.
In newer versions of Excel, the quick-access Page Size menu may only show the most frequently used paper formats. To see all available formats supported by your printer, you need to open the advanced Page Setup dialog box.
Open your Excel workbook and click on the 'Page Layout' tab located in the top ribbon.
In the 'Page Setup' group, click on the 'Size' button to reveal the default list of paper sizes.
Scroll to the bottom of the dropdown list and click on 'More Paper Sizes...'.
In the Page Setup dialog box, click the 'Paper size' dropdown menu and select the required paper format, then click 'OK' to apply.
Change the Default Printer to Reveal More Sizes
Switch your default printer to a virtual printer like 'Microsoft Print to PDF' to access standard paper sizes that your physical printer might not support.
Easily Manage Page Sizes and Printing with WPS Spreadsheet
WPS Office provides an intuitive and highly compatible spreadsheet tool that makes page setup a breeze. If you are struggling with missing paper sizes or printing configurations, WPS Spreadsheet seamlessly interacts with your system's printers to ensure all supported page sizes are instantly available.
- 1. Open Your Spreadsheet: Launch WPS Office and open your workbook using WPS Spreadsheet.
- 2. Go to Page Layout: Click on the 'Page Layout' tab on the top navigation ribbon.
- 3. Access Paper Sizes: Click the 'Size' icon. A comprehensive list of standard paper sizes supported by your printer will appear.
- 4. Access Advanced Settings: If you need a specific dimension, click 'More Paper Sizes' to easily configure a custom page setup in the dialog box.
Frequently Asked Questions
Why are custom paper sizes missing in my Excel Page Setup?
Excel relies on the active printer driver to populate the paper size list. If your currently selected printer does not natively support a specific dimension (like Tabloid or A3), Excel will remove that option from the Page Setup menu.
How do I create a custom paper size in Windows for Excel?
You can create custom paper sizes through Windows Print Server Properties. Go to Settings > Printers & scanners > Print server properties. Check the 'Create a new form' box, enter your custom dimensions, save it, and it will become available in Excel.
Can I force Excel to show A3 paper size if my printer only supports A4?
You cannot force it while the A4-only printer is selected. However, you can temporarily switch your printer in Excel (via File > Print) to 'Microsoft Print to PDF', which supports A3. After formatting the document in A3, you can export it as a PDF.
Does updating the printer driver fix missing paper size issues?
Yes. Outdated or generic printer drivers often lack the full list of paper sizes the physical printer actually supports. Downloading and installing the latest specific driver from the manufacturer's website usually restores the missing options in Excel.
