Here I can select "Blanks" or use the keyboard shortcut Alt + K: This will take me to the Go To Special dialog box.
I can then click on "Special" or use the keyboard shortcut Alt + S. To delete the blank rows, I first highlight any column that contains blanks (in this case any one will do), then hit the F5 key which brings up the Go To dialog box: Here I have data with blank rows scattered throughout: Watch the video to see how that is done.įor deleting blanks, the process is just slightly different. If the data was transposed and the names were across the top, you can use the same process, but choose "Entire column" instead. …and when I click OK, all the rows containing "Tom" have been deleted:
#How to delete rows with blank cells excel plus
Next, I can use the keyboard shortcut Ctrl + – (the Ctrl key plus the minus sign on the keypad), and it will bring up the Delete dialog box. Now I can close the Find & Replace dialog box and those cells still remain selected. Notice it will highlight all the cells in my data set that contain "Tom": With the top one already highlighted, I will hold down my Shift key, and click on the bottom one to select them all. This will generate a list of hyperlinks that reference every cell that contains "Tom".
I will highlight the data in column "A", then use the keyboard shortcut Ctrl + F to bring up the Find & Replace dialog box, and enter "Tom" in the search box, then click Find All: Notice that the name "Tom" appears six times and I want to delete all the rows that have "Tom" in that column: So here I have a data set and in column A there are the names of various people. When you get a preview, look for Download in the upper right hand corner. You can download the file here and follow along.
#How to delete rows with blank cells excel how to
In this tutorial we are going to look at how to delete rows or columns that either have a certain criteria or that are blank.
0 kommentar(er)
