I have a worksheet formatted as a table. I was able to insert a row immediately prior to running into this issue, but now I cannot insert a row (right click+Insert is greyed out). Not sure what might have changed. Inserting columns works fine. Any guesses why this might be the case?
I'm using Excel 2010.
57 Answers
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.
2It 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):
- typing the information on a row outside the table,
- copying the row,
- clicking on a row inside the table
- right-clicking and choosing insert copied cells
- applying the sort
- 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.
1Final answer and I know it's late.
You formatted as a table and that eliminates insert. Convert to a range and it's back working and still holds the format.
1I found myself here after being unable to add a table row to a defined table area. In the context menu (right-click) I was offered to add "Entire sheet row", but that failed with an error "This won't work because it would move cells in a table on your worksheet"
None of other answers were right for me.
Turns out that it was just because a column filter was applied! Cleared the column-filter and I could add and delete table rows again.
Hello this is obviously too late, but of you have created a table in excel then you should be able to simple click on the cell above or below the row you want to inerst and then right click and select 'INSERT - TABLE ROW ABOVE'. Hope this helps.
1
