Try F5SpecialVisible cells only and OK.

The button/icon is located in ToolsCustomizeCommandsEdit.

Scroll down to the bottom to find it.

Move it up to your Toolbar if you wish.


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 14:25:04 -0800, jfkosu
wrote:

When I try to copy just the visible cells after I have subtotaled, it pastes
all the details even when I paste special (just values). SOmeone told me
there is a view/copy visible cells icon but I can't find it.
Thank you