I want insert a row into a table on an excel spreadsheet. I am cutting the row and placing in new row from row 511 to row 534. I do not want to overwrite the rows just insert the cut row. when I cut the row and go to insert cut cells ... I get a message that saysyou cant rearrange cells within a table this way, because it might affect other table cells in an unexpcted way. So I have to insert a row where I want the cut cells to go... then go to the row and cut then paste in the inserted row... Seems like alot of work... Ideas on ways to make easier???
Our community of experts have been thoroughly vetted for their expertise and industry experience.