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.
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 |
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 word "Need" would be deleted without any new data to replace.
See more another tips:
- Ctrl+Shift+_ Excel Shortcut Erase The Selected Lines Border Of Cells
- Removes Unwanted Spaces Leading, Trailing And Between Words From The Text String
- VLOOKUP Searches For Value From Table Array In The First Column Return Value The Same Row
- Formula “LOOK UP - Array Form” Automatically Looks Approximate Match Values First Row/Column
- Formula “LOOK UP” For Using Approximate Match Values Sorted Ascending Order In a List
- Method of Extract the Specified Characters from the End of Text String Content
- How To Extract The Specified Characters From The Left Of The Text String In Active Cell
- Delete Unwanted Characters and or Blank Space From The Left Side Of Contents In Active Cell
- Removes Characters and Blank Space From The Right Side Of Contents In Cell | Xcel-Guru
- Excel Trick Expand Excel Column Width Fit To The Longest Data Entered
- Just Sing Along Blog | Song Lyrics In English-Thai Language
- [C+] Cell Phone and Accessory Review
- Learn Thai Free Online [LTFO] | Michael Leng
- Book-Hub | Best Seller Book Review
Comments
Post a Comment