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