I NEED TO INSERT A ROW AND IT SAYS THIS to prevent possible loss of data, you cannot shift nonblank cells off of the worksheet. Select another location in which to insert new cells, or delete data from the end of your worksheet.
Solved by C. S. in 20 mins