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 ... "Table Columns to the Left" option is disabled (greyed). I have another table in a different sheet where the option is available.
Why is it disabled in one of these sheets? I have removed any merged cell rows.
1 Reply
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
