- The Excel Web Application
- Opening Your Uploaded Project
- Revising Data in the Web Application
- Appending and Sorting a Data Table
- Opening Online Files Locally
- Printing an Excel Worksheet
This chapter is from the book
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.
)
Click a Row reference number to select it.
Click Insert.
Click Insert Rows to add a new row above the selected row.
You can begin filling in the new information.
Note: Sort Options in the Excel Web Application
The Sort options in the Excel web applications are not as extensive as on the desktop. You can sort the column in ascending or descending order and apply some basic filters under Text Filters.
)
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.
Click OK.
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.”)
Tip: Deleting Rows and Columns
You can click the Delete button in the Cells group to delete selected rows, columns, and cells and shift the remaining cells left (column) or up (row).