Ctrl + Up or Down arrow : Move to the top or bottom cell in the column.Up or Down arrow : Move one cell up or down.Ctrl + Left or Right arrow : Move to the farthest cell left or right in the row.Left or Right arrow : Move one cell to the left or right.With these shortcuts, you can almost completely eliminate the use of a mouse, never breaking your flow. Going a step further is the keyboard shortcuts specifically used within Excel worksheets and cells. Shortcuts for moving around in a worksheet or cell F11 : Create a bar chart based on selected data (on a separate sheet).F9 : Calculate all worksheets in all open workbooks.F4 : Repeat the last command or action.Alt + Q : Go to the “ Tell me what you want to do ” box.Alt + F11 : Open the Microsoft Visual Basic For Applications Editor.Alt + F8 : Create, run, edit, or delete a macro.Alt + F1 : Create an embedded bar chart based on select data (same sheet).Shift + F9 : Calculate active worksheets.Ctrl + Tab : Switch between open workbooks.Ctrl + Shift + U : Expand or collapse the formula bar.Ctrl + F9 : Minimize the workbook window.They’re not particularly advanced, but they help you get around Excel just a bit easier. These keyboard shortcuts are used for manipulating workbooks, getting help, and other interface-related actions. Delete : Remove the contents of a cell, selected data, or selected cell range.Ctrl + V or Shift + Insert : Paste contents of a cell, selected data, or selected cell range.Ctrl + C or Ctrl + Insert : Copy contents of a cell, selected data, or selected cell range.Ctrl + S : Save the currently open workbook.Ctrl + O : Open a workbook saved on your computer or an online source.Ctrl + F : Search in a spreadsheet, or use Find and Replace.Let’s start with the basics and see how you can use basic shortcuts to speed up your Excel flow: These shortcuts aren’t specific to Excel only - they work in most other applications and on websites as well! Chances are, you might have even heard of them before. The shortcuts below are very basic, yet very powerful.
Note: These shortcuts were carefully selected from Top 51 Excel Templates to Boost Your Productivity that you can check out to boost your Excel Productivity. So, we made a list of the most useful Excel shortcuts you should always have on-hand, or in your memory. Memorizing each and every one of them is pretty much impossible. However, since Excel is a very complex application, it has hundreds of shortcuts for you to use. In Excel, these shortcuts are used to expedite common operations by reducing input sequences to a few keystrokes. In computers, a keyboard shortcut is a means for performing one or more commands using the keyboard, that would otherwise be accessible through some sort of user interface. Cut down unnecessary seconds spent browsing through menus and use shortcuts instead. Using shortcuts is one of the most effective ways of speeding up your workflow. Keyboard shortcuts have been around for as long as Microsoft Excel itself.