Quick Reference Card. The Excel 2016 Screen. Keyboard Shortcuts. Keys to move the mouse pointer to the last cell of the range. • To Select an. Save time by using many of these common keyboard shortcuts in Microsoft Excel 2016 (standard US keyboard for the PC).
Microsoft Excel Keyboard Shortcuts The keyboard shortcuts are tested and works in most versions of the Microsoft Excel in Windows based computers. The shortcuts are categorized as below and use the search box to filter the results in the below table. Menu – related to menu items and ribbon icons.
Dialog box – opens up the dialog box. Function – insert a function.
Data processing – used for spreadsheet data processing in workbooks like copy and paste. Formatting – text formatting like bold, double underline, strikethrough, etc. Navigation – move within and outside the workbook. Workbook – applicable at window level like resizing, minimizing, etc. General – general purpose shortcuts. Shortcut Description Category Alt Activate access keys (then press further keys to go to the required menu item) Menu Alt + = Apply automatic summation when used down the cells with numbers. Apply sum function when used on empty cell.