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
Automatic totals Sum Alt +=
-
- Administrator
- Posts: 78586
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Automatic totals Sum Alt +=
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.
Excel will automatically choose the range above the cell to sum.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
Re: Automatic totals Sum Alt +=
Amazing! Much quicker - thank you :)