How to sort a table in Numbers on Mac by column, step by step

Sort one column with the column arrow

The column arrow is the fastest way to sort. Use it when one column should decide the order and nothing else needs to stay in a special position. Customer names, dates, and amounts all work this way. Hover over the column letter, click the arrow, and choose a direction. The table reorders around that column.

Ascending means A to Z for text and lowest to highest for numbers. Descending means Z to A and highest to lowest. Check that a date column holds real dates before you sort it. A column of text that only looks like dates sorts as text, and the order will surprise you.

Sort by more than one column in the Organize sidebar

Sometimes one column is not enough. A sales list might need grouping by region, then by amount inside each region. The quick arrow cannot do that. The Organize sidebar can.

Open the sidebar and use its Sort tab. Add a rule for the region column and set it to Ascending. Then add a rule for the amount column and set it to Descending. Numbers applies the rules in order, so region decides first and amount decides within each region.

Keep the rule list short. Each rule adds one more layer to the sort. If a rule sits in the wrong place, drag it. If you no longer need it, hover over the rule and click the Trash button.

• Sort Entire Table: reorders every row in the table.
• Sort Selected Rows: reorders only the rows you highlighted.
• Add a Column: adds another rule under the list.
• Ascending: A to Z, or lowest to highest.
• Descending: Z to A, or highest to lowest.
• Sort Now: runs the sort with the rules you set.

Worked example: a sales list sorted by region and amount

Say your sheet lists orders by region. Each row holds a salesperson, a region, and an amount. You want the regions in A to Z order, and the biggest orders at the top of each region.

Select the whole table first, so every column moves together. Open the Organize sidebar, go to the Sort tab, and choose Sort Entire Table. Add the region rule as Ascending, add the amount rule as Descending, and click Sort Now. Scan the first and last rows of each region to confirm the order.

If a region looks out of place, the cause is usually a typo. A region spelled with a trailing space sorts as its own group. Fix the spelling in that cell, then sort again.

Sort part of a table with Sort Selected Rows

Sort Selected Rows is for cases where the rest of the table should stay put. Pick it in the Sort tab of the Organize sidebar. Control-clicking selected cells in a column opens Sort Rows options for that range instead.

Be careful with partial sorts. If you highlight one column and sort it alone, its values can move away from the rows they belonged to. A name might end up next to someone else's amount. Select complete rows when the table is a list of records, such as customers or orders.

Sort a categorized table by group

Categorized tables group rows under headings. Sorting then works inside each group. Rows stay in their group, and only their order inside that group changes.

To reorder the groups themselves, click the arrow on the group column and choose Sort Groups. Keep the group column in mind when you plan a sort. It controls how the rest of the table is arranged.

Why sort options go missing

Missing sort options usually have one cause. Apple says cells merged across adjacent rows block the sort. Rows with merged cells cannot be sorted, so the options drop out of the menu.

Fix it with Table > Unmerge Cells for the cells you know are merged. If you are not sure where they are, use Table > Unmerge All Cells. Then look over the table. A merged title that spanned several columns may now look split.

Apple's notes also say header and footer text is not sorted. Hidden rows and columns are sorted, though. Unhide the rows you need to see before you sort, so you can check the result.

Sorting in Numbers for iCloud works differently

If you use Numbers in a browser at iCloud.com, the steps change. Select the column, click the down arrow on its border, and choose Sort Ascending or Sort Descending. All rows reorder with the column you sorted.

The iCloud guide covers a single column only. It does not describe multi-column rules, Sort Entire Table, or merged-cell limits. For those, use the Mac app.

The iCloud guide does describe how values sort. Numbers sort before text in a mixed column. Boolean cells come after alphabetical and numeric values. Blank cells go to the bottom, and header rows in the sorted column stay in place.

Which Numbers version and subscription you need

Apple's Creator Studio page says Numbers for Mac needs macOS 26 or later. Full Creator Studio functionality requires macOS 27, according to the same page.

In January 2026, Apple shipped a separate Creator Studio edition of Numbers for Mac as version 15.1. The older app was updated to 14.5 only to say it will get no new features. If your copy is the older app, check which edition you have before you follow Apple's steps.

Apple's Creator Studio page says a subscription adds premium content and intelligent features. Without one, you keep Numbers and your files. The page does not say whether sorting needs a subscription. MacRumors reported Creator Studio at $12.99 per month in the U.S.

Mistakes people make when sorting in Numbers

• Sorting one column alone when each row is a record. Use Sort Entire Table for lists like this.
• Expecting the header to move. Apple says header and footer text is not sorted.
• Assuming Sort Selected Rows moves whole rows. It only reorders the rows you highlighted, so check that the highlight covers every column.
• Searching the menus for a long time. Check for merged cells first.
• Skipping the check. Scan the first and last rows before you move on.

Where Lazur fits while you sort

Lazur is a voice assistant for the Mac that lives in the notch. Hold Option and Command together to ask about anything on screen. Lazur answers out loud. You can ask where the Organize button is, and Lazur draws a circle and a label around it.

Ask how to finish a step, and Lazur guides you one click at a time. It waits for each click before it moves on. It does not click for you, and it does not change your table. You stay in control of the sort.

Lazur looks at your screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is never used to train AI models.

Lazur runs on macOS, on Apple silicon and Intel Macs. For more on Numbers, see Lazur for Numbers on Mac, or download Lazur and try it on your own table.

Next steps after your table is sorted

Keep a copy of the file before a big sort if the table matters. Sort the copy first. Once you trust the result, sort the original the same way.

After the sort, check any totals or formulas that depend on row order. Read a few rows from the top and bottom. If something looks off, press ⌘Z and try again with the right direction or rule.