Hi I am trying to delete blank rows from multiple worksheets and I am not able to select blanks in all rows Though the cell has no value it's not identifying it as a blank cell. Previously the cell had formula (the 1st ,2nd and 5th coloumn) I and replaced with paste special values as only numbers. Attaching the screenshot for example. I want all the rows to be selected when I click on select blanks (instead of only 5 being selected). Any help is appreciated