Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

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.

start.jpg

circle-01.jpg Click a Row reference number to select it.

circle-02.jpg Click Insert.

circle-03.jpg Click Insert Rows to add a new row above the selected row.

circle-04.jpg You can begin filling in the new information.

circle-05.jpg Drag through the cells with the completed information.

circle-06.jpg Click Sort & Filter as Table.

circle-07.jpg Confirm the range of your table and whether or not it has headers.

circle-08.jpg Click OK.

circle-09.jpg 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.”)

end.jpg
  • + Share This
  • 🔖 Save To Your Account