Forum Discussion
Excel Tables
I am working on creating a workbook with multiple tables on multiple worksheets. On each worksheet, I have different tables above and below each other, as well as to the left and right or each other. When I attempt to add rows to individual tables, I receive an error message stating "This won't work because it would move cells in a table on your worksheet". I need to be able to have the multiple tables arranged this way on the sheets. Is there a way around this error message?
3 Replies
Greetings,
I feel that in 2013 and above version, it is easy. You just select any of the cell in a row in the table where you want to insert the row and just press short cut "Shift + Space" and then press "CTRL+Enter" key. It will work for you and insert the row in the selected table
Else you can right click on the cell in a table and select Insert and then Insert Row in Table Rows above.
Hope it works for you
Regards
Kapil Juneja
You may move another table temporary on another place (just select it and drag), add new rows/columns to first table and drag another table back.
In recent versions Excel moves data automatically.
