![]() This will bring up a list of all the blank cells found in the selected range at the bottom of the Find menu. Press the Find All button to return all the blank cells.Select the Match entire cell contents option.Expand the Advanced options in the Find menu.Press Ctrl + F on the keyboard.Įither way, this will open up the Find & Replace menu for us. There is also a keyboard shortcut we can use to open the Find menu. Go to the Home tab ➜ press the Find & Select command ➜ choose Find from the menu. Just like before, we need to select a column in our data. The only difference is we will select our blank cells using the Find command. ![]() This method is going to be very similar to the above Delete Blank Rows Using Go To Special method. This is especially nice when we have a lot of blank rows scattered across a long set of data. Like magic, we can find and delete hundreds of blank rows in our data within a few seconds.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |