Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Does anyone know how to copy visible merged cells or a way around the problwm?
Not all cells and merged cell are same size. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data is not visible in merged and wrapped cells | Excel Worksheet Functions | |||
Copying merged cells | Excel Discussion (Misc queries) | |||
Copying and pasting to visible cells only | Excel Discussion (Misc queries) | |||
problem copying visible cells from 2000 to 2003 | Excel Discussion (Misc queries) | |||
Copying visible cells only on a protected worksheet | Excel Discussion (Misc queries) |