The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.
inserting a row into a table
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???
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
What is the significance of inserting the new table rows in a particular place? Why not insert at the end?
You can highlight the number of rows (in the table) you want to insert and right click and "insert rows". This will add the number of rows you need. Then paste data into the rows.
I get a message that says you cant rearrange cells within a table this way, because it might affect other table cells in an unexpcted wayOne thing you can do is to temporarily change it to a non-table, add the rows, and then turn it back into a table.
If you want to use VBA then try this workbook. I was unsure what you were cutting and I assume some row in the table.
29167299.xlsm
29167299.xlsm
Premium Content
You need an Expert Office subscription to comment.Start Free Trial