Excel Office 365 Columns – [Insert, Delete, Hide, Unhide]
Tags: excelpreface, usecolumnsinexcel, exceltutorials
Published: 2020-12-09 12:00:32

---
title: Excel Office 365 Columns – [Insert, Delete, Hide, Unhide]
published: true
date: 2020-12-09 11:58:05 UTC
tags: ExcelPreface,UseColumnsinExcel,ExcelTutorials
canonical_url: https://geekexcel.com/excel-office-365-columns/
---

In this post, we will explore how to use Columns in Excel Office 365 with clear-cut examples. Let’s see how to [Insert,](https://geekexcel.com/simple-shortcut-to-insert-columns-in-ms-excel-365/) [Delete,](https://geekexcel.com/simple-shortcut-to-delete-columns-in-microsoft-excel-365/) [Hide,](https://geekexcel.com/simple-shortcut-to-hide-columns-in-microsoft-excel-365/) [Unhide](https://geekexcel.com/easy-keyboard-shortcuts-to-unhide-columns-in-excel-365/) columns 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 Column:

To [add a column](https://geekexcel.com/simple-shortcut-to-insert-columns-in-ms-excel-365/) in the current worksheet, follow the below steps.

- You need to **select a column** or **a cell** that you want to add a new row.
- The new row will be inserted on the left side of the selected column or cell. Here, we **select**  **cell B1**.

![Select a cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-a-cell-1.png)<figcaption id="caption-attachment-19157">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-1.png)<figcaption id="caption-attachment-19158">Select the Insert option</figcaption>

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

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

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

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

## Delete Column:

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

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

![Select a column](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-20.png)<figcaption id="caption-attachment-19162">Select a column</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-11.png)<figcaption id="caption-attachment-19163">Select the Delete option</figcaption>

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

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

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

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

## Hide Column:

To [hide the column](https://geekexcel.com/simple-shortcut-to-hide-columns-in-microsoft-excel-365/) from your worksheet, follow the below instructions.

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

![Select Column C](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/5-9.png)<figcaption id="caption-attachment-19166">Select Column C</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/6-9.png)<figcaption id="caption-attachment-19170">Select the Hide option</figcaption>

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

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

## Unhide Column:

If you want to [unhide a column](https://geekexcel.com/easy-keyboard-shortcuts-to-unhide-columns-in-excel-365/) in Excel, refer to the below instructions.

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

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

- To do that, **select column B**  and **column D**.
- 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/8-6.png)<figcaption id="caption-attachment-19172">Select the Unhide option</figcaption>

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

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

## Sizing Column:

If you want to change the width of the column in Excel, follow the below steps.

- You need to **select the column** that you want to change the width.

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

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

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

- It will display the **Column Width window** where you need to **enter** the **value** to increase the width.
- Then, **click** the **OK** button.

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

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

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

## Verdict:

In this post, you can easily understand the steps to **Use Columns in Excel Office 365** with examples. Kindly, share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!