For many people who use excel as a preprocessing tool for huge data sets, they are required to select blank cells in a huge excel file. The following steps will help you select multiple blanks in the excel file.
- Edit -> Go To ( or ^G or F5)
- Click Special
- Choose Blank option
- Edit-> Delete
- Choose appropriate option (Entire row/column)
Please leave a comment if you find this link useful or if you have any other suggestions.
No comments:
Post a Comment