Appending and Sorting a Data Table
Just as you would with the desktop version of Excel, you can insert a new row (or column) into your spreadsheet and fill in the necessary information, thereby adding data to your file. You can also create a table from your information to use the sort and filter tools.
Click a Row reference number to select it.
Click Insert Rows to add a new row above the selected row.
You can begin filling in the new information.
Drag through the cells with the completed information.
Click Sort & Filter as Table.
Confirm the range of your table and whether or not it has headers.
Your table has sort handles that let you use the sort options for a table. (See “Sorting Data in a Table” in Chapter 10, “Creating Charts, Data Tables, and Pivot Tables.”)