Forum Discussion

Ken1122's avatar
Ken1122
Copper Contributor
Apr 29, 2020
Solved

Excel: Making auto-sum adjust automatically to added lines

Hello, I have created a spreadsheet in which the columns are totaled at the bottom using auto sum. I add lines for new entries at the top in order to see the most recent entries easily.  However the ...
excel
  • Evan_Bolin's avatar
    Evan_Bolin
    Apr 29, 2020

    Hello Ken1122 

     

    If these columns are in a table, you can go to the Table Design tab and select the checkbox for Total Row. This should add a new row that sums up the column. When you add a new row to the table, it will adjust the range of the formula to include the newly added row. Here's a link to our https://support.office.com/article/video-add-a-total-row-to-a-table-9885a56c-51b5-487a-a168-054afd034631 that goes over this feature. 

Ken1122's avatar
Ken1122
Copper Contributor
Jun 07, 2020

Evan_Bolin When I go to File menu, there is no Design tab. I do not find Design under any tab. Thanks, Ken

Evan_Bolin's avatar
Evan_Bolin
Former Employee
Jun 08, 2020

Ken1122, can you select your table, take a screenshot of what you see in Excel and share it with me so I can see exactly what you're seeing?

 

Thanks,

Evan 

  • Ken1122's avatar
    Ken1122
    Copper Contributor
    Jun 08, 2020

    Evan_Bolin Hello, I'd rather not do that as it contains personal info. I changed the range from starting with the top line with data to the blank line above it. I haven't added more data yet but we'll see if that works. Thanks, Ken 

Resources