Skip to content
Related Articles

Related Articles

How to Delete All Rows Below Certain Row or Active Cell in Excel?

View Discussion
Improve Article
Save Article
  • Last Updated : 02 Jun, 2022

Excel is powerful data visualization and data management tool which can be used to store, analyze, and create reports on large data. It is generally used by accounting professionals for the analysis of financial data but can be used by anyone to manage large data. Data is entered into the rows and columns.

Steps to delete all rows below a certain row in excel

For example, if we have values in 10 rows and we want to delete the data after 7 rows in excel.

Database

 

After deleting data after 7th row,

7-rows-deleted

 

We can perform this task using various methods; those methods are,

  1. Delete sheet rows option.
  2. With a Mouse Click to delete all rows below a Certain Row.
  3. Use the name box.
  • Method 1: Delete sheet row option

For the purpose of demonstration, we will use the table given below.

Database

 

Suppose we want to delete the row after the 8th row

Step 1: Select the cell A9

Selecting-A9

 

Step 2: Press CTRL+SHIFT+ ➜ + ⬇

selecting-content-to-delete

 

This will select all the cells that we want to delete.

Step 3: Go to Home Tab-> Cells Dropdown -> Delete Dropdown-> Delete Sheet Rows Option

Delete-sheet-rows

 

Output

Output

 

Method 2: With a Mouse Click to delete all rows below a Certain Row

In this method, steps 1 and step 2 will remain the same as we have used in method 1.

Step 1: Select the cell A9 

Selecting-A9

 

Step 2: Press CTRL+SHIFT+ ➜ + ⬇

Select-content-to-delete

 

Step 3: Right-click and select Delete-> sheet rows option

Deleting-sheet-rows

 

Output:

 

Method 3: Using Name Box

In this method, we will use the cell name to delete the rows.

Step 1: Go to the Name box area. You can find it just above the sheet cells.

Type-the-cell-name

 

Step 2: Type the range of rows to be deleted.

As we want to delete the 9th and 10th row, so we will mention the range as 9-10. This will select the rows to be deleted.

Step 3: Right click-> Delete-> Sheet rows.

Output

Output

 

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!