Ctrl + Up/Down Arrow: Move to the cell most top or bottom in the column.Up/Down Arrow: Move one cell up or down.Ctrl + Left/Right Arrow: Move to the cell most left or right in the row.Left/Right Arrow: Move one cell to the left or right.Keyboard shortcuts are applicable to Google Sheet as well. Using keyboard shortcuts to get around the worksheet and moving between cells can be a great time-saver when working on Excel. Alt > F: Open the File tab menu Advertisements.Alt > F > T: Open option menu Tab Navigation in ExcelĮxcel Tab navigation can also be easily done with a click of the mouse, but Tab navigation shortcut keys can be helpful when you don’t want to move your hands between your keyboards and your mouse.įor the highly advanced users, you may want to switch between Tabs quickly using your keyboards.Ctrl + Shift + U: Expand or collapse the formula bar.Ctrl + F1: Show or hide the ribbon Advertisements.Recommendations: Complete beginner’s Guide to set up your home office.īefore we jump into the advanced user guide to excel shortcuts, let’s look into some simple shortcuts to general help and settings. Ctrl + U: Underline the selected text Advertisements.It will repeat that action in the new cell.
if the previous action, you’ve typed in a cell is “Go!” or if you change the font color. F4: Repeat the last command or action.Ctrl + Alt + V: Display paste special dialogue box.Ctrl + V: Paste previously copied information.Shift + Arrow keys: Select highlighted selections.Ctrl + Shift + F4: Find previous match.Ctrl + F9: Minimize the workbook window.These 27 basic shortcut keys in Excel, can potentially improve your productivity by 300%. Some are general Microsoft Office keyboard shortcuts, while others are specifically for MS Excel. As a fellow Excel enthusiast, I think these Excel courses will definitely benefit you, so give it a try and check it out!īeginner and advanced Excel users may or may not have known some of these keyboard combinations for Excel. We just did an in-depth review of the Top 5 Best Excel Courses that can help you to improve your Excel Skills. But learning just a few from this list can turn you from an Excel beginner, into an advanced Excel user! Just by learning the basic shortcut keys in Excel can improve your productivity by 300% or more.Įven though our list of Excel shortcuts is massive, it’s not a complete list. No one can memorize all these keyboard combos, but some shortcut keys are more useful than others. MS Excel shortcut keys differentiate the beginners from the pros, but with hundreds of shortcuts in Excel, do you need to learn them all?
Now, even when you are familiar with Microsoft Excel, you might be pleasantly surprised that there is a wide range of keyboard shortcuts that can boost your productivity and make your life much easier.
0 kommentar(er)
