Office Settings & Configuration

How to Fix Excel 2016 Ctrl+Alt Zoom Shortcut Not Working

Huma Ashraf Ch Oct 23, 2026 869 views

Question details

The user needs a functional workaround or fix to adjust worksheet zoom levels because the standard Ctrl+Alt zoom shortcut is unresponsive.

How to Fix Excel 2016 Ctrl+Alt Zoom Shortcut Not Working

Product: Microsoft Excel 2016
Device & OS: not provided
Scenario: Attempting to quickly adjust the visual scale of a spreadsheet using the Ctrl+Alt keyboard shortcut.
Observed behavior: The Ctrl+Alt zoom shortcut fails to trigger the zoom function, preventing the user from changing the worksheet's zoom level via the keyboard.

Before you start

Verify that your computer's mouse wheel is functioning correctly in other applications, as the primary and most efficient workaround relies on a working scroll wheel.

Solution 1Recommended

Use the Ctrl + Mouse Wheel Shortcut

Since the specific Ctrl+Alt shortcut is unresponsive in certain Excel 2016 builds, the most reliable native alternative is using the Ctrl key combined with your mouse wheel.

This is the officially supported and recommended Microsoft Excel method for zooming in and out seamlessly without relying strictly on keyboard-only shortcuts.

Open your worksheet

Launch Excel 2016 and open the spreadsheet document you want to view.

Hold the Ctrl key

Press and continuously hold down the 'Ctrl' key on your keyboard.

Scroll to zoom

While holding the Ctrl key, scroll your mouse wheel up to zoom in (enlarge the view) or scroll the mouse wheel down to zoom out (shrink the view).

Efficiency Tip: This method allows for very granular control over your zoom level and is typically much faster than navigating through the ribbon menus.

Solution 2

Use the Zoom Slider on the Status Bar

If you do not have a mouse with a scroll wheel, you can easily adjust the zoom level using the built-in UI slider located on the Excel Status Bar.

Free Microsoft Office alternative

Experience Reliable Shortcuts and Seamless Zooming with WPS Office

Frustrated by unresponsiveness and broken shortcuts in older software like Excel 2016? Switch to WPS Office. It is a free, lightweight, and highly compatible Office suite that offers a smooth user experience, familiar UI, and flawless performance for all your spreadsheet tasks without unexpected shortcut failures.

1. Download and Install: Download WPS Office for free from the official website and follow the quick installation prompts.
2. Open your Excel File: Launch WPS Spreadsheet and open your existing .xlsx or .xls files seamlessly.
3. Zoom effortlessly: Hold down Ctrl and use your mouse wheel, or use the responsive status bar slider to adjust your view without any bugs.

100% compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Free to use, lightweight, and features rapid startup timesReliable keyboard shortcuts and highly responsive zoom controlsFamiliar tabbed interface requires zero learning curve to migrate

microsoft office alternative - wps office

Frequently Asked Questions

Why did the Ctrl+Alt zoom shortcut stop working in Excel 2016?

In certain updates or specific builds of Excel 2016, changes to keyboard shortcut mappings or conflicts with newer Windows system shortcuts can cause the Ctrl+Alt zoom function to become unresponsive or get overridden.

Is there a way to restore the exact Ctrl+Alt shortcut in Excel?

Excel does not provide a native menu to easily remap core zoom shortcuts. If a standard Office Repair does not fix the issue, utilizing the Ctrl + Mouse Wheel method is the officially supported and most reliable workaround.

Can I set a default zoom level for all my new Excel workbooks?

Yes. You can create a blank workbook, set your preferred zoom level using the mouse wheel or slider, and save it as an Excel Template named 'Book.xltx' in your system's XLSTART folder. All new workbooks will subsequently open with that chosen zoom level.

Office App Problems