microsoft excel shortcut keys delete row

To delete selected blank rows from the dataset.Įxecuting all the steps lead you to a similar picture depicted below.

⏩ Right Click on any selected Blank rows then Choose DELETE from the Context Menu. Go to Home Tab > Select DELETE (from the Cells section) > Click on Delete Sheet Rows. Step 3:Choosing Blanks in the Go To Special dialog box selects all the blank rows in the dataset.

🔄 Use CTRL + G keyboard shortcuts to bring out the Go To Special dialog box. In the dialog box, Select Blanks then Click OK. Step 2: The Go To Special dialog box appears. Step 1: Go to Home Tab > Select Find & Select (In the Editing section) > Click on Go To Special (from the options). In this case, Excel’s Go To Special feature works pretty well.

Selecting unused rows manually works with a small dataset, what if we have a lengthy dataset with numerous blank rows. Method 2: Using Go To Special Feature to Delete Unused Rows in Excel Read More: How to Delete Rows in Excel: 7 Methods The above two steps give you a result similar to the image below where all the unused rows get omitted. 🔄 Use Mouse Left Click then Select DELETE to delete unused or blank rows. Step 2: After selecting multiple unused rows, Right Click on any selected rows. 🔄 CTRL + Mouse Left Click to select multiple blank rows. You can select the entire row by clicking on the row headers. Step 1: Keep pressing the CTRL key then Click on the Blank Rows you want to delete entirely. In that case, we use the Context Menu to delete the manually selected rows. If we have a dataset of a handful of rows and it contains a few numbers of unused rows, we can easily use the manual method to delete unused rows. 8 Easy Ways to Delete Unused Rows in Excel Method 1: Using Delete Option from the Context Menu

Microsoft excel shortcut keys delete row