Maximize or restore the currently selected workbook windowĥ. SHIFT + Function Keys Shortcut Shortcut Keyĭisplays formula box to Paste function into the formulaĦ. ALT + Function Keys Shortcut Shortcut Key Minimize the currently selected workbook window Switch between relative and absolute refsĤ. CTRL + Function Keys Shortcut Shortcut Keyĭisplay the Print Preview area on the Print tab of Backstage ViewĬlose the currently selected workbook windowĪlternate between the currently active workbook window and the next workbook windowĪpply Move command on the active workbook windowĪpply Resize command on the active workbook window.It will Unhide the rows in the current selection It Selects the current region (associated by blank rows and columns)

It Enters the value from the cell directly above into the active cell It Unhides the columns in the current selection The various shortcuts for the Windows keyboard are given below: 1.

When we press ALT + H, Microsoft Excel displays the keyboard shortcuts for every function in the toolbar except the menus as shown below The Excel ribbon displays the below shortcuts for the menus in the toolbar. To find the keyboard shortcuts press the ALT key on the keyboard. The shortcut keys for the Windows keyboard and Mac keyboard are different.In Excel, we can use the keyboard shortcuts by using ALT, CTRL, SHIFT, Function key, and Windows key.Keyboard shortcuts are essential alternatives to the mouse.The ALT key on the keyboard is the master key, which is present on both sides of the Spacebar key.They increase efficiency and speed which ultimately leads to an increase in productivity. These shortcuts help save time while working with large data files in business accounting, equity research, or while building financial models. Tip: To make content BOLD we can also press the B icon in the Excel ribbon (highlighted in yellow in the above image) TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (35+).Excel Conditional Formatting Based on Another Cell Value.SUMPRODUCT Function with Multiple Criteria.Compare Two Columns in Excel for Matches.

Basic ms excel shortcut keys