Insert or Delete Rows and Columns in Excel Office 365!!
Tags: excelpreface, insertordeleterowsan
Published: 2020-09-03 03:53:22

---
title: Insert or Delete Rows and Columns in Excel Office 365!!
published: true
date: 2020-09-02 12:22:01 UTC
tags: ExcelPreface,InsertorDeleteRowsan
canonical_url: https://geekexcel.com/insert-or-delete-rows-and-columns-in-excel-office-365/
---

## Insert or Delete Rows and Columns in Excel:

In this article, we are going to explore how to **Insert or Delete Rows and Columns 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)



## Windows:

### Insert or Delete a Column:

To insert or delete a column in Excel, do as follows.

- You have to **select any cell** within the column, then on the **Home** tab, **Select**  **Insert** option it will open the menu.
- Then, you need to **choose the Insert Sheet Columns** option.

![Insert Sheet Columns](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-8.png)<figcaption id="caption-attachment-13191">Insert Sheet Columns</figcaption>

- To **delete sheet Columns** , On the **Home** tab, **choose the Delete** option, and then **select the Delete Sheet**  **Columns** option from the menu.

![Delete Sheet Columns](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-6.png)<figcaption id="caption-attachment-13192">Delete Sheet Columns</figcaption>

- You can also do another way to insert or delete a column. You have to **right-click** on the top of the column and then **click the Insert** or **Delete** option from the menu list.

![Right-click to insert or delete columns](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-2.png)<figcaption id="caption-attachment-13193">Right-click to insert or delete columns</figcaption>

- You can also use the [shortcut to Insert Columns in Excel](https://geekexcel.com/simple-shortcut-to-insert-columns-in-ms-excel-365/), which is ([**CTRL + Shift + +**](https://geekexcel.com/simple-shortcut-to-insert-columns-in-ms-excel-365/)).
- To [delete columns in Excel](https://geekexcel.com/simple-shortcut-to-delete-columns-in-microsoft-excel-365/) by using shortcuts, Press ( [**CTRL + –**](https://geekexcel.com/simple-shortcut-to-delete-columns-in-microsoft-excel-365/)).

### Insert or Delete a Row:

Let’s see some different ways to Insert or Delete a Row in Excel.

- You have to **select any cell** within the row, then on the **Home** tab, **Select**  **Insert** option it will open the menu.
- Then, you need to **choose the Insert Sheet Rows** option.

![Insert Sheet Rows](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/4-1.png)<figcaption id="caption-attachment-13195">Insert Sheet Rows</figcaption>

- To **delete sheet rows** , On the **Home** tab, **choose the Delete** option, and then **select the Delete Sheet**  **rows** option from the menu.

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

- You can also do another way to insert or delete a row. You have to **right-click** the row number and then **click the Insert** or **Delete** option from the menu list.

![Right-click to insert or delete rows](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/6.png)<figcaption id="caption-attachment-13197">Right-click to insert or delete rows</figcaption>

- You can use ( [**CTRL + Shift + +**](https://geekexcel.com/easy-shortcut-to-insert-rows-in-microsoft-excel-365/)) [Shortcut keys to insert rows](https://geekexcel.com/easy-shortcut-to-insert-rows-in-microsoft-excel-365/) in Excel.
- To [delete a row in Excel](https://geekexcel.com/simple-shortcut-to-delete-rows-in-microsoft-excel-365/), Press ([**CTRL + –**](https://geekexcel.com/simple-shortcut-to-delete-rows-in-microsoft-excel-365/)) keys.

### Formatting Options:

- If you applied formatting to the data in the Excel sheet, that formatting will be transferred to the new column or row which you want to insert.
- You can cancel this formatting by selecting the **insert options** button after inserting the rows and columns.
- To enable this option, On the **File** tab, Choose **Options** ,  and **Select Advanced** Option.
- Then, in the **Cut, Copy, and Paste** group, you have to **check the Show insert options button**.

## Web:

### Insert Rows:

To **insert a single row in Excel** , do as follows.

- You have to **Right-click the row number** , then **click** the **Insert Rows** option from the menu.

To **insert multiple rows in Excel** , do the below steps.

- You have to select the same number of rows above in that you want to add the new rows.
- Then, you need to **right-click** the selection and **choose Insert Rows**.

### Insert Columns:

To **insert a single column in Excel** , do as follows.

- You have to **Right-click on the column** , then **click** the **Insert Columns** option from the menu.

To **insert multiple Columns in Excel** , do the below steps.

- You have to select the same number of columns above which you want to add the new rows.
- Then, you need to **right-click** the selection and **choose Insert Columns**.

### Delete Cells, Rows, or Columns:

- You have to select the cell, row, or columns that you want to delete.
- Now, on the **Home** tab, **Select** the **Delete** Option, and **choose Delete Rows** , **Columns** , or **Sheet** option.

![Delete Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/7.png)<figcaption id="caption-attachment-13199">Delete Option</figcaption>

## Verdict:

In this article, you can clearly understand how to **Insert or Delete Rows and Columns in Excel Office 365**. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!