'%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)
Why Did the Excel Automatic Except Data Tables Shortcut Change?
Question details
The user is inquiring about the reason behind the keyboard shortcut change for Excel's Automatic Except Data Tables calculation option.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Using ribbon keyboard shortcuts to adjust workbook calculation options.
- Observed behavior
- The shortcut changed from Alt+M+X+E to Alt+M+X+P, and the feature was renamed to Partial.
Ensure your Microsoft Excel application is fully updated to verify if the new 'Partial' calculation option name applies to your current version.
Adapting to the New Partial Calculation Shortcut
Understand the Microsoft update and use the new Alt+M+X+P shortcut to access the calculation option.
Microsoft updated the Excel ribbon by renaming the 'Automatic Except Data Tables' option to 'Partial' to better reflect its expanded functionality. Because ribbon accelerator shortcuts are tied to the spelling of the menu items, the shortcut key was updated from E to P.
Standard Excel settings do not provide a native way to revert this specific built-in shortcut back to its older version.
Press Alt + M on your keyboard to navigate directly to the Formulas tab on the Excel ribbon.
Press X to open the Calculation Options drop-down menu.
Press P to select the new 'Partial' calculation mode, which replaces the former Automatic Except Data Tables option.
Try WPS Office for a Stable and Familiar Spreadsheet Experience
If frequent interface updates and changing shortcut keys in Microsoft Office are disrupting your workflow, WPS Office offers a highly compatible and lightweight alternative. Its classic interface ensures your existing spreadsheet habits and muscle memory remain intact.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install the Application: Run the setup file and follow the straightforward on-screen instructions to install the suite.
- 3. Launch WPS Spreadsheet: Open WPS Spreadsheet to enjoy a highly stable environment for all your data management and calculation needs.
Frequently Asked Questions
Can I revert the shortcut back to Alt+M+X+E in Excel?
No, Microsoft Excel does not allow users to natively customize or revert built-in Ribbon accelerator keys. The shortcut is permanently tied to the new 'Partial' naming convention.
Does the new Partial option work differently than Automatic Except Data Tables?
The core function remains the same—it prevents large data tables from calculating automatically to save processing power. The rename simply allows Microsoft to encompass broader functionality under this umbrella in future updates.
Are my other calculation keyboard shortcuts affected?
No, standard calculation shortcut keys like F9 (Calculate Now) and Shift+F9 (Calculate Active Sheet) are independent of the ribbon and remain completely unchanged.
