How to Sort In / Sort Out in Apple Numbers

How to Sort In / Sort Out in Apple Numbers

Spreadsheet applications such as Apple Numbers are designed primarily for data processing, analysis and management. If you want to learn how to properly sort out or arrange your spreadsheet data, follow the basic steps below.

• Step 1: Prepare the Data

  

  The first step is obviously to input your data in the spreadsheet. Whether it be names, numbers, letters, or any other value, list them down accordingly. For the purpose of this tutorial, the example below is a list of first names and they are listed in random order.

• Step 2: Select the Data

  

  The next step is to select the data you want to sort. Choose a column, highlight it then select Column Actions or you can also click the green Column icon located in the lower right corner of the screen. Note that you can highlight more than one column at a time.

• Step 3: Sort the Data

  

  Once you open Column Actions, you can arrange your selected data in ascending or descending order. Simply click on either Sort Ascending or Sort Descending. This automatically sorts your values or text in a logical order. Arranging your data in alphabetical order makes it more organized and easy to follow. For example, databases and master lists should be organized, especially if the document contains a large amount of data.

• Step 4: Format the Data

  

  As seen in the example above, the names have been sorted out in chronological alphabetical order. After sorting the data, you can choose to further format or edit your spreadsheet. However, this last step is optional. You can change the font, text size, or even the table style using the paintbrush icon on the main toolbar.