Forum Discussion
Insert Rows grayed out
Note: I am very new to excel. When I right click on a row to insert that option is grayed out. It is also grayed out in the ribbon (home tab). When I go into options it is check marked as an opti...
Just in case anyone is in my situation... I was unable to insert a row in my sheet. It wasn't obvious, but it was because I had two tables side-by-side. If I selected a row in the sheet that spanned across both tables, then insert was greyed out. I had to do each table individually by highlighting a row in the table, right-click, and insert table row. In each table.