Excel Office 365 Rows – [Insert, Delete, Hide, Unhide]
Tags: excelpreface, userowsinexcel, exceltutorials
Published: 2020-12-09 12:00:35

---
title: Excel Office 365 Rows – [Insert, Delete, Hide, Unhide]
published: true
date: 2020-12-09 11:58:18 UTC
tags: ExcelPreface,UseRowsinExcel,ExcelTutorials
canonical_url: https://geekexcel.com/excel-office-365-rows-insert-delete-hide-unhide/
---

Here, we will show you how to **Use Rows in Excel Office 365** with examples. Let’s see how to [Insert,](https://geekexcel.com/easy-shortcut-to-insert-rows-in-microsoft-excel-365/) [Delete,](https://geekexcel.com/simple-shortcut-to-delete-rows-in-microsoft-excel-365/) [Hide,](https://geekexcel.com/quick-keyboard-shortcut-to-hide-rows-in-ms-excel-365/) [Unhide](https://geekexcel.com/simple-shortcut-to-unhide-rows-in-microsoft-excel-365/) rows in the worksheet. 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)**
## Insert Row:

To [add a row](https://geekexcel.com/easy-shortcut-to-insert-rows-in-microsoft-excel-365/) in the current worksheet, follow the below steps.

- You need to **select a row** or **a cell** that you want to add a new column.
- The new column will be inserted above the selected row or cell. Here, we **select**  **cell A4**.

![Select a cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-a-cell.png)<figcaption id="caption-attachment-19122">Select a cell</figcaption>

- Now, you need to **right-click** on it and then **select** the **Insert** option from the menu.

![Select the Insert option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Insert-option.png)<figcaption id="caption-attachment-19123">Select the Insert option</figcaption>

- Then, it will open the **Insert window,** you need to select the **Entire row** option.

![Insert window](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Insert-window.png)<figcaption id="caption-attachment-19125">Insert window</figcaption>

- After that, **click** the **OK** button to get the result.

![Inserted Row](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Inserted-Row.png)<figcaption id="caption-attachment-19126">Inserted Row</figcaption>

## Delete Row:

You can [delete one row or multiple rows](https://geekexcel.com/simple-shortcut-to-delete-rows-in-microsoft-excel-365/) in the current workbook by doing the following steps.

- First, you need to **select a cell or row** that you want to remove.
- Here, we **select row**  **2**.

![select row 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-19.png)<figcaption id="caption-attachment-19127">select row 2</figcaption>

- Then, **right-click** on it and **click** the **Delete** option.

![Select the Delete option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/2-10.png)<figcaption id="caption-attachment-19128">Select the Delete option</figcaption>

- It will display the **Delete window,** you need to **select** the **Entire row** option and **hit** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/3-9.png)<figcaption id="caption-attachment-19129">Click OK button</figcaption>

- The selected row will be removed as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/4-9.png)<figcaption id="caption-attachment-19131">Result</figcaption>

## Hide Row:

To [hide the rows](https://geekexcel.com/quick-keyboard-shortcut-to-hide-rows-in-ms-excel-365/) from your worksheet, follow the below instructions.

- You need to **select the row** by clicking the row number that you want to hide.
- Here, we **select row**  **3**.

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

- You need to **right-click** on it and **select** the **Hide** option from the menu.

![Select the Hide option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Hide-option.png)<figcaption id="caption-attachment-19136">Select the Hide option</figcaption>

- Finally, you can see that the **selected row 3** has been **hidden** as shown in the below image.

![Hidden row](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/6-8.png)<figcaption id="caption-attachment-19137">Hidden row</figcaption>

## Unhide Row:

If you want to unhide a row in Excel, refer to the below instructions.

- You need to select the row that is hidden.
- Here, **row 3 was hidden** , and we are going to unhide it.

![Hidden row](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/6-8.png)<figcaption id="caption-attachment-19137">Hidden row</figcaption>

- To do that, **select row**  **2** and **row**  **4**.
- You need to **right-click** on it and **select** the **Unhide** option from the menu.

![Select the Unhide option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/7-5.png)<figcaption id="caption-attachment-19138">Select the Unhide option</figcaption>

- Now, you will see the hidden row has been unbidden as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/8-5.png)<figcaption id="caption-attachment-19139">Output</figcaption>

## Sizing Row:

If you want to change the height of the row in Excel, follow the below steps.

- You need to **select the row** that you want to change the height.

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

- Then, you need to **right-click** on it and **select** the **Row Height…** option from the menu.

![Select the Row Height option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/10-4.png)<figcaption id="caption-attachment-19142">Select the Row Height option</figcaption>

- It will display the **Row Height window** where you need to **enter** the **value** to increase the height.
- Then, **click** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/11-4.png)<figcaption id="caption-attachment-19143">Click OK button</figcaption>

- Finally, you will get the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/12-2.png)<figcaption id="caption-attachment-19144">Result</figcaption>

## Closure:

In the above article, you can easily understand the steps to **Use Rows in Excel Office 365** with examples. Don’t forget to share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Related Posts:

- [Excel Office 365 Print Options – [Simple & Quick Steps to Print]](https://geekexcel.com/wp-admin/post.php?post=18567&action=edit)
- [Excel Office 365 Protection Options – A Complete Guide!!](https://geekexcel.com/wp-admin/post.php?post=18484&action=edit)