Cannot Delete a Row, It Only Clears the Row

Just like the title says. When I go to delete a row in my spreadsheet, It only clears the data, does not delete the row. I recognized the error last night and have spent 6 hours creating an exact replica of the file today. It has happened again and I am absolutely livid right now. Anything I look up seems to never have had an actual solution. Does anyone have any idea of what may be going on? This is a spreadsheet I use for College Basketball and was hoping to have done, and up and running already.