Ask Your Question

Calc: How can I alphabetize a table using any column?

asked 2017-04-26 14:34:23 +0200

jopower gravatar image

updated 2017-04-26 15:55:18 +0200

Using CALC: I have opened a CSV file table with about 3000 lines and 8 columns. It is a list of all the SNAP accepting stores in Colorado. It is not alphabetized in any column. I want to be able to view all the stores in my county or city (two of the columns) without reading through the entire 3000 lines. Alphabetizing by column data would help immensely. There is no obvious way to alphabetize the table by the data in any column.

Were I to have my "perfect solution", I would click on a column to select it, then click again to alphabetize "up" and click a 3rd time to alphabetize "down", just as we can do with most PC window contents by column. Failing that idea, I'd right click any column to find the option to alphabetize the entire table by the contents of the selected column. Why is there no such ability???

2nd option to go with this would be to save the table "as last viewed" (and other possibilities).

3rd option would be to renumber the table as re-ordered by alphabetizing (and other possibilities).

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-04-26 16:10:13 +0200

jopower gravatar image

I did finally see the sort icons on the toolbars and that the DATA menu has sorting as well. This worked as I liked. However, a right click option on the column would be much more helpful and handy.

edit flag offensive delete link more


I just noticed the SORT didn't sort the whole table everytime. It only sorted the selected column. A dialog box also came up saying "the cells next to the current selection also contain data...". If I choose "current selection", no other data moved. If I choose "extent selection" I get inconsistent results. Sometimes it sorts the whole table by the column data... just what I want. Others a 2nd dialog box appears demanding to include other columns. Can't understand under what rules it does it.

jopower gravatar imagejopower ( 2017-04-26 16:25:09 +0200 )edit

answered 2017-04-26 15:26:59 +0200

erAck gravatar image

Just place the cell cursor in the column you want to sort and click one of the Sort Ascending or Sort Descending buttons. For more detailed options use the Sort button with the two arrows, or menu Data -> Sort.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-26 14:34:23 +0200

Seen: 120 times

Last updated: Apr 26 '17