Delete Blank Rows in Excel❕

Agenda of the Video▶️: To share steps of How-to Eliminate/Remove Blank Rows in a Excel Worksheet, using Go To Special (option).
------------------------------------------------------------------------------------------------------------------------------------------------------------------
✅(1) Select the Entire Worksheet (All Data of an Excel sheet).
Press Ctrl + G. This will navigate you to the Go To dialog box.
✅(2) Select “Special” from the Go To dialog box.
✅(3) Select the radio button “Blanks” from the Special option under the GoTo dialog box, and after that press OK.
This action will select all the Blank Rows within the Excel Worksheet.
OR,
Right-Click on any one of the selected rows.
✅(4) Select the “Delete” option from the available options list.
------------------------------------------------------------------------------------------------------------------------
Team Members are;
▶️Content Creator & Speaker, Amrit Kaur Saini.
▶️Editor & Publisher, Madhavi Pandey.
▫️▪️▫️▪️▫️▪️▫️▪️▫️▪️▫️▪️▫️▪️▫️