PC Review


Reply
Thread Tools Rate Thread

Copy Only Visible Cell

 
 
Robert Lie
Guest
Posts: n/a
 
      6th Sep 2005
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
 
Reply With Quote
 
 
 
 
Daveo
Guest
Posts: n/a
 
      6th Sep 2005
Hi Robert,

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

David

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy visible cells after filtered paste to first empty cell Xrull Microsoft Excel Programming 1 26th Jun 2008 03:39 PM
For Excel 2007 copy visible cell only is only thru for few number Frank Situmorang Microsoft Excel Programming 1 6th Jun 2008 07:12 AM
Copy hidden sheet and then make copy visible HELP? quidsin@gmail.com Microsoft Excel Programming 5 7th Aug 2007 02:31 PM
Copy to visible cell after Autofilter =?Utf-8?B?SGFuaw==?= Microsoft Excel Misc 4 6th Jul 2006 04:33 PM
By VBA , how to select the first visible cell (of first Visible row ) in filtered wor Amolin Microsoft Excel Misc 4 30th Jul 2004 12:41 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:31 AM.