Apr 29 2020 01:27 PM - last edited on Nov 09 2023 11:09 AM by
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 auto sum does not adjust to include the newly added lines. Is there a way to make it do so automatically? Thanks, Ken
Apr 29 2020 02:31 PM
SolutionHello @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 support page that goes over this feature.
Jun 07 2020 07:27 AM
@Evan_Bolin When I go to File menu, there is no Design tab. I do not find Design under any tab. Thanks, Ken
Jun 08 2020 09:23 AM
@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
Jun 08 2020 09:28 AM
@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
Apr 29 2020 02:31 PM
SolutionHello @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 support page that goes over this feature.