If there’s one thing that signifies a power user from a regular user – it’s the command over the keyboard navigation in any software. And Excel is no different.
Some very helpful shortcuts that you could add to your daily routine –
Formatting the cell
The combination of SHIFT + CTRL + <number> defines a particular formatting.
SHIFT + CTRL + 1 – Number formatting, with commas, and two places decimal
SHIFT + CTRL + 2 – Time Format (pre-defined)
SHIFT + CTRL + 3 – Date Format(pre-defined)
SHIFT + CTRL + 4 – Currency formatting(Dollar format)
SHIFT + CTRL + 5 – Percentage format
SHIFT + CTRL + 6 – Exponent format
CTRL + 1 – Opens the Number Format dialog
Repeat Last Action – F4 Key
Auto Sum Function across rows/columns with numbers – Alt + “=”
Paste Special Commands
Combination of Alt + E + S opens the Paste Special Window. A list of shortcuts that will prove to be very useful –
Alt + E + S + V – Paste Values
Alt + E + S + T – Paste Formats
Alt + E + S + F – Paste Formulae
Alt + E + S + W – Paste Column Widths
Alt + E + S + E – Paste Transpose
Alt + E + S + E + V – Paste Transposed Values
Alt + E + S + M – Multiple copied value to all cells
Navigating the Excel Sheet
Shift + Ctrl + Arrow keys – Move over Excel ranges of cells/data
Ctrl keys + Pg Up/Pg Down – Move between tabs
Shift + Ctrl + Home/End – Move to begining or end of range of cells/data
Ctrl + “.” (+ Shift) – Move to ends of selected range of cells (Not commonly known)
While there are hundreds of thousands of shortcuts, what makes a difference is – how many of them you use in your day-to-day use of Excel. The trick lies in forcing yourself to consciously use a shortcut when you go looking for that mouse every time!
"EXCEL" Ytics | Every day in the life of an Analyst 