Forum Discussion
Insert Table Column disabled
I Formatted a range of data as a Table, and the Table Design menu appears when I click inside of it. But when I click on an interior cell and drill into Insert-> from the context menu, the ... "Tabl...
How to test quickly
- Click a middle cell in the data area (not header, not total row).
- Press Ctrl+Shift+ + → does “Insert Table Columns” appear?
- If not, check Review → Unprotect Sheet.
- If still disabled, check if the table was created via Data → From Table/Range (Power Query). If yes, column edits must be done in the query.
The most common reason is you’re in the header row, total row, or the table is query-linked/protected. That’s why it works in your other sheet but not here.
Maybe it helps