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

Dealing with the error: unable to filter on excel hc home school 0
Sharing workbooks limitations - Merged Cells 12
Page numbering with Merged Document and IF statements 1
Automatically color merged cells 1
Inserting rows 1
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Insert rows and keep merged cells in the inserted row 1
sorting two columns of merged cells 2

Top