Google-sheets – Missing sort in Google Spreadsheets menus

google sheetssorting

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.

Best Answer

I am going to guess from the presence of an ID field and from the error message that your sheet is linked to a form.

Duplicate the sheet and perform the desired operations on the duplicate.

Spreadsheets containing form responses don’t currently allow for filtering, column shifting, or other such changes. The reason for these restrictions is that changes like filtering the main spreadsheet’s data will actually disrupt its ability to accept form responses properly.

These restrictions exist whenever you have linked your spreadsheet to a form. If you’d like to sort your data, you can always duplicate or copy your sheet by clicking on the sheet tab and selecting “Duplicate.” This duplicate sheet will contain all of your form data and will allow you to sort and filter as you wish.

http://www.google.com/support/forum/p/Google%20Docs/thread?tid=540148364a65c6fc

Related Topic