Relace and Delete Question!

[Bernard2]

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?

<tbody>
[TD="class: xl22"]142[/TD]

[TD="class: xl22"]996[/TD]

[TD="class: xl22"]456[/TD]

[TD="class: xl22"]123[/TD]

[TD="class: xl22"]456[/TD]

[TD="class: xl22"]226[/TD]

[TD="class: xl22"]456[/TD]

[TD="class: xl22"]225[/TD]

[TD="class: xl22"]456[/TD]

</tbody>

 

[DanteAmor]

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.

 

[Bernard2]

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!

 

[DanteAmor]

Youre welcome!