In Excel worksheet, supposing, if there are some data that they are the same and filled in the multiple active cells. Then you want to delete all those same data from your worksheet. Yes, you can figure it out with a cool way as I am going to show as below method. Trick to delete the same data in multiple places: Press “Ctrl” “F” to display out the “Find & Replace” function box. Fill out the data to be deleted into the “Find” blank space (Here in the image below,"Before", is the word “Need” for example.) Click on the “Replace All” button. That’s all done. The word "Need" has disappeared as the second image,"After", beneath that is shown below. BEFORE AFTER How did it work? The "Find & Replace" is used for finding the data to be deleted and immediately replaced by any data as wanted. In this article, I just leaved the "Replace" blank space empty,-none data being filed out. Therefore, the wor
See way differential how to manage your Excel with more ease