Excel special symbols and keybord shortcuts
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.
You can download this table for free here.
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.
6 komentáře
Dobrý den, děkuji za pomůcku “klávesové zkratky”, určitě použiji. IJ
Zdravím Vás, mohli byste přidat klávesovou zkratku pro “fajfku” ✔ v excelu, prosím?
Dobrý den,
poradíte mi – klávesovou zkratku v Excelu pro zapsání značky průměru?
Dobrý den, musíte to vložit přes symbol.
1) Běžte na kartu Vložení > Symbol.
2) Vyberte typ písma MS Reference Sans Serif
3) Do políčka Kód znaku zadejte F7C2
4) Najde se symbol pro průměr a potvrďte tlačítkem Vložit.
Dobrý den,
je nějaká klávesová zkratka pro vložení propojení buněk?
Děkuji
Zdravím, existuje zkratka pro vložení vzorce?
Děkuji