In a spreadsheet one of the columns has a default value populated from the middle of spreadsheet (row 6000 onwards) till the end of spreadsheet file. How do I remove it
KPBR2906
Have You tried to filter Your sheet per a default value?
... and after that clear those cells values.
Or
Have Your tried to use find?
... and after that ... replace those as possible.