Copy paste and delete rows based on a criteri
Closed
giovana
-
30 Apr 2009 à 14:06
adelara Posts 1 Registration date Tuesday 7 July 2009 Status Member Last seen 8 July 2009 - 8 Jul 2009 à 16:03
adelara Posts 1 Registration date Tuesday 7 July 2009 Status Member Last seen 8 July 2009 - 8 Jul 2009 à 16:03
Related:
- Copy paste and delete rows based on a criteri
- How to copy paste youtube link on android - Guide
- Based on the values in cells b77 b88 ✓ - Excel Forum
- Can't delete mail.com account - Internet & Social Networks Forum
- Can't delete snapchat account - Snapchat Forum
- How to delete a row in word - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday 11 April 2009
Status
Member
Last seen
21 June 2011
307
2 May 2009 à 04:05
2 May 2009 à 04:05
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
8 Jul 2009 à 15:56
I am using Office 2003 and hitting ctrl-g brings up the "Goto" box.
-Alex
8 Jul 2009 à 16:03
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