ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copying visible merged cells (https://www.excelbanter.com/excel-discussion-misc-queries/204663-copying-visible-merged-cells.html)

rtwiss

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


Sean Timmons

Copying visible merged cells
 
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.

"rtwiss" wrote:

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



ShaneDevenshire

Copying visible merged cells
 
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.

--
Thanks,
Shane Devenshire


"rtwiss" wrote:

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




All times are GMT +1. The time now is 03:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com