I have a Google spreadsheet that has the
A column as an ID field (incrementing numbers 1...1000; no formula, just numbers). That column is frozen as is the first row of headers.
I sorted by column
B and now am unable to re-sort by column
A again. There is no sort option in the context menus or under the Data menu above.
When I try to View, no columns Frozen I get a message that says that “this is not permitted because it would alter the structure of the table”. Not sure if this is related.