💁 Excel Important Shortcut Keys 🤔... 🔹 Alt = – Auto-insert SUM formula ➕ 🔹 Alt Enter – New line inside a cell 🔹 Alt H O I – Auto-fit column width 🔹 Alt H M C – Merge & center 🔹 Alt A E – Text to Columns 🔹 Alt A M – Remove duplicates 🔹 Alt W F F – Freeze/unfreeze panes 🔹 Alt W Q – Zoom to selection 🔹 Alt N V – Insert PivotTable 🔹 Alt N S F – Insert chart 🔹 Alt N F S – Insert slicer 🔹 Ctrl N – New workbook 🔹 Ctrl O – Open workbook 🔹 Ctrl S – Save workbook 🔹 Ctrl W – Close workbook

Excel 2013 PowerPivot Basics #13: Replace 3 Way Lookup Array Formulas for 1.2 Million Rows of Data