Results 1 to 5 of 5
  1. #1
    Member
    Join Date
    May 12th, 2006
    Posts
    174
    Is there a fast excel trick to Remove certain rows in one go?
    Ok i have a datafeed under the category column is

    Dj Mixers
    Dj Lighting
    Drum sticks
    Bass Guitar Effects

    I want to remove every row except Bass Guitar effects

    is there a quick way to do this?

  2. #2
    Network Rep & ABW Ambassador Carolyn - ShareASale's Avatar
    Join Date
    September 6th, 2005
    Posts
    2,664
    If you sort (located under the Data menu) ascending by category, all your Bass guitar effect products will be on top, then you could just delete what you don't need?

    If you hold ctrl+shift+arrow key, you'll be able to select the entire block of undesired categories in two clicks...does that help at all?
    best,
    Carolyn
    ShareASale Client Services
    Y!: SAS_CTang
    e: ctang(at)shareasale.com

  3. #3
    Member
    Join Date
    May 12th, 2006
    Posts
    174
    ill give it a go

  4. #4
    Member
    Join Date
    May 12th, 2006
    Posts
    174
    yeah that isnt working for me sorry..

    man there must be a way to say.. ok anything that has THis word in it.. remove that record

  5. #5
    Member
    Join Date
    May 12th, 2006
    Posts
    174
    took me a while but i figured it out.. pity there is no shortcut

  6. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Displaying Product Grids or Rows?
    By Snib in forum Midnight Cafe'
    Replies: 12
    Last Post: April 7th, 2008, 12:27 AM
  2. Excel "Drag outside selection to extend fill rows" help
    By prix in forum Programming / Datafeeds / Tools
    Replies: 0
    Last Post: February 8th, 2006, 07:53 AM
  3. Newbie Question - Rows and Columns
    By ktmkiddy in forum WebMerge (Fourthworld.com)
    Replies: 7
    Last Post: September 5th, 2004, 11:29 AM
  4. SUGGESTION: 40 rows instead of 20 in reports
    By MichaelColey in forum Rakuten LinkShare - LS
    Replies: 0
    Last Post: February 13th, 2004, 06:12 AM
  5. rows
    By cowox in forum Programming / Datafeeds / Tools
    Replies: 0
    Last Post: January 2nd, 2003, 01:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •