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
|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|
|Go back||CTRL Z|
|Go forward||CTRL Y|
|Edit cell content||F2|
|Insert name into a formula||F3|
|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
|@||ALTGr V (or ALT 64)|
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.