Shortcut keys in MS excel to improve your efficiency at work
Here is another mind blowing blog with some reliable information on Shortcut keys in MS excel. Do not worry I will not talk about Cut, Copy, Paste. It is beyond that. I am 100% sure that after reading these shortcut keys your work efficiency will improved to a significant extent.
I also request you to open an excel sheet with some dummy data and use these shortcut keys. Please also read my another blog on Shortcut keys in SAP .
Shortcut Keys related to Selection of content
Select the whole column
CTRL + SPACE
Select the whole row
Select table
SHIFT + CTRL + SPACE bar
Save
CTRL + s
Select visible cells only
ALT + ;
Select entire region
CTRL + A
Select range from start cell to far left
SHIFT + Home
Select range from start cell to end in direction of arrow
SHIFT + End + arrow
Select a continuous range of data (e.g. pivot), no matter where your cursor is.
CTRL + *
Select blank cells
F5 + ALT + S + K + ENTER
Select all cells with comments
CTRL + SHIFT + O
Select all cells that are directly or indirectly referred to by formulas in the selection
CTRL + SHIFT + {
Select all cells with formulas that refer directly or indirectly to the active cell
CTRL + SHIFT + }
Selects all the way to a1 from cursor position
CTRL + SHIFT + HOME
Select cells in the direction of arrow
CTRL + SHIFT + Arrow
Shortcut keys related to Navigation in Excel sheet
Previous sheet
CTRL + Page Up
Next sheet
CTRL + Page Down
Launch GO TO Dialog (from here you can select special or jump to a cell or range)
F5
Go to top left (will go to top left of freezed pane if set)
CTRL + Home
Go to last non-blank cell
CTRL + end
Go to previous sheet
CTRL + PgUp
Go to next sheet
CTRL + PgDn
CTRL + p
Toggle between workbooks in a given session of excel.
CTRL + TAB
Shortcut keys related to FORMULAS in MS Excel
Sum range
ALT + =
Display range names (can be used when typing formulas)
F3
Evaluate formulas. (its easy to remember when working with some “tuf” formulas!)
ALT + TUF
Copy a formula from above cell and edit
CTRL + ‘
Display the formula palette after you type a valid function name in a formula
CTRL + A (while writing a formula)
Alternate between displaying cell values and displaying cell formulas
CTRL + ` (Single Left Quotation Mark)
Excel short keys related to Data formatting
Open format cells
CTRL + 1
Bold a cell’s content
CTRL + B
Format Painter – Paste formats from selection
ALT + EST
Format as number with 2 dp
CTRL + SHIFT + 1
Format as local currency
CTRL + SHIFT + 4
Format as percentage with 0 dp
CTRL + SHIFT + 5
Hide row
CTRL + 9
Hide column
CTRL + 0
Unhide row
CTRL + SHIFT + 9
Unhide column
CTRL + SHIFT + 0
Display the style command format menu
ALT + ‘
Sets/removes strikeout in current cell
CTRL + 5
Show/hide the top bar when you have a group
Crtl + 8
Single border around selected cells
CTRL + SHIFT + 7
Sort
ALT + DS
Insert hyperlink
CTRL + K
Freeze panes
ALT + WFF
Remove grid lines
ALT + WVG (2007+)
To wrap lines
ALT + HW (2007+)
Shortcut keys for Excel options
Save as
F12
Collapse the ribbon (press again to expand)
CTRL + F1
Opens print preview
CTRL + F2
Maximize the current window
ALT + SPACE X
Activate next window
ALT + TAB
Activate previous window
ALT + SHIFT + TAB
Close an excel workbook
crtl + F4
Split screens
ALT + W + S
EVERYTHING ELSE
Create a pivot table
ALT + DPF
Keep filter on columns, but show all rows
ALT + DFF
Also ALT + HSF both commands will work.
Insert pivot table (select the desired data)
ALT + NV + Enter
Shortcut keys for EDITING in MS excel
Edit a cell, place cursor at the end
F2
Show in-cell drop down with previously entered values
ALT + Down arrow
Fills down value from cell above
CTRL + D
Add a comment or Edit comment
SHIFT + F2
Insert new sheet
SHIFT + F11
Insert row
CTRL + +
Delete row
CTRL + –
Copy
CTRL + C
Paste
CTRL + V
Cut
CTRL + X
Undo
CTRL + Z
Get a line break inside the cell
ALT + Enter (while editing the cell)
Clear all contents
ALT + EAA
Copy
CTRL + insert
Paste
SHIFT + Insert
Make chart/pivot chart
F11
Edit a cell in Apple Macs
CTRL + U
Copy the value from the cell above the active cell into the cell or the formula bar
CTRL + SHIFT + ”
Copies whatever is in the cell to the left of it.
CTRL + R
Delete box (cell, row, column)
ALT + ED
Insert box (cell, row, column)
ALT + IE
Enter current date
CTRL + ;
Enter current time
CTRL + :
4 Comments
Hello,
I found your article very useful for my work. I appreciate your writing.
Everyone can able to understand each and every point.
Thanks
Hi Vaibhav,,
Brilliant article. Everyone can easy to understand. Very clearly explained every point.
Thank you for sharing such kind of information.
Nnice job, Vaibhav. Very useful and clearly explained.
Just let me add a word about the locale input: these shortcuts will not work same way on all types of keyboard. Some commands are common (e.g. Ctrl + C; Ctrl + S, etc..) and shared on all types, just like the common set of ASCII characters, but what if one uses an AZERTY keyboard, or an Italian QWERTY? It will simply be impossible to replicate the proper sequence. of keys.
Furthermore, MS Excel comes with a localized set of formulas and syntax, and not always these are easy-to-understand, particularly when an improper translation from native version occurs.
It would be very worth to build a comparison table where all shortcuts are listed according to language, locale input method and keyboard.
Thanks Raffaele. You have raised a very valid point. I do not have much knowledge about language issues. I will explore it and update the post accordingly.
Comments are closed.