list of shortcuts when designing reports or dashboards in Excel:
To do this | Press |
Copies selected cells | CTRL + SHIFT + C |
Paste Plain Text | CTRL + SHIFT + V |
selects all cells | CTRL + A |
opens the Format Cells window | CTRL + 1 |
repeats your last command or action | F4 |
Draw a Straight Line (from shapes) | SHIFT + MOUSE |
add bullet point | ALT + 7 |
scroll to the start and end of each range | CTRL + MOUSE + ARROW KEY |
Move Chart horizontally or vertically (snap into grid) | SHIFT + MOUSE |
Start a new line of text inside a cell | ALT + ENTER |
move through a worksheet | CTRL + ARROW KEY |
scroll to the start and end of each range | CTRL + SHIFT + ARROW KEY |
Move to the previous/next sheet in the workbook | CTRL + PAGE DOWN / UP |
Edit formula | F2 |
Change cell reference between absolute and relative (formula bar) | F4 |
Undo | CTRL + Z |
check and debug formulas | F9 |
copy formatting more than once | CLICK + CLICK FORMAT PAINTER |
Open Clipboard | CTRL + C + C |