Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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.

share|improve this question
add comment

migrated from superuser.com Nov 2 '11 at 15:26

This question came from our site for computer enthusiasts and power users.

2 Answers

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

share|improve this answer
add comment

You don't need to remove frozen columns or rows. Simply select the column and click on the small arrow at the right side of the column title bar then choose the sort option.

share|improve this answer
    
There is not sort option when I do that. Selected arrow on the 'A' column, but it doesn't show. It shows for the other columns, though. –  Gern Blandston Nov 7 '11 at 13:37
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.