Related Article: Redirected to https://support.apple.com/guide/numbers/whats-new-in-numbers-132-tan700f60676/mac [was: What’s new in Numbers for Mac]

Arrange column in alphabet order

In Numbers you do I Arrange column in alphabet order


iMac 27″ 5K, macOS 13.5

Posted on Sep 16, 2023 8:45 AM

Reply
1 reply

Sep 16, 2023 9:37 AM in response to Killmouseshi

Hi Killmouseshi,

Unfortunately there is no clean way to sort columns, like you can do it with rows.


If you have only a few columns you could do it manually, by moving the columns.

Rearrange rows and columns in Numbers on Mac - Apple Support



Here is an automated way that will work as long as your table contains data.

Some formulas don't work right after you sorted rows / columns, therefore you have to be careful and check the results.


Here my simple starting point.

Please ensure that there are no frozen header columns on the left.


Now go in the top menu and select "Table / Transpose Rows and Columns" that is in the lower section of this menu

This will flip columns and rows.


Result will look like this


Now use sort the rows to get them in the right order


Now go back in the top menu and select "Table / Transpose Rows and Columns".

This will flip columns and rows again, to their original condition.


Now your columns are sorted.


I know this is not a good solution, but it is the only "automated" solution that I know.

Maybe somebody has a better way to do this.


Regards Ralf


Arrange column in alphabet order

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.