How to Stop Automatic Zoom When Editing an Excel Cell and Increase Worksheet Tab Font Size in WPS Office
Question details
The user wants to stop Microsoft Excel from automatically zooming while editing cell contents and to increase the worksheet tab font size, including tabs that contain Thai characters.
- Product
- Microsoft Excel / WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- The user is editing cell contents and the worksheet zooms automatically; they also need larger worksheet tab text for readability, including mixed Thai and English tab names.
- Observed behavior
- Excel changes the zoom level automatically during cell editing, and worksheet tab text size follows the operating system display settings rather than an Excel-specific font control.
Check your Microsoft Excel or WPS Office version and your current Windows or macOS display scaling and accessibility settings, because worksheet tab text size is controlled by the operating system rather than by the spreadsheet application.
Check Excel editing options and disable mouse-wheel zoom in WPS Office
Use this first when the view zooms unexpectedly while editing, because it turns off the most common automatic zoom trigger in Excel and confirms which editing options are available.
Excel does not provide a single global setting to disable every type of automatic zoom during cell editing. The mouse-wheel zoom option is the main application-level control, while other zoom changes are usually related to display scaling or accessibility settings.
In Microsoft Excel, click File, then select Options. In WPS Spreadsheet, open the Menu and choose Options or Preferences, depending on your version.
Select the Advanced tab, then locate the Editing options section.
Clear the check box for 'Zoom on roll with IntelliMouse' or the equivalent wheel-zoom setting.
Click OK to save the setting, then edit a cell to check whether the automatic zoom behavior has stopped.
Adjust Windows or macOS display scaling and text size to enlarge worksheet tab text
Use this when worksheet tab names, especially Thai characters, are too small to read, because Excel does not offer an independent tab font size setting.
Use tab colors and the manual zoom slider as a reading workaround
Use this to improve tab visibility and control the editing zoom manually when the operating system display settings cannot be changed.
Switch to WPS Spreadsheet for Familiar Excel Editing and Better-Suited Display Control
WPS Office is a free, lightweight Microsoft Office alternative that opens and saves Excel workbooks with a familiar spreadsheet interface, straightforward zoom controls, and compatibility with your existing .xlsx and .xls files.
- 1. Download WPS Office: Go to the official WPS website and download WPS Office for Windows, macOS, or your preferred platform.
- 2. Open your Excel workbook: Launch WPS Spreadsheet and open the existing .xlsx or .xls workbook that contains the worksheet tabs you want to adjust.
- 3. Set the zoom and display options: Use the zoom slider or View > Zoom to set a comfortable cell-editing zoom, then adjust the operating system display scaling if you need larger worksheet tab text.
Frequently Asked Questions
Does Excel have a setting to stop automatic zooming while editing a cell?
No single setting disables every type of automatic zoom during cell editing. In Excel, click File > Options > Advanced, and under Editing options clear 'Zoom on roll with IntelliMouse' to stop mouse-wheel zoom, but other zoom changes may still come from Windows or macOS display and accessibility settings.
How can I increase the font size of worksheet tabs in Excel?
Excel does not have an independent tab font size control. On Windows, open Settings > System > Display and increase scaling, or open Settings > Accessibility > Text size and drag the slider. On macOS, use System Settings > Displays and Accessibility > Display.
Can I use VBA to stop automatic zooming or enlarge worksheet tab text?
VBA is not a reliable way to control these interface behaviors. Worksheet tab text size follows the operating system display settings, and automatic zoom during cell editing is not exposed as a standard Excel VBA property.
Will changing worksheet tab colors help make tab text larger?
Tab colors change the background color only, not the text size. You can right-click a worksheet tab and choose Tab Color to improve contrast, but you still need display scaling to make the text itself larger.
Is WPS Spreadsheet a free alternative for editing Excel workbooks?
Yes. WPS Office opens and saves Microsoft Excel .xlsx and .xls files, provides a familiar spreadsheet interface, and lets you use zoom controls and operating system display scaling to adjust the view and worksheet tab readability.
