'%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)
Fix Custom Page Size Missing in Excel Page Setup
Question details
The user is unable to find or select a custom page size, such as 4 by 6 inches, when attempting to format an Excel worksheet for printing.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Setting up a worksheet for printing on non-standard paper dimensions.
- Observed behavior
- The custom page-size option is completely unavailable or missing in the Excel Page Setup menu.
Verify whether you are using Excel for the Web or the desktop version, and ensure your printer driver is fully up to date, as available page sizes depend on both the application capabilities and the printer hardware.
Use the Desktop Application for Advanced Printing Options
Since Excel for the Web does not support custom page sizes, switching to the desktop app allows you to access advanced printer properties and define specific dimensions.
Excel for the Web is a streamlined application and natively lacks support for defining custom page sizes in its print settings. To print non-standard dimensions, you must transition to a desktop spreadsheet application that can communicate advanced settings to your printer driver.
Open your spreadsheet file in the desktop version of Microsoft Excel.
Navigate to the 'Page Layout' tab located on the top ribbon.
Click on 'Size' and select 'More Paper Sizes' at the bottom of the dropdown menu to open the Page Setup dialog box.
Click the 'Options' button to open your specific printer properties, where you can define your custom dimensions (e.g., 4x6 inches) if supported by your printer hardware.
Submit Feature Feedback in Excel for the Web
If you are strictly limited to using the web version, you can request the addition of custom page size support directly from Microsoft's development team.
Easily Set Custom Page Sizes in WPS Spreadsheet
WPS Office provides a highly capable, free desktop spreadsheet tool that makes defining custom page sizes straightforward. Bypass web-based limitations and easily print your sheets on non-standard paper dimensions while maintaining perfect file formatting.
- 1. Open File in WPS: Launch WPS Spreadsheet and open your existing spreadsheet document.
- 2. Go to Page Layout: Click on the 'Page Layout' tab on the top menu ribbon.
- 3. Open Size Options: Click the 'Size' button and select 'More Paper Sizes' from the dropdown list.
- 4. Enter Dimensions: In the Page Setup dialog, scroll the Paper Size list to select 'Custom' and manually input your desired width and height.
- 5. Apply and Print: Click 'OK' to save your new dimensions and proceed to print your document seamlessly.
Frequently Asked Questions
Why can't I see 'More Paper Sizes' in Excel for the Web?
Excel for the Web is a lightweight, browser-based version of the application and lacks many advanced formatting tools, including the ability to define custom paper dimensions. You must use a desktop application to interface directly with your printer's custom settings.
Does my custom page size depend on the printer I use?
Yes, the paper sizes available in the Page Setup menu are largely determined by the printer driver currently selected. If your physical printer does not support a specific dimension, the driver may prevent the software from offering it as an option.
Can I save a custom page size setting permanently in my spreadsheet?
While you cannot save a custom page size as a global default for all new Excel files, the page setup settings are saved within the specific workbook you are editing. The next time you open that specific file on a supported desktop app, the custom print dimensions will be retained.
