Thread: copy visable cells only

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

press Ctrl + G then special and select Visible cells only

Should be able to just select and copy/paste.

Excel will leave the non-visible rows.cells.

If not, F5>Special>Visible cells only>OK

Copy and paste.


Gord Dibben MS Excel MVP


On Thu, 27 Jul 2006 03:41:02 -0700, paulajo <paulajo@discussions.microsoft.com>
wrote:

>i've fitered to unique records only - how do I paste 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" <paulajo@discussions.microsoft.com> wrote in message
news:08312E86-98CB-4A71-85C7-69DDC22AB54E@microsoft.com...
> i've fitered to unique records only - how do I paste 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" <paulajo@discussions.microsoft.com> wrote in message
news:08312E86-98CB-4A71-85C7-69DDC22AB54E@microsoft.com...
> i've fitered to unique records only - how do I paste visable cells only?