Relace and Delete Question!

Bernard2

New Member
Joined
Jun 15, 2011
Messages
38
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

<tbody>
</tbody>
 
Last edited:

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
9,717
Office Version
2007
Platform
Windows
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

New Member
Joined
Jun 15, 2011
Messages
38
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:

Forum statistics

Threads
1,085,911
Messages
5,386,714
Members
402,012
Latest member
Emi_d14

Some videos you may like

This Week's Hot Topics

Top