Besides standard icons in office applications users are using, there are a number of shortcuts that will speed up your work. I picked several most common, which I also frequently mention on training, for many tricks in Excel, and also here is an useful special symbol list. The list of these shortcuts can be downloaded for free in PDF, download link is at the end of the article.

Excel Keybord shortcuts – tips and tricks

Description Keybord shortcut
Today date CTRL ;(semicolon)
Select only visible cells in a range ALT ;(semicolon
Actual time CTRL SHIFT .(dot)
Inserr new cells into the range CTRL +(plus)
Remove cells from the range CTRL -(minus)
Select whole table CTRL * (or CTRL A)
Wrap text in a cell ALT ENTER
Copy formula into multiple selected cells CTRL ENTER
Array formula confirmation CTRL SHIFT ENTER
Switch between keyboard languages ALT SHIFT
Selection from a cell to the end of a column CTRL SHIFT down arrow
Selection from a cell to the end of a row CTRL SHIFT right arrow
Selection of a row with selected cell SHIFT spacebar
Selection of a column with selected cell CTRL spacebar
Activate VBA interface ALT F11
Create a chart on a new sheet F11
Create a chart on an active sheet ALT F1
Find CTRL F
Replace CTRL H
Copy CTRL C
Paste CTRL V
Cut CTRL X
Go back CTRL Z
Go forward CTRL Y
Edit cell content F2
Insert name into a formula F3
Absolute address F4
Repeat command F4
Recalculate sheet F9
Insert a comment into a cell SHIFT F2
Go to next sheet CTRL PAGE DOWN
Go to previous sheet CTRL PAGE UP

Keybord shortcuts – Special symbols

Symbol Keybord shortcut
ALTGr E
$ ALT 36
& ALT 38
@ ALTGr V (or ALT 64)
^ ALT 94
{ ALTGr B
} ALTGr N
ALTGr ,
ALTGr .
[ ALTGr F
] ALTGr G
\ ALTGr Q
# ALTGr X

Notes:

ALTGr………. right ALT, hold together with letters

ALT …………. left ALT, hold together with a number combinat

Many people in training have asked after such a table, so here it is. I hope these tricks will help you.


If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too.

Leave a Reply

Your email address will not be published. Required fields are marked *