AutoSum Button not always working
Q: Sometimes when I use the
AutoSum button in Excel, it doesn't always find the right range of
cells. Sometimes it only gets the bottom of the column - other times
only pieces. What's wrong?
A: First of all, I don't like
the AutoSum button. It's very strange. But, if you're going to use it,
try this trick: before clicking on the AutoSum button, select
(highlight) your range first, then hit the AutoSum. It should properly
guess your range now. Personally, I like to just type in the formula by
hand. We cover this in depth in our Microsoft Excel courses.
Just be careful when using the AutoSum button that it did, indeed,
catch all of the cells in the range you want. Let's say you want
to AutoSum a column that has a few hundred rows in it. You can't see
them all on the screen at one time, and you don't realize there's a
break in the data around, say, row 90. You hit AutoSum and it only gets
half the column. That's where the problem comes in. Just be careful, or
better yet, highlight the whole column first, then hit AutoSum.
By Richard Rost
Click here to sign up for more FREE tips