Pasting into merged cells in Excel 2010

Peter Collett

New Member
Joined
Mar 17, 2011
Messages
1
I'm using Excel 2010 and have a sheet with merged cells (needed as I need to have different cell widths for different groups of rows). If I paste into a single merged cell, all works fine, but if I paste into 2 or more merged cells the paste ignores the merge and pastes into each of the original unmerged cells. Is there a way around this?
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,109,543
Messages
5,529,456
Members
409,878
Latest member
DDhol
Top