Insert Row & format as per other rows, above/below

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

Hi all, I have a report and i need to insert a row at a number to be given by
the user but i need the new row if put in at the bottem of the list to take
on the format of the row above it, any help would be appreciated.
 
Hi Les,
I would highlight the desired row, then copy. Select where you want the row
to be inserted, then use "Paste Special" instead of paste. Select the
"Format" radio button. See if it helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mid column sum formulas with varied ranges to sum 17
Changes in How Code Acts After Upgrade of Excel 2
Inserting new rows into sheet 2
DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Find Text and Insert Row Above 9
insert row at end of list 1
Keeping formulas on an insert 1
Insert Value into cell automatically when new rows are created/inserted 1

Back
Top