![microsoft excel keyboard shortcut microsoft excel keyboard shortcut](https://i.ytimg.com/vi/KW-RMCSyq2Y/maxresdefault.jpg)
![microsoft excel keyboard shortcut microsoft excel keyboard shortcut](https://www.addintools.com/english/menuword/images/keyboard_shortcuts.gif)
Selects the entire worksheet.If the worksheet contains data, Ctrl+A selects the current region. Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).In a PivotTable, it selects the entire PivotTable report.Ĭopies the value from the cell above the active cell into the cell or the Formula Bar.ĭisplays the Insert dialog box to insert blank cells.ĭisplays the Delete dialog box to delete the selected cells.Īlternates between displaying cell values and displaying formulas in the worksheet.Ĭopies a formula from the cell above the active cell into the cell or the Formula Bar.Īlternates between hiding and displaying objects. Removes the outline border from the selected cells.Īpplies the Currency format with two decimal places (negative numbers in parentheses).Īpplies the Percentage format with no decimal places.Īpplies the Scientific number format with two decimal places.Īpplies the Date format with the day, month, and the Time format with the hour and minute, and AM or PM.Īpplies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. Switches between worksheet tabs, from right-to-left.Īpplies the outline border to the selected cells. Switches between worksheet tabs, from left-to-right. If you don’t know the sequence, press Esc and use Key Tip badges instead. If you know the entire key sequence, go ahead and initiate the command. A box pops up saying you’re using an access key from an earlier version of Microsoft Office. For example, try pressing Alt, and then press one of the old menu keys E (Edit), V (View), I (Insert), and so on.
#Microsoft excel keyboard shortcut full
However, you need to know the full shortcut from memory - there are no screen reminders of what letters to press. Most of the old Alt+ menu shortcuts still work, too.
![microsoft excel keyboard shortcut microsoft excel keyboard shortcut](https://s3.manualzz.com/store/data/024988404_1-76e64958bbd593cb30c1883a7a914ad9.png)
For example, Ctrl+C still copies to the clipboard, and Ctrl+V still pastes from the clipboard. Keyboard shortcuts that begin with Ctrl will still work in Microsoft Excel 2013. Then, press the key for the button you want. This makes all the Key Tip badges for that tab’s buttons appear. To display a tab on the ribbon, press the key for the tab-for example, press the letter N for the Insert tab or M for the Formulas tab. The ribbon comes with new shortcuts, called Key Tips. If you’re new to the ribbon, the information in this section can help you understand the ribbon’s keyboard shortcut model.