Can I paste data skipping the hidden cells ?

Can I paste data missing out cells that are hidden ?

Excel's paste does not skip hidden rows/columns.

--
Jim
"tclark67" <tclark67@discussions.microsoft.com> wrote in message
news:670D4A6F-1C57-4A11-AAB6-1190D2461EB3@microsoft.com...
| Can I paste data missing out cells that are hidden ?

Yes, you can ! ! !
Try activating the autofilter in the desired column, and selecting the (NonBlanks)
Then Select the entire column, Copy, and paste where you like, thats all ! !

Saludos

NlCO

It sounds like the OP want so paste into that filtered range (and skip the
hidden rows)--just about the opposite of what you suggested.



NlCO wrote:
>
> Yes, you can ! ! !
> Try activating the autofilter in the desired column, and selecting the
> (NonBlanks)
> Then Select the entire column, Copy, and paste where you like, thats
> all ! !
>
> Saludos
>
> NlCO
>
> --
> NlCO
> ------------------------------------------------------------------------
> NlCO's Profile: http://www.excelforum.com/member.php...o&userid=26123
> View this thread: http://www.excelforum.com/showthread...hreadid=397703

--

Dave Peterson