98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Quicker use of autosum
Quicker use of autosum
Resolved · Low Priority · Version 365
Louise has attended:
Excel Intermediate course
Excel Advanced course
Quicker use of autosum
I often need to use the autosum function for various ranges of data in a worksheet, and it takes quite a while as I have to for example add blank lines to allow space for the autosum total. I'm wondering if there's a much quicker way, and if there's any way the task can be more automated rather than starting from scratch with each set of data. (Not sure if I'm able to attach an example of a datasheet?)
RE: Quicker use of autosum
Hello Louise,
Thank you for your question. The quickest way to achieve this is by using VBA coding, but that can be very complex.
A quick manual method, however, is using the Ctrl button on your keyboard. When selecting the rows where the empty rows will be inserted, hold Ctrl while selecting the relevant row headers. Then, right-click and insert rows. This inserts multiple empty rows at once.
Once you have the new blank rows, hold the Ctrl key again while selecting all the cells (or rows) where the SUM function should appear. Afterwards, click the Autosum button, or press ALT and = (shortcut for Autosum).
Excel will add up any values in the columns above the SUM entries.
I hope this helps.
Kind regards
Marius Barnard
STL
Fri 28 Oct 2022: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using an equal (=) sign that isn't part of a formulaBefore you type the equal sign, type an apostrophe: ' |