Copy paste and delete rows based on a criteri
Closed
giovana
-
Apr 30, 2009 at 02:06 PM
adelara Posts 1 Registration date Tuesday July 7, 2009 Status Member Last seen July 8, 2009 - Jul 8, 2009 at 04:03 PM
adelara Posts 1 Registration date Tuesday July 7, 2009 Status Member Last seen July 8, 2009 - Jul 8, 2009 at 04:03 PM
Related:
- Copy paste and delete rows based on a criteri
- How to delete whatsapp account without login - Guide
- How to delete tabs on android - Guide
- How to delete whatsapp account without phone - Guide
- If i delete a conversation on viber will the other person see it - Guide
- How to delete multiple files on mac - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
May 2, 2009 at 04:05 AM
May 2, 2009 at 04:05 AM
Use autofilter to get all "OK" rows to be displayed
then select all these rows and press CTRL- G and then "SPECIAL" then "Visible cells only"
Then you can delete the "OK" rows
then select all these rows and press CTRL- G and then "SPECIAL" then "Visible cells only"
Then you can delete the "OK" rows
Jul 8, 2009 at 03:56 PM
I am using Office 2003 and hitting ctrl-g brings up the "Goto" box.
-Alex
Jul 8, 2009 at 04:03 PM
The "Goto" is kinda misleading, but clicking on "Special" on the bottom of the panel
brings several options to chose from... pick "Visible Cells Only".
-Alex