How to Fix Excel Error: Number Must Be Between 10 and 400
Question details
The user needs to fix an error prompting that a number must be between 10 and 400 when setting up print options.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Configuring Page Layout settings or Print Titles before printing a spreadsheet.
- Observed behavior
- Excel displays a warning message stating 'The number must be between 10 and 400' and prevents the user from saving their page layout or print title configurations.
Ensure you are not actively editing a cell formula and that no worksheets are grouped together before attempting to change your page layout settings.
Check and Clear Data Validation Rules
Remove corrupted or conflicting data validation rules that erroneously trigger when accessing the Page Setup menu.
In many cases, this error is a known glitch where Excel applies a hidden data validation restriction to the Page Setup dialog. Clearing existing data validation rules from the active worksheet often resolves the issue instantly.
Click the triangle icon in the top-left corner of your spreadsheet (between column header A and row header 1), or press Ctrl + A to highlight the entire worksheet.
Navigate to the 'Data' tab on the top ribbon and click on 'Data Validation' within the Data Tools group.
When the Data Validation dialog box appears, click the 'Clear All' button located in the bottom-left corner.
Click 'OK' to close the dialog box, then try configuring your Print Titles again.

Correct the Page Scaling Percentage
Verify that your print scaling settings are strictly within Excel's physical limits of 10% to 400%.
Move Data to a New Workbook
Transfer your spreadsheet data to a fresh file to leave behind corrupted layout configurations.
Set Print Titles Without Errors in WPS Office
If Excel continues to throw validation errors during basic layout configurations, open your workbook in WPS Office. It provides a stable, highly compatible spreadsheet editor where you can configure page layouts effortlessly.
- 1. Open Your Workbook: Download and launch WPS Office, then open your existing .xlsx file.
- 2. Navigate to Page Layout: Click the 'Page Layout' tab on the top menu ribbon.
- 3. Set Up Print Titles: Click 'Print Titles', select the rows or columns you wish to repeat, and click OK to save without error prompts.

Frequently Asked Questions
Why does the '10 and 400' error appear when I haven't changed any numbers?
This is a known glitch in Microsoft Excel where hidden data validation rules on the worksheet conflict with the Page Setup menu. Excel incorrectly interprets the page scaling setting (which must legally be between 10% and 400%) as invalid due to these conflicting rules.
What does the 10 to 400 range refer to in Excel?
It refers to the Page Scaling percentage in your print settings. Excel allows you to shrink your printed document down to 10% of its normal size, or scale it up to a maximum of 400%.
How can I find which specific cells have data validation?
On the Home tab, click on 'Find & Select' (or 'Find and Replace' depending on your version), then choose 'Go To Special'. Select 'Data Validation' and click 'OK'. Excel will highlight all cells in the current worksheet that have data validation rules applied.
Can this error happen on Excel for iPad or Mac?
Yes. While the user interface differs, the underlying workbook structure is the same. If a file has corrupted validation rules or invalid scaling settings, the error can trigger across the Windows, Mac, and iPad versions of Excel.




