{"id":1400,"date":"2012-12-12T10:00:42","date_gmt":"2012-12-12T09:00:42","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=1400"},"modified":"2021-11-11T17:46:09","modified_gmt":"2021-11-11T16:46:09","slug":"klavesove-zkratky-excel-specialni-symboly","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/klavesove-zkratky-excel-specialni-symboly\/","title":{"rendered":"Excel special symbols and keybord shortcuts"},"content":{"rendered":"

<\/p>\n

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

Excel Keybord shortcuts – tips and tricks<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Description<\/strong><\/td>\nKeybord shortcut<\/strong><\/td>\n<\/tr>\n
Today date<\/strong><\/td>\nCTRL ;(semicolon)<\/td>\n<\/tr>\n
Select only visible cells in a range<\/strong><\/td>\nALT ;(semicolon<\/td>\n<\/tr>\n
Actual time<\/strong><\/td>\nCTRL SHIFT .(dot)<\/td>\n<\/tr>\n
Inserr new cells into the range<\/strong><\/td>\nCTRL +(plus)<\/td>\n<\/tr>\n
Remove cells from the range<\/strong><\/td>\nCTRL -(minus)<\/td>\n<\/tr>\n
Select whole table<\/strong><\/td>\nCTRL * (or CTRL A)<\/td>\n<\/tr>\n
Wrap text in a cell<\/strong><\/td>\nALT ENTER<\/td>\n<\/tr>\n
Copy formula into multiple selected cells<\/strong><\/td>\nCTRL ENTER<\/td>\n<\/tr>\n
Array formula confirmation<\/strong><\/td>\nCTRL SHIFT ENTER<\/td>\n<\/tr>\n
Switch between keyboard languages<\/strong><\/td>\nALT SHIFT<\/td>\n<\/tr>\n
Selection from a cell to the end of a column<\/strong><\/td>\nCTRL SHIFT\u00a0down arrow<\/td>\n<\/tr>\n
Selection from a cell to the end of a row<\/strong><\/td>\nCTRL SHIFT\u00a0right arrow<\/td>\n<\/tr>\n
Selection\u00a0of a row with selected cell<\/strong><\/td>\nSHIFT\u00a0spacebar<\/td>\n<\/tr>\n
Selection\u00a0of a column\u00a0with selected cell<\/strong><\/td>\nCTRL\u00a0spacebar<\/td>\n<\/tr>\n
Activate VBA interface<\/strong><\/td>\nALT F11<\/td>\n<\/tr>\n
Create a chart on a new sheet<\/strong><\/td>\nF11<\/td>\n<\/tr>\n
Create a chart on an active\u00a0sheet<\/strong><\/td>\nALT F1<\/td>\n<\/tr>\n
Find<\/strong><\/td>\nCTRL F<\/td>\n<\/tr>\n
Replace<\/strong><\/td>\nCTRL H<\/td>\n<\/tr>\n
Copy<\/strong><\/td>\nCTRL C<\/td>\n<\/tr>\n
Paste<\/strong><\/td>\nCTRL V<\/td>\n<\/tr>\n
Cut<\/strong><\/td>\nCTRL X<\/td>\n<\/tr>\n
Go back<\/strong><\/td>\nCTRL Z<\/td>\n<\/tr>\n
Go forward<\/strong><\/td>\nCTRL Y<\/td>\n<\/tr>\n
Edit cell content<\/strong><\/td>\nF2<\/td>\n<\/tr>\n
Insert name into a formula<\/strong><\/td>\nF3<\/td>\n<\/tr>\n
Absolute address<\/strong><\/td>\nF4<\/td>\n<\/tr>\n
Repeat command<\/strong><\/td>\nF4<\/td>\n<\/tr>\n
Recalculate sheet<\/strong><\/td>\nF9<\/td>\n<\/tr>\n
Insert a comment into a cell<\/strong><\/td>\nSHIFT F2<\/td>\n<\/tr>\n
Go to next sheet<\/b><\/td>\nCTRL PAGE DOWN<\/td>\n<\/tr>\n
Go to previous sheet<\/strong><\/td>\nCTRL PAGE UP<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Keybord shortcuts –\u00a0Special symbols<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Symbol<\/strong><\/td>\nKeybord shortcut<\/strong><\/td>\n<\/tr>\n
\u20ac<\/strong><\/td>\nALTGr E<\/td>\n<\/tr>\n
$<\/strong><\/td>\nALT 36<\/td>\n<\/tr>\n
&<\/strong><\/td>\nALT 38<\/td>\n<\/tr>\n
@<\/strong><\/td>\nALTGr V\u00a0(or ALT 64)<\/td>\n<\/tr>\n
^<\/strong><\/td>\nALT 94<\/td>\n<\/tr>\n
{<\/strong><\/td>\nALTGr B<\/td>\n<\/tr>\n
}<\/strong><\/td>\nALTGr N<\/td>\n<\/tr>\n
<\u00a0<\/strong><\/td>\nALTGr ,<\/td>\n<\/tr>\n
>\u00a0<\/strong><\/td>\nALTGr .<\/td>\n<\/tr>\n
[<\/strong><\/td>\nALTGr F<\/td>\n<\/tr>\n
]<\/strong><\/td>\nALTGr G<\/td>\n<\/tr>\n
\\<\/strong><\/td>\nALTGr Q<\/td>\n<\/tr>\n
#<\/strong><\/td>\nALTGr X<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Notes: <\/em><\/p>\n

ALTGr………. right\u00a0ALT,\u00a0hold together with letters<\/em><\/p>\n

ALT …………. left\u00a0ALT,\u00a0hold together with a number combinat<\/em><\/p>\n

Many people in training have asked after such a table, so here it is. I hope these tricks will help you.<\/p>\n

You can download this table for free here<\/a>.<\/p>\n

If this guide has helped you, become a fan on Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n","protected":false},"excerpt":{"rendered":"

Besides standard icons in office applications users are using, there are a number of shortcuts that will speed up your\u00a0work. I picked several most common, which I also frequently mention on training, for many tricks in Excel, and also here is an useful\u00a0special symbol list. The list\u00a0of these shortcuts can be downloaded for free in […]<\/p>\n","protected":false},"author":1,"featured_media":413,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3],"tags":[10,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/1400"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=1400"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/1400\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/413"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=1400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=1400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=1400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}