How to Delete Multiple Rows of Data in Excel Office 365?
Tags: deletemultiplerowsof, excelformula
Published: 2020-09-04 12:23:04

---
title: How to Delete Multiple Rows of Data in Excel Office 365?
published: true
date: 2020-09-04 11:41:17 UTC
tags: DeleteMultipleRowsof,ExcelFormula
canonical_url: https://geekexcel.com/how-to-delete-multiple-rows-of-data-in-excel-office-365/
---

## Delete Multiple Rows of Data in Excel:

In this guide, you will learn how to **Delete Multiple Rows of Data in Excel Office 365**. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)


## Delete Rows using Shortcuts:

- You can use this shortcut to quickly delete rows in Excel.
- Now, you need to select the row from which the below rows that need to be deleted.

![Select a row](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-23.png)<figcaption id="caption-attachment-13401">Select a row</figcaption>

- Now, you have to press ( **CTRL + SHIFT + ↓** ) Keys and then **click** the **Delete** button.

![Press Shortcut to select the rows](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-20.png)<figcaption id="caption-attachment-13402">Press Shortcut to select the rows</figcaption>

- Now, the selected rows are deleted quickly.

![Rows Deleted](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_HHCGGhyGsG.png)<figcaption id="caption-attachment-13410">Rows Deleted</figcaption>

From the above image, you can see that the data from **row 3** to **row 7** has been deleted.

In the same way, you can use the shortcut ( **CTRL + SHIFT + ↑** ) keys to select the rows that you want to delete in the **upward direction** from the **selected row**.

## Filter and then Delete Rows:

- In this method, first, you need to filter the data using the **Filter** option.
- You have to select the column or range of cells to apply filter.
- On the **Home** tab, **choose**  **Sort & Filter** option, then **select** the **type of sorting** option from the menu.

![Sort & Filter Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-8.png)<figcaption id="caption-attachment-13403">Sort &amp; Filter Option</figcaption>

- After sorting the data, apply a **filter** using the **Sort & Filter** option.

![Choose Filter Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/4-5.png)<figcaption id="caption-attachment-13404">Choose Filter Option</figcaption>

- Now, you need to **uncheck the data that you want to keep**. Then **click** the **Ok** button.

![Uncheck the data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/5-3.png)<figcaption id="caption-attachment-13405">Uncheck the data</figcaption>

- After doing the above step, you have to **select all the remaining rows.**

![Select All Rows](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Select-All-Rows.png)<figcaption id="caption-attachment-13406">Select All Rows</figcaption>

- Finally, **click** the **Delete** button to remove the selected multiple rows instantly.

## Summary:

In this post, you can clearly learn the steps to **Delete Multiple Rows of Data in Excel Office 365** with examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [How to Directly Print Data with Circle Invalid Data in Excel?](https://geekexcel.com/how-to-directly-print-data-with-circle-invalid-data-in-excel/)
- [How to Filter Cells by Text Length in Microsoft Excel 365?](https://geekexcel.com/how-to-filter-cells-by-text-length-in-microsoft-excel-365/)