![]() Here we are going to use it in a dataset of the Customer’s payment history with blank cells. The Find command is an Excel built-in option. Now press the ‘ Ctrl + –’ keys for the result.Select all the blank cells from the range.The keyboard shortcut is another easy way to remove blank cells. Keyboard Shortcut to Erase Blank Cells in Excel After clicking that, we can see the final result.ģ.Now go to Home > Delete > Delete Sheet Rows. ![]()
0 Comments
Leave a Reply. |