Apply AutoSUM for Multiple Row and Columns in Multiple worksheets in Excel

xlncad (46) in excel • 5 years ago

Following is my trick to apply AutoSUM for multiple Rows and Columns.

*Select the entire data range with an Extra Column and Extra Row
*Press ALT + =

Apply AutoSUM for Multiple Rows and Columns 1.gif

If you have multiple worksheets with similar data ranges, groups the sheets and apply the same trick.

*Select the first sheet containing data
*Holding the Shift key, select the last sheet containing data
*Select the entire data range with an Extra Column and Extra Row
*Press ALT + =

Apply AutoSUM for Multiple Rows and Columns 2.gif

excel autosum microsoftexcel exceltrick exceltip exceltutorial excelformula autosumexcel

5 years ago by xlncad (46)

$2.10

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!

Sort Order:

Trending

[-]

paulag (73) · 5 years ago

Hi, I just found this post. How come you posted this to your blog and not the Excel for All community? I nearly missed it!!! to post in the community, you need to be in the community and select new post. Then do NOT select post to blog. If you then want the post to also be visible on your blog, you need to resteem it, you can do that by using the little arrow-like symbol beside reply button at the end of your post. let me know if that makes sense.

This is a great trick by the way, nice share.

$0.00

1 vote

[-]

xlncad (46) · 5 years ago

Glad that you like it. Actually I wrote it for the community. But missed the option to post it there.
I will go with your explanation from next time :)

$0.04

1 vote

[-]

paulag (73) · 5 years ago

I did think it for the community alright, but that's why we are in beta. This makes great feedback :-)

$0.00

[-]

theexcelclub (66) · 5 years ago

Oh I wonder if I try using this tag will the post appear in the community..this is a test
#hive-102332

$0.00

1 vote

[-]

paulag (73) · 5 years ago

Nope that does not work! Nice try, great idea to test it :-)

$0.00

1 vote

[-]

steemitboard (66) · 5 years ago

Congratulations @xlncad! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

	You got a First Reply
	You received more than 10 upvotes. Your next target is to reach 50 upvotes.

_{You can view your badges on your Steem Board and compare to others on the Steem Ranking}
_{If you no longer want to receive notifications, reply to this comment with the word STOP}

Vote for @Steemitboard as a witness to get one more award and increased upvotes!

$0.00