Unable to Add Row in Excel

Very likely there is no room for more rows, as your table already reaches the last possible row of the sheet. I assume you have selected the columns only when you defined your table, so the table already cover all of the lot-lot available rows. To solve this, go to Table menu, select "Resize Table", and make your table smaller covering less rows (the necessary ones only). Then you can add more rows with right-click.

It seems that by formatting the sheet as a table, Excel "filled-out" or instantiated all possible rows in the sheet. Thus, new rows cannot be added. Deleting empty rows allows me to add more rows where I want.

I was able to get it to work by (using Office 360):

1. typing the information on a row outside the table,
2. copying the row,
3. clicking on a row inside the table
4. right-clicking and choosing insert copied cells
5. applying the sort
6. deleting the original cells that had been copied

This is beyond beyond late, but I just fixed this issue on a formatted table. Rather than just clicking the top row of columns to select the data to include in your table, you need to select the specific range of rows as well. You can do this on an already formatted table by clicking Resize Table in the Table Tools ribbon, then click & drag from top left to the very bottom right of the whole data set you want to use. This prevents Excel from acting as if you've already included every empty cell below the ones you're actually using, and will then allow you to insert rows where you want them throughout the formatted data set.