Add a Whole Worksheet in Excel 2010


show more Adding a whole worksheet provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

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 ...

Adding a whole worksheet
Video duration: 1m 48s 6h 21m Beginner

Viewers:

Adding a whole worksheet provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...