Delete blank rows using the “Go To Special” feature. First select the range of cells then press “Ctrl + G” to open the “Go To” dialog box. In the “Go To” dialog box, select “Special” and then select “Blanks.” This will select all the blank cells in the selected range. Once the blank cells are selected, press “Ctrl -“ to delete the selected rows.
#exceltipsandtricks
Watch video Remove Blank Rows in Excel! online without registration, duration hours minute second in high quality. This video was added by user Sara 20 January 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 25 once and liked it 1 people.