Copy Only Visible Cell

R

Robert Lie

Hi Everyone,

Is it posible to copy a block of cels with combined hidden collumn and
row to another sheet or cells without those hidden field to be copied ?

When i try to copy this kind of cells to another sheets/cells, excel
copy all cells including the hidden cells.

I just want to copy cels that is visible not including those hidden
cells, Is there a way around this ?

Thanks in Advance
 
D

Daveo

Hi Robert,

Select the desired range.
Click Edit - Go To.
Click Special then select Visible Cells Only then OK.
Copy the selected range.

David
 
B

Bruce Sinclair

Hi Robert,

Select the desired range.
Click Edit - Go To.
Click Special then select Visible Cells Only then OK.
Copy the selected range.
Click to expand...

Or you might be able to use auto filter to show just the rows you want. Then
you can simply copy/paste.


Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)
 
Top