{"id":472,"date":"2016-03-09T06:39:20","date_gmt":"2016-03-09T06:39:20","guid":{"rendered":"http:\/\/sprunworld.com\/?p=472"},"modified":"2016-07-06T10:35:55","modified_gmt":"2016-07-06T10:35:55","slug":"excel-keyboard-shortcuts-that-will-really-save-your-time","status":"publish","type":"post","link":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/","title":{"rendered":"Excel Keyboard Shortcuts That Will Really Save Your Time"},"content":{"rendered":"

\"Excel<\/a><\/p>\n

Are you using computer frequently. Then you must have come across spread sheets \/ excel sheets. Excel sheet<\/a> have tons of features to do your work, calculations etc. in an easier way. In the same way using excel keyboard shortcut is also an easier and quicker way of navigating and executing commands in computer software programs. It really saves your time.<\/p>\n

Excel keyboard shortcuts:<\/strong><\/h2>\n

CTRL+SHIFT+L (Turn On\/Off Filter)<\/p>\n

CTRL+F1 (Expand or collapse ribbon)<\/p>\n

Ctrl+Z (Undo)<\/p>\n

Ctrl+Y (Redo)<\/p>\n

CTRL+Arrow keys (Navigate around the workbook)<\/p>\n

CTRL+ALT+V (Display the Paste Special dialog box)<\/p>\n

ALT+H (home)<\/p>\n

Alt +F (find)<\/p>\n

Alt + D (font)<\/p>\n

Alt + G (Go to)<\/p>\n

ALT+ES – \u00a0(Paste Special > Values)<\/p>\n

ALT + =\u00a0 – (Automatically sum)<\/p>\n

CTRL + PAGEUP \/ PAGE DOWN – (Jump from one sheet to another)<\/p>\n

CTRL + \u2018-\u2018\u00a0 – (control minus will delete the coloum your cursor is in)<\/p>\n

CTRL + \u2018+\u2019 – (control plus will add the new coloum your)<\/p>\n

CTRL+SHIFT+L –\u00a0(Toggle Autofilter)<\/p>\n

Ctrl+Shift+drag – (Drag and insert copy)<\/p>\n

Ctrl+Shift+*\u00a0 – (Select current region around active cell)<\/p>\n

CTRL+K\u00a0 – (Add Hyperlink)<\/p>\n

Ctrl+Shift+: – (Insert current time)<\/p>\n

CTRL+T – (Insert Table)<\/p>\n

F4 \u2013 Change cell reference style while editing formulas<\/p>\n

F2 \u2013 Edit a cell<\/p>\n

Share us your favorite Excel keyboard short keys and will include it in this list, so that other visitors can also make use of your valuable tip.<\/p>\n","protected":false},"excerpt":{"rendered":"

Are you using computer frequently. Then you must have come across spread sheets \/ excel sheets. Excel sheet have tons of features to do your work, calculations etc. in an easier way. In the same way using excel keyboard shortcut is also an easier and quicker way of navigating and executing commands in computer software … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[59,125],"tags":[136,135],"class_list":["post-472","post","type-post","status-publish","format-standard","hentry","category-internet","category-software","tag-excel-keyboard-shoort-keys","tag-excel-short-keys","item-wrap"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t