filtering in a worksheet and then cut items out i lose unfiltered

R

Rhonitee

I filter in a worksheet to access specific rows I would like to cut and paste
into sheet 2. When i take the filter off to access the other information it
has been cut also. Why does this not work correctly.
 
S

Sheeloo

After filtering

Press F5 or Edit|Go To
Click on Special and select 'Visible Cells only'
Now if you Cut or Copy you will only filtered cells will be impacted...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Help 6
Cut & Paste in Excel without erasing cell borders? 1
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Cut and Paste Macro to new file 1
Getting no results from Advanced Filtering in Excel 2007 1
Short cut to refer a cell in diference worksheet 7
disable built-in menu and short-cut key for cut command 1
Cut-and-paste problem 1

Top