15 Excel Keyboard Shortcuts That Will Actually Make Your Life Better
If you are a computer user, then you must have came across spreadsheets. More commonly known as excel sheets. I have been using excel / word from more than a decade now and there are certain excel keyboard shortcuts that I can’t live without.
In this selection of keyboard shortcuts, I have only picked shortcuts that I use frequently and may be you haven’t heard about them yet, In my opinion, using a keyboard shortcut make your life much easier and better with any software you are working with, they give you a type of satisfaction and a sense of productivity.
Use them and tell us which one did you find as a time saver.
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 dialog box)
ALT+H-F-D-G (Home, Find, GoTo)
ALT+ES (Paste Special > Values)
CTRL+SHIFT+L (Toggle Autofilter)
F4 – Change cell reference 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 Hyperlink)
Ctrl+Shift+: (Insert current time)
CTRL+T (Insert Table)
Send us your favorite excel keyboard shortcuts and we will add it in this list, so that other visitors can also make use of your valuable tip.