19 Excel Shortcuts you NEED to use more [with FREE PDF 📃]

简介：

#shortcuts time. Here is a list of 19 Excel shortcuts that are my absolute favourite. If you use Excel for data analysis work, then you must know these. 0:00 - CTRL T - to create a table 1:28 - CTRL Arrow keys ⬆⬇➡⬅ - navigation 2:06 - SHIFT CTROL Arrow keys - Selection 2:33 - CTRL A or CTRL * - Select all 2:51 - F2 - Edit a cell 3:17 - CTRL Enter - Put same value in multiple cells 3:53 - CTRL SHIFT 4 - Apply currency formatting 4:16 - CTRL SHIFT 3 - Format dates in d-mmm-yy 4:31 - F4 - Repeat last action 5:14 - CTRL SHIFT L - Filter on / off 5:51 - CTRL 1 - Format selected thing 7:16 - CTRL E - Flash fill 7:57 - CTRL ; - Current date 8:35 - ALT Enter - New line in a cell 9:08 - CTRL D - Copy down 9:48 - ALT Down arrow ⬇ - In-cell popup 10:47 - CTRL DRAG - to copy selected item(s) 11:27 - WIN . - Emoji keypad in Excel! 12:18 - CTRL F1 - Collapse / expand Ribbon 12:39 - ALT - Show ribbon shortcuts 13:26 - CTRL - (bonus) Delete cells 13:55 - CTRL + (bonus) Add cells