Deleting Non-Highlighted Cells

This post will guide you how to delete all of the non-highlighted cells in excel. How do I delete everything highlighted in excel 2013/2016. How to clear all cell contents based on background color in excel.

For examples, you have a spreadsheet worksheet that has highlighted rows of data, and you want to delete all the non-highlighted rows or cells in excel. And the highlighted rows or cell are also randomly scattered. How to quickly remove the cells non-highlighted in excel.

Deleting Non-Highlighted Cells


To removing all non-highlighted cells in excel, you just need to do the following steps:

#1 select the range of cells that you want to remove non-highlighted cells

deleting non-highlighted cells1

#2 go to DATA tab, click Filter command under Sort&Filter group.

deleting non-highlighted cells2

#3 click on one of the filter icons, and then click Filter by Color, select No Fill. Click OK button.

deleting non-highlighted cells3

#4 then you will see all cells without highlighted color will be filtered out.

deleting non-highlighted cells4

#5 select those cells, press Delete Key in your keyboard to remove all cells content.

deleting non-highlighted cells5

#6 click filter icons, and then click Clear Filter From “Date” from the popup menu list.

deleting non-highlighted cells6

 

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar