Excel table (The table feature within excel) column headers, vs. Excel the product's column headings getting jumbled

Question

This is a tricky question, not the usual "how to create an excel table", but an annoying problem I can't figure out.
Look closely at the screenprint. Both are Excel tables, the second a copy paste of the first, into different tabs of the same spreadsheet. The top one with the dark green table column heading in what shows as row 1 was created first. The bottom, is after copying the table to another tab in the same spreadsheet. More background: There was an import from a PDF involved too, but I've seen this happen after just using "Format as Table" and copying from one tab to another or even manually copying a table. I'm trying to figure out WHERE to pick one or the other of the two ways to view the table, so I can make all my tabs consistent with one another.

The table column headings are "Property", "Mandatory", "Type", "Description" and others.

In the TOP image within the screenshot, the table heading is visible and marked as Row 1, while the "column heading" area (base Excel, not the Excel Tables feature) that's normally A, B, C, etc. for columns has also taken on the values of the Excel Table's column heading.

In the lower image, there's no Row 1 visible, the first visible row is the actual data rows starting at 2, but there isn't a formatted and visible EXCEL TABLE heading in the same way as it is in screenshot 1, just the (normally gray) column heading area, showing the Table Heading's values. (EDIT: (to clarify in response to Rory's comment) - I am scrolled all the way to the top in both screenshots. Rory's comment would be the answer if I were scrolled down where the green bar from the top image scrolled off-screen, but that's not the case, I'm at the very top of the scroll area in both images.)

My question is.... Without picking sides, where the heck is this set and/or changed? Thanks in advance!

Answer 1

Hmm, that's interesting, @Rory Archibald un-hiding did indeed fix things.

Do you know the why part of the problem occurring in the first place? I'm asking because I never hid Row 1 myself, what caused it to get hidden?

Answer 2

Hmm, that's interesting, @Rory Archibald un-hiding did indeed fix things.

Do you know the why part of the problem occurring in the first place? I'm asking because I never hid Row 1 myself, what caused it to get hidden? (Apologies for duplicate posts, I'm blaming the site for these)

Answer 3

One of the features of tables is that if the active cell is within the table and the header row of the table is not visible (i.e. you have scrolled it off screen or hidden that row), the column headers (A, B, C etc) change to reflect the table columns. It looks like you either just need to scroll up in the second tab or unhide row 1.