Alt + D + G + U – Ungroup Rows / Columns.This is useful if you need to routinely working with columns and rows and Excel formulas. Alt + H + L + C + S – Delete Conditional Format.Alt + E + S + V – Paste Values (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Alt + E + S + T – Paste Formatting (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Alt + E + S + F – Paste Formula (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Alt + H + B + P – Top Border *for adding lines.If your Excel sheet is full of color you might want to master this section of keyboard shortcuts. Ctrl + Home – Move to Cell A1 (top left).Ctrl + Pageup / Pagedown – Move to Next / Previous Worksheet Tab.Ctrl + Minus (# pad) – Delete Row / Delete Column.Ctrl + Plus (# pad) – Insert Row / Insert Column.Ctrl + Arrowkey – Jump to Edge of Content.Navigating through Excel spreadsheet could be time-consuming, especially if you are dealing with a large data-set. Ctrl + Alt + V – Paste special, will trigger the prompt for more options.Alt + W + Q – Zoom in (type in % zoom, helpful with large dataset).Alt + H + 9 – Remove one decimal * requires pressing all keys at the same time.Alt + H + 0 – Add one decimal * requires pressing all keys at the same time.F2 + F9 – Show as input number *useful for checking numbers but press ESC after (or you’ll change formulas into an input).F2 – Edit Cell, Show Formula (avoiding double-click).The key is to minimize the use of the mouse and do as much as you can with the keyboard to save you time and improve accuracy. Start with some basic and most frequently used ones in all kind Excel workflow. If you work with Excel on a daily basis, it’s worth spending an extra 10 minutes to sharpen and improve on your shortcut games, because this 10 minutes investment will pay back exponentially in no time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |