Copying one row of data but a different row is pasting?

i removed a filter that had been accidentally placed on about 10,000 rows of data i had in a workbook. The lines were all hidden. I have now removed that and all the rows are visible again, but now i have another problem. for example: i insert a new row between rows 31 & 32. i copy the data from row 31 and paste it into the new blank row 32. but for some reason it is pasting the data from the row below 33. this only seems to happen in the section that i removed that filer from not in the rest of the workbook. how can i fix this?

on another note, while i was away someone changed the coloring of all my microsoft programs. instead of word having like a blueish color and excel having black color around the edges and tab it is now black? is there a way to change this back?

Thanks.

i got the color to change back to silver. Thanks!

There aren't any formula in the rows. Just some dates and then some other typed information.
i tired again. no matter where i insert a new line. i copy the info from the line above the
blank one and when i paste it pastes the info from the line below the added blank row.
it only seems to be happening in a certain section of the workbook as well?