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.

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. 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.Ctrl + A: Select all selections Advertisements.

Shift + Arrow keys: Select highlighted selections.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. Beginner and advanced Excel users may or may not have known some of these keyboard combinations for Excel.

Microsoft excel shortcut keys 2010