Question

You are working on an excel table and realize that you need to add a row to the middle of your table. what is one way to do this? highlight the column, then click on the insert cells button under the home ribbon. highlight the cell, then click on the insert cells button under the home ribbon. highlight the row, then click on the insert cells button under the data ribbon. highlight the row, then click on the insert cells button under the home ribbon.

Answer 1

Highlight the row, then click on the insert cells button under the home ribbon.