From the course: Excel Quick Tips (2023)

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Quickly insert a total

Quickly insert a total - Microsoft Excel Tutorial

From the course: Excel Quick Tips (2023)

Start my 1-month free trial Buy for my team

Quickly insert a total

“

- [Instructor] You can quickly total data or perform other calculations in an Excel sheet by using the total row option. Start by clicking anywhere inside the table where you want to create totals. Under the table design tab, check total row. Notice this adds a total row to the bottom of the table. Click a cell in the column of the total row that you want to calculate. Then click the menu to see the options in the dropdown list. In this case, we'll choose some. The total is automatically calculated. You can choose from the same menu in each cell of the total row, or if you want to perform the same calculation to adjacent cells, grab the lower right hand corner of the cell you just calculated and drag it to select the other cells you want to apply the same calculation to.

Contents