Did your table turn into a plain cell range again? Don’t freak out. Someone probably pressed Ctrl+Z one too many times. Just highlight the data again and hit Ctrl+T. You’re the table whisperer now.
Can’t find the Design tab? Click anywhere inside the table. It’s like a shy octopus—it only appears when you’re looking at the table. Sneaky, but helpful.
Got empty rows in your data? Delete them before creating the table. Otherwise, Excel thinks you want a table with weird gaps, like a broken picket fence. Nobody wants that.
Excel Invert Table | Rotate Table In Excel – NYSNIB
