Why would you simply delete all of those rows that have Total in them? Don't they have important data in them? You can't just ignore data by deleting it and pretending it is not there!

Hi Kurt, The rows with 'Total' included data that was summarizing the rows immediately above them. So, in order to create a clean database without as many subtotals as rows, I decided to remove them in this case. But you're right, whenever we delete data, we need to be absolutely certain that this wouldn't change the information we have as in this case. Best, Ned

Follow this topic

Kurt Mannick

Last answered:

27 May 2021

Posted on:

27 May 2021

Deleting Rows with "Total"

in Introduction to Excel / Ordering the Source Worksheet

1 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

27 May 2021

Deleting Rows with "Total"

Submit an answer

related questions