How to merge cells without pasting formatting?

excelos

Active Member
Joined
Sep 25, 2011
Messages
318
Hello!

I have merged cells A1-A3 and I want to drag this and merge B1-B3, C1-C3 etc.

However, dragging the + sign copies also the formatting, not only the merging.

Is there a solution?

Thanks!
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,099,508
Messages
5,469,030
Members
406,628
Latest member
jared92

This Week's Hot Topics

Top