Results 1 to 4 of 4

Thread: Relace and Delete Question!

  1. #1
    New Member
    Join Date
    Jun 2011
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Relace and Delete Question!

    If I wanted to replace all the 456 items in the column below, then the delete blank rows where the 456 items were, what menu do I use?

    142
    996
    456
    123
    456
    226
    456
    225
    456
    Last edited by Bernard2; Sep 20th, 2019 at 07:26 PM.

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,194
    Post Thanks / Like
    Mentioned
    68 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Relace and Delete Question!

    If you want to delete the rows.
    - Select column
    - Autofilter
    - Fiter = 456
    - Now select all rows filtered
    - Press right mouse click on any cell of a selected row
    - In the menu select delete row.
    Regards Dante Amor

  3. #3
    New Member
    Join Date
    Jun 2011
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Relace and Delete Question!

    Quote Originally Posted by DanteAmor View Post
    If you want to delete the rows.
    - Select column
    - Autofilter
    - Fiter = 456
    - Now select all rows filtered
    - Press right mouse click on any cell of a selected row
    - In the menu select delete row.
    Got it! Thanks!
    Last edited by Bernard2; Sep 20th, 2019 at 08:42 PM.

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,194
    Post Thanks / Like
    Mentioned
    68 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Relace and Delete Question!

    Youre welcome!
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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