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