inserting rows keeping the merged cells

S

Syd100

I would like to insert a row in a worksheet and keep all the format of the
row above. This includes where the cells have been merged. All the
formating remains except that the cells become individual and then have to be
merged. Any suggestions welcome
 
A

Allllen

copy the line above
select the line below
ctrl + to replicate the line above (all formats, formulae, values, merging)
press delete to remove formulae and values
 

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

Very long merged cells are only printed on 1 page 1
Make Autofit row height work with merged cells 2
move between unlocked cells on protected sheet 1
Merged Cells - Format, Column, Autofit 1
Sorting with merged Cells 1
How can I wrap text across merged cells? 2
Alternating cell shading colors for every other merged cell 1
How to Select a relative range with Using "Find" and Offset() 7

Top