Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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 and you are done.
You don't have to Auto Fill, you don't have to check answers, it is done. Pretty cool, huh? Let me show one other slightly different way to do that. I am just going to press Ctrl+Z to undo. When you have that area selected, you can press Alt+Equals. Hold down the Alt key and press Equals. That's the shortcut for the AutoSum tool and if you take a look here, I am just going to press Ctrl+Tilde and now you can see that Excel has written the formulas correctly going down that column, and it's written the formulas correctly going across this row.
And I will press Ctrl+Tilde to come back. So when you have a compact worksheet like this, use that feature and you could get yourself done and in no time at all.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 73333 Viewers
80 Video lessons · 129161 Viewers
52 Video lessons · 63561 Viewers
59 Video lessons · 49320 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.