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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why no "insert copied cells"? 1
How to copy and paste only visible cells from Excel using vbscript 0
Copy and paste the cell boarder only not the content 3
I copied Visible Cells Only, but it pastes only the first cell 1
Inserting a Copied Row inside a table 6
Copying Row Code Doesn't Copy Conditional Formating 10
MACRO RUN random percentage and copy of column values 1
Advanced Filter Unique Records Only - treats dependent cells inconsistently 2

Top