From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Adding a whole worksheet

Adding a whole worksheet - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Adding a whole worksheet

Now if you have completed the exercise in the movie about using the AutoSum function in the AutoSum tool, you will have a worksheet that looks pretty much like this. Well, any numbers manually using the cherry pick method is okay. Using the AutoSum tool and Auto Fill are even better but, when you have a worksheet like this that's compact, you don't have any blank columns, you don't have any blank rows, you can add up the numbers very, very quickly. You don't have to write even a single formula. So let's select all the numbers going down that column and press Delete. Let's select the numbers going across the Total row and press Delete. So again, you have just your data and their totals. Here's what you want to do. Let's select cells starting from the very first number, select down and across. So you have not only all of your input data selected but your Total column is the last column selected and your Total row is the last row selected and all you have to do is click the AutoSum tool…

Contents