Excel Essential Skills - Rows & Columns and the EVIL Merge and Center: Chris Menard Training

All users need certain essential Excel skills. Some of the most popular essential skills include autofit, autosum, inserting and deleting rows and columns. Another needed skill is absolute reference.

AutoFill in Excel

Topics covered in this post

- Autofit - Absolute reference - Autosum - Manual cell width - Merge and Center - Inserting and Deleting Rows and Cols - Inserting and Deleting Ranges

YouTube Video

Excel Essential Skills \| Rows & Columns and the EVIL Merge and Center -

AutoSum in Excel

If you need to sum a range of numbers, use AutoSum to quickly add the numbers.

Select a cell next to the numbers you want to sum, click **AutoSum** on the Home tab, press **Enter**, and you’re done.