Sunday, 12 April 2015

Most useful Excel Keyboard Shortcuts That will make your Work Easy

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 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+SHIFT+L (Toggle Autofilter)

ALT+ES (Paste Special > Values)

CTRL+Arrow keys (Navigate around the workbook)

CTRL+ALT+V (Display the Paste Special dialog box)

ALT+H-F-D-G (Home, Find, GoTo)

Ctrl+Shift+* (Select current region around active cell)

CTRL+K (Add Hyperlink)

Ctrl+Shift+drag (Drag and insert copy)

F2 – Edit a cell

Ctrl+Shift+: (Insert current time)

CTRL+T (Insert Table)


No comments:

Post a Comment