Automatic totals Sum Alt +=

FrecklePaw
2StarLounger
Posts: 130
Joined: 12 Aug 2020, 08:40

Automatic totals Sum Alt +=

Post by FrecklePaw »

I have a totals column that I need to update regularly; instead of scrolling to the top of the sheet and highlighting everything in that column to get the Sum Alt += total at the bottom using the E icon thingy, is there a quicker way. It seems tedious to have to scroll all the way to the top, highlight the entire column, leave one blank cell at the bottom for the total then click the E sum button thingy. (Time-saving is important to me!)
I can send over a screenshot of what I mean, but it doesn't seem to let me add images here (why not, does anyone know?)
TIA,
FP

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Automatic totals Sum Alt +=

Post by HansV »

If there are no blanks in your data, you can simply click in the cell immediately below the data and press Alt+=
Excel will automatically choose the range above the cell to sum.
Best wishes,
Hans

FrecklePaw
2StarLounger
Posts: 130
Joined: 12 Aug 2020, 08:40

Re: Automatic totals Sum Alt +=

Post by FrecklePaw »

Amazing! Much quicker - thank you :)