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

DescriptionKeybord shortcut
Today dateCTRL ;(semicolon)
Select only visible cells in a rangeALT ;(semicolon
Actual timeCTRL SHIFT .(dot)
Inserr new cells into the rangeCTRL +(plus)
Remove cells from the rangeCTRL -(minus)
Select whole tableCTRL * (or CTRL A)
Wrap text in a cellALT ENTER
Copy formula into multiple selected cellsCTRL ENTER
Array formula confirmationCTRL SHIFT ENTER
Switch between keyboard languagesALT SHIFT
Selection from a cell to the end of a columnCTRL SHIFT down arrow
Selection from a cell to the end of a rowCTRL SHIFT right arrow
Selection of a row with selected cellSHIFT spacebar
Selection of a column with selected cellCTRL spacebar
Activate VBA interfaceALT F11
Create a chart on a new sheetF11
Create a chart on an active sheetALT F1
FindCTRL F
ReplaceCTRL H
CopyCTRL C
PasteCTRL V
CutCTRL X
Go backCTRL Z
Go forwardCTRL Y
Edit cell contentF2
Insert name into a formulaF3
Absolute addressF4
Repeat commandF4
Recalculate sheetF9
Insert a comment into a cellSHIFT F2
Go to next sheetCTRL PAGE DOWN
Go to previous sheetCTRL PAGE UP

Keybord shortcuts – Special symbols

SymbolKeybord 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 *