Pasting into merged cells in Excel 2010

P

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?
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
You must log in or register to reply here.

Similar threads

S
  • Question Question
VBA Script to merge cells based on cell value
Replies
1
Views
175
Joe4
Joe4
D
  • Question Question
Merge based on cell content macro
Replies
7
Views
74
MARK858
MARK858
A
  • Solved
Sum of Row with Letters and Merged Numbers in Different Cells
Replies
3
Views
286
Joe4
Joe4
T
  • Solved
VBA Merging Cells Help Needed
2
Replies
12
Views
317
jolivanes
jolivanes
J
  • Question Question
Applying VBA to other cells
Replies
2
Views
470
NoSparks
N

Forum statistics

Threads
1,224,594
Messages
6,179,794
Members
452,943
Latest member
Newbie4296

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top