Cut and Paste Hidden Rows

**cybercab** · 10-10-2007, 05:52 PM

I have some hidden rows. But I want to Cut and Paste just what I see. But it pastes the hidden rows too. Is there a way to make it paste only what I see? Thanks.

C.

**tuph** · 10-10-2007, 06:41 PM

If you are able to use autofilter to eliminate the hidden rows, cut and paste will work as you want.

**Paul** · 10-10-2007, 07:46 PM

Another option is to use the GoTo dialog.

Select the visible range you want to copy
Press F5
Click 'Special...'
Select 'Visible Cells Only'
Click OK

You can then copy and paste just the visible cells that are selected.

**tuph** · 10-11-2007, 12:06 AM

Originally Posted by pjoaquin

Another option is to use the GoTo dialog.

Select the visible range you want to copy
Press F5
Click 'Special...'
Select 'Visible Cells Only'
Click OK

You can then copy and paste just the visible cells that are selected.

Cool! Thanks a lot, Paul.