Pasting from webpage changes formatting suddenly, unable to revert.

I've been copy pasting data from these webpages into excel. Initially, the formatting/pasting has gone perfectly fine. The data fit perfectly and organized itself. After a month or so, mid pasting, the formatting changed. The rows and columns are more scrunched together and formatting is in much more disarray.

I've attached the excel workbook I was working on when it changed. The two links below are example webpages I copy pasted from.

The workbook's sheets that are numbered are the ones that pasted fine. The two named badsheet are the incorrect formatting. Ignore the main sheet.

What did I accidentally press?

• I've searched and tried changing the paste formatting but I'm trying to get my pasting to the original format
• pasting it into google sheets provides the correct format
• copy and pasting from a completed sheet provides the exact same result
• the heading at the top that says "well information"'s cell color is supposed to be a dark blue, but is removed in the incorrect sheets
• the row and column widths and heights are incorrect

http://sonlite.dnr.state.la.us/sundo...o2?p_wsn=20432

http://sonlite.dnr.state.la.us/sundo...o2?p_wsn=22639