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.

So I want to sort my Spreadsheet on Google but it remain in the Categories that it's laid out. I can get to it sort double columns but the categories get messed up as they move away from where they should be. I'm constantly adding to this document and want the additions to auto sort into their needed locations.

This the document, so you can get the idea of what I'm looking for.

share|improve this question

1 Answer 1

Use the SORT function:

SORT(data, keyColumn_1, ascOrDesc_1, keyColumn_2, ascOrDesc_2, ..., keyColumn_30, ascOrDesc_30)

Returns the rows in the given data range (or array), sorted according to the given key columns. There are two ways to specify the key column: either as a column within the data range, or as another column outside the range. To specify a column within the data range, give its index within the range: 1 is the first column of the range, 2 is the second column, etc. To specify another column outside the range (e.g. an intermediate calculated value that you don't want to include in your output), just specify it as a range. Each key column must also be marked to sort either ascending or descending, by adding either TRUE or FALSE after that specifying that key column. You can also specify only a single array or range. In that case, the function returns that range sorted ascending by the columns from left to right.

In your case, it'd be something like =SORT(A2:E13,1,True).

share|improve this answer
Only problem with the Sort function, as I've tried this, is that the divided categories get scrambled into the mix. My idea was something like this (pseudocode time) On Edit Move Entry to X category based on Y Values Sort X Category by First letter –  Skyler Burgess May 15 '13 at 13:34

Your Answer


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.