inserting a row into a table

Patricia Timm
Patricia Timm used Ask the Experts™
on
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???
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Tom FarrarConsultant
Commented:
What is the significance of inserting the new table rows in a particular place?  Why not insert at the end?
Tom FarrarConsultant

Commented:
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.
Martin Liss"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
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 way
One thing you can do is to temporarily change it to a non-table, add the rows, and then turn it back into a table.
CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Martin Liss"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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
Roy CoxGroup Finance Manager

Commented:
You can add a ListRow like this.Say as Row 7

ListObjects(1).ListRows.Add 7

Open in new window

Finance Analyst
Commented:
I assume inserting at a particular place is to maintain a sort order.

As Tom mentions, place the new data at the bottom of the table, the table boundaries should expand automatically to include the new data, and then sort the the table by the relevant columns.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial