Formulas tab group’s shortcuts Microsoft Excel 2016

Formulas tab group’s shortcuts Microsoft Excel

Formulas tab group's shortcuts Microsoft Excel

Formulas tab group’s shortcuts MS Excel 2016

See Previous Post: Page Layout tab groups buttons shortcuts Microsoft Excel 2016

A list of available Formulas tab group’s shortcuts is mentioned below. And, these shortcuts are part of the Formulas tab ribbon group’s in the Microsoft Excel 2016. The Shortcuts keys are a combination the Alt key, the Ctrl key and the Shift key etc. In addition, also are the Function keys, the Numeric keys and the Alphabets keys.

So, the Formulas tab group’s shortcuts applies the Themes, the Printing, the Page Setup etc. Especially, using the “Alt” key most of the shortcuts gets executed. Also, to do button actions, other keys shall be pressed after pressing the “Ctrl” key or Alt key initially.

Formulas tab group’s shortcuts MS Excel 2016

Alt Key shortcuts Description
Alt+M+F or Shift+F3  Insert Function button
Alt+M+U or Alt+=  Autosum button
Alt+M+R  Recently Used functions tool
Alt+M+I  Financial functions button
Alt+M+L  Logical functions
Alt+M+T  Text functions button
Alt+M+E  Date & Time functions
Alt+M+O  Lookup & Reference functions
Alt+M+G  Math & Trig button
Alt+M+Q  More Functions tool
Alt+M+N or Ctrl+F3  Name Manager button
Alt+M+M  Define Name tool
Alt+M+S  Use in Formula button
Alt+M+C or Ctrl+Shift+F3  Create from Selection
Alt+M+P  Trace Precedents button
Alt+M+D  Trace Dependents tool
Alt+M+A  Remove Arrows
Alt+M+H or Ctrl+`  Show Formulas
Alt+M+K  Error Checking button
Alt+M+V  Evaluate Formula tool
Alt+M+W  Watch Window button
Alt+M+X  Calculations Options
Alt+M+B or F9  Calculate Now button
Alt+M+J or Shift+F9  Calculate Sheet tool

The button & tool words used in the table above in Description column reflect same meaning. So, the three keys is used generally for shortcuts with the “Alt” key combination. Also, a two key combination for shortcuts with the “Ctrl” key in Excel is used.

See Next Post: Data tab groups buttons tools shortcuts Microsoft Excel 2016


About the Author

After working on Microsoft Excel for so many years, now its time to share & spread my Experience and Knowledge, which I have gained on Excel with the world. Myself, Piyush Kr. Pandey is an Excel enthusiast and founder of (Learn Microsoft Excel), a website since 2016. Kindly, Subscribe our blog email newsletters for daily vital and essential informative posts on Microsoft Excel. Email:

Post a Reply

Your email address will not be published. Required fields are marked *