Delete non highlighted rows from Excel table

[ofobaidi]

Hi,
How to delete some non highlighted rows form an Excel table and keep only the rows with the highlighted (Blue cells) cells only.
Attached sample file.

Many thanks in advance.

 

[vletm]

ofobaidi
#1 write 0 to cell U1
#2 write 1 to U-column, write 1 to each row which is non highlighted
#3 filter U-column's all cells which has 1
#4 select all rows
#5 Delete Rows

#6 there will be all highlighted rows left
#7 if something unwanted happened then above can undo

 

[ofobaidi]

ofobaidi
#1 write 0 to cell U1
#2 write 1 to U-column, write 1 to each row which is non highlighted
#3 filter U-column's all cells which has 1
#4 select all rows
#5 Delete Rows
View attachment 78448
#6 there will be all highlighted rows left
#7 if something unwanted happened then above can undo

Hi,
Thank you for the solution, the solution is little bit long , I am looking for one step action.
Thank you.

 

[Marc L]

Hi, should be possible in two steps with a smart worksheet design where only a single colum should be 'blue highlighted'​

just using an Excel basics filter by color …​

According to your attachment layout you need one more step : filter by white color the 'main' column​

then filter again by white color the remaining column where you see some blue cell then you can delete the rows …​

​

 

[vletm]

ofobaidi
You've asked Ask an Excel Question-solution based Your sample file, then it will need more steps from You.