F5 : Go to any cell by pressing F5 and typing the cell coordinate or cell name.Ctrl + End : Go to the most bottom right used cell.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).
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.