agwalsh
asked on
How can I get autosum to automatically highlight totals as well as numbers?
I'm attaching a file with a total of numbers (F7) and then another number. When I insert autosum underneath them to add them up, Autosum just picks up F8 instead of autoselecting F7 and F8. How can I get it to do its usual thing of automatically putting its "marching ants" around the F7:F8 range. Thanks
EE-Excel-autosum-question.xlsx
EE-Excel-autosum-question.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Autosum will not include any cell with the SUM formula in the range to be summed up.
Try Rob's suggestion, that would do the trick.
Try Rob's suggestion, that would do the trick.
@Neeraj - not strictly true, the AutoSum will choose cells containing SUM if they "appear" to be the only cells valid to SUM; as suggested in my first comment when doing the AutoSum on the next cell again, it SUMs the previous SUMs.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yeah, I get I can just select the other cell with the summed numbers but I just like the elegance of Excel automatically anticipating what I want (yes, I know this is a 1st World problem LOL). Will check out the highlight thing...
ASKER
Got the answer I wanted - a workaround :-)
With your sample, use the AutoSum in F9 and accept just the one cell. Then go to F10 and try another AutoSum. This time it recognises the two sums above and suggests adding those.
That is the way AutoSum is supposed to work. Sometimes Excel can be too clever for its own good and doesn't always do what we expect or want.