Forum Discussion
Excel: Making auto-sum adjust automatically to added lines
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.
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.
Evan_Bolin When I go to File menu, there is no Design tab. I do not find Design under any tab. Thanks, Ken
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
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