動画検索
関連広告
検索結果
lot of Error in Data
Manual Method to Delete the Error
Select the Data Sets
Press Ctrl + G [Go to Special]
Click on Special
Select Formulas with errors
Now all such cells are selected
You can perform any action on all these cells. It can be deleted, or change color or any. Remember, not to select any cells further else above selection will be lost.