Adding a new row to a formatted spreadsheet

Patricia Timm
Patricia Timm used Ask the Experts™
I have included the file RC
I need to enter a new row into the spreadsheet in the purch-dpa AREA. the row will be a replica with the same columns only some of the data will change in the description and month. When adding the row should I copy one of the existing rows to keep the formatting and all other data? When I try to copy the row 128 and try to insert paste row it states this wont work because would move cells in a table on your worksheet.... Not sure how to add a row??? I need it in the purch-dpa section. thanks
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Rob HensonFinance Analyst

No attachment


I have edited my question and included an attachment. thanks Rob
What you can do is insert the row first and then copy a row into it.
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.


Did that - will it affect the rest of my worksheet .. shifting other tables on the sheet??? thanks
will it affect the rest of my worksheet
Depends on where the other tables are. If on the same row where inserted then yes otherwise probably no.
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
  1. Right click on the row just below where you want the new row
  2. Right-click copy
  3. Paste the copied row to the new, blank, row
  4. Change cells as necessary
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
I’m glad I was able to help.

If you expand the “Full Biography" section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange Most Valuable Expert (MVE) 2015, 2017
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2018
              Experts Exchange Top Expert VBA 2018
              Experts Exchange Distinguished Expert in Excel 2018

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