Sorting Multiple columns in Numbers

Question

Level 1

9 points

Sorting Multiple columns in Numbers

I have imported an excel sheet into a numbers sheet. In excel I can ask date to sort by two columns - for instance (i work for a law practice) sort by court and last name. Can you do this in Numbers? In Excel each column has up/down arrow icons so that is it easy to sort without going to the menu. Is this possible with numbers? I want to verify that we can shift to Numbers before updating to Lion. Sandy

iMac, Mac OS X (10.6.8)

Posted on Dec 21, 2011 2:33 PM

Reply

Answer 1

Dec 21, 2011 9:29 PM in response to Sandy Jay

Here are some images to highlighy how to use the Reorganize Panel Jerry was describing:

clink in the table you want to sort (reorganize) and click the "Reoganize" button in the tool bar OR select the menu item "Table > Show Reorganize Panel"

Reply

Answer 2

Dec 21, 2011 5:48 PM in response to Sandy Jay

Sandy Jay,

In the Table menu, select Show Reorganize Panel. Select the first column to sort by and set the direction. Click the + sign on the right and set up the next column sort, and so on.

Jerry

Reply