Basic Excel keyboard Shortcuts

Microsoft Excel is one of the most popular spreadsheet in recent history. Most people find it difficult and clumsy navigating through Microsoft Excel with their mouse.

So you can now navigate easily through Microsoft Excel using the keyboard shortcuts posted below.

• Ctrl+Shift+L = Turn On/Off filter
• Ctrl+F1 = Expand or Collapse ribbon
• Ctrl+Z and Ctrl+Y = Undo and Redo
• Ctrl+Arrow keys =  Navigate around the workbook
• Ctrl+Alt+V = Display the paste special dialogue box
• Alt+H-F-D-G =Home, Find, Goto
• Ctrl+Esc = Paste special > Values
• Ctrl+Shift+L = Toggle autofilter
• F4 = Change cell preference style while editing formulas
• Ctrl+shift+Drag = Drag and insert copy
• F2 = Edit a cell
• Ctrl+Shift+*  = Select current region around active cell
• Ctrl+K = Add hyperlinks  
• Ctrl+Shift+: = Insert current time
• Ctrl+T = Insert table

Please feel free to add your on favourite keyboard shortcut on the comment box, because i will update this list with yours.