So, you have a couple of options in Excel. Recommended article: 10 Excel Data Entry Tricks and Shortcuts Every User Should Knowĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > In the Customize Ribbon category, there is a Keyboard Shortcuts Customize button that is not available in Excel. In Word, you can assign keyboard shortcuts through the Options command on the File tab. Unfortunately, Excel doesn't offer a keyboard assignments command similar to the one available in Microsoft Word. However, you may also want to write your own keyboard shortcuts for specific commands.

Microsoft Excel has many built-in shortcuts as well as the ability to navigate and select in the Ribbon using the keyboard. + (Right arrow) - Move to next section of text.By Avantix Learning Team | Updated March 24, 2021Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019 and 365 (Windows)

+ Shift + - Format number in time format. + Shift + ^ - Format number in scientific format. + Shift + % - Format number in percentage format. + Shift + # - Format number in date format. + Shift + $ - Format number in currency format. + Shift + ! - Format number in comma format. + - Insert the value of above cell into the current cell. + = - Create the formula to sum all of the above cells. + Tab - Move between two or more open Excel files + Page up & Page Down - Move between Excel worksheets in the same + F6 - Switch between open workbooks/windows. + F10 - Maximize currently selected window. + 5 - Strike Through highlighted selection. + A - Select all contents of a worksheet. Spell check selected text and/or document.Īlso some Excel shortcut keys are as follows Repeat the last action performed (Word 2000+). + Space - Reset highlighted text to default font. + Home - Move cursor to the beginning of the document. + End - Move cursor to end of the document. + Backspace - Delete word to the left of the cursor. + Del - Delete word to the right of the cursor. + (Down arrow) - Move to the end of the paragraph. + (Up arrow) - Move to the beginning of the line or paragraph. + (Right arrow) - Move one word to the right.

+ (Left arrow) - Move one word to the left. + Shift + * - View or hide non printing characters. + R - Align selected text or line to the right. + E - Align selected text or line to the center. + Q - Align selected paragraph to the left. + L - Align selected text or line to the left. If you are frequent computer user then you must know the shortcuts to increase the productivity. But in present time when computer is of vast use, using shortcut keys can definitely make your work easier on computer. Taking shortcuts may or may not result in desirable outcomes.

Highlight text shortcut on excel