Excel® 2013 On Demand

Working with Tables

After you create a table, you can sort the entries, add new entries, and display totals. You can insert rows anywhere in a table or add rows at the bottom of the table. To add a blank row at the end of the table, select any cell in the last row of the table, and then press Enter, or press Tab in the last cell of the last row. If you no longer need the data in table form, you can convert the list back to normal Excel data. Selecting table rows and columns is different than selecting worksheet rows and columns. Selecting cells is the same.

Insert a Row or Column

Click a cell in the table where you want to insert a row or column. ...