copy visable cells only
 

i've fitered to unique records only - how do I paste visable cells only?

copy visable cells only
 

press Ctrl + G then special and select Visible cells only


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=565516

copy visable cells only
 

Should be able to just select and copy/paste.

Excel will leave the non-visible rows.cells.

If not, F5SpecialVisible cells onlyOK

Copy and paste.


Gord Dibben MS Excel MVP


On Thu, 27 Jul 2006 03:41:02 -0700, paulajo
wrote:

i've fitered to unique records only - how do I paste visable cells only?

copy visable cells only
 

If you have filterd and are left with non-contoguous cells then you cannot
paste to visible cells only unless you are pasting a single value, because
you cannot paste multiple selections.

If you have filtered and want to copy what you see and then paste that to a
single polace then that works fine, and just use Edit / Go To / Visible
cells only, then copy and paste where you want.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"paulajo" wrote in message
...
i've fitered to unique records only - how do I paste visable cells only?

copy visable cells only
 

If you do this often, you can place an icon on your toolbar.

Right click in the toolbar and choose "Customize", then "Commands" tab.

In the left window click on "Edit",
Scroll almost to the bottom of the right window, and click on "Select
Visible Cells"
Drag it to your toolbar.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"paulajo" wrote in message
...
i've fitered to unique records only - how do I paste visable cells only?