Copying visible merged cells

R

rtwiss

Does anyone know how to copy visible merged cells or a way around the problwm?
Not all cells and merged cell are same size.
 
S

Sean Timmons

Assuming you want to copy from one merged cell to another merged cell. You
can always go into the formula bar and copy the information, then paste into
the address bar in the destination.
 
S

ShaneDevenshire

Hi,

Here is another way to do this, although I prefer just copying from the
formula bar:

Select the cell below the merged cell farthest to the left and press Ctrl+'
(Ctrl and the apostrophy key) Then copy or move this to some other location.
 
Top