'%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 Fix Missing Custom Paper Size in Excel for HP Printers
Question details
The user needs to add a custom paper size in Excel but finds the option missing after installing a new HP printer.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to print a spreadsheet with custom dimensions using an HP MFP 4301dw printer.
- Observed behavior
- The custom paper-size option is completely missing from the Page Setup and print menus in Excel, despite the option being available in Word.
Ensure your HP printer is turned on, connected to your network or PC, and set as the default printer. You will also need administrator privileges to adjust printer driver properties or install new drivers.
Access Custom Paper Size via Excel Page Layout
Use Excel's built-in Page Setup dialog box to manually select or enter custom paper dimensions.
Excel relies directly on the active printer's driver capabilities to display paper sizes. Even if the option is missing from the quick dropdown menu, you might still find it buried in the advanced Page Setup dialog.
Open your workbook in Excel, navigate to the Page Layout tab on the top ribbon, and click on Size.
Scroll to the bottom of the Size dropdown list and click on More Paper Sizes to open the detailed Page Setup window.
In the Page tab of the dialog box, look for the Paper size dropdown. If the HP driver supports it, select the Custom option and enter your desired width and height, then click OK.
Create a Custom Form in Windows Print Server Properties
Define a custom paper size form globally in Windows so that Excel is forced to recognize it.
Update or Reinstall the HP Printer Driver
Install the latest full-feature HP driver to resolve missing capability issues in spreadsheet software.
Set Custom Paper Sizes Easily with WPS Spreadsheet
WPS Spreadsheet offers an intuitive interface for page layout and printing, making it incredibly simple to set custom paper sizes without constantly fighting printer driver limitations.
- 1. Open the Spreadsheet: Launch WPS Office and open your spreadsheet file in the WPS Spreadsheet application.
- 2. Go to Page Layout: Click on the Page Layout tab located in the top menu ribbon.
- 3. Open Page Settings: Click on the Settings icon or Page Setup dialog launcher to open advanced page formatting options.
- 4. Set Custom Dimensions: In the Paper Size dropdown, select Custom and input your specific width and height preferences, then click OK.
Frequently Asked Questions
Why does my custom paper size show in Word but not Excel?
Excel calculates print areas, margins, and cell scaling dynamically based on the specific capabilities reported by your default printer driver. Word handles pagination internally using a different text rendering engine. If the HP driver does not explicitly communicate custom form support in a way Excel expects, the option will be hidden.
How do I access native HP printer properties directly from Excel?
Go to File > Print within Excel. Ensure your HP printer is selected from the Printer dropdown, then click the Printer Properties link directly underneath the printer name. This opens the software provided by HP where you can sometimes define custom dimensions.
Does saving as a PDF bypass the missing paper size issue in Excel?
Yes. If your physical printer driver is missing the option, you can change your active printer in Excel to 'Microsoft Print to PDF'. This virtual printer often allows broader paper size customization. Once you generate the PDF with the correct dimensions, you can print the resulting PDF file to your HP printer.
