MrExcel Publishing
Your One Stop for Excel Tips & Solutions

AutoSum All Around


July 11, 2017 - by Bill Jelen

AutoSum All Around

A great trick for adding Total Row and Total Column in a single click. Also in this episode:


Watch Video

  • A great trick for adding Total Row and Total Column in a single click. Also in this episode:
  • Fill Handle works with "any word" and a number
  • Fill handle with custom list from episode 1978
  • Using RANDBETWEEN for fake data but not budgets
  • AutoSum all around by choosing data + total row and column
  • Formatting using Heading 4 cell style
  • Formatting using Title cell style
  • I hate the comma icon in the Number tab
  • Using dialog launcher to get to Format Cells
  • Saving a regular comma style as a new Style
  • Adding comma style to all future workbooks - page 20

Title Photo: skeeze / pixabay


Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.