copy visable cells only

G

Gord Dibben

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
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
R

Ragdyer

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.
 
Top