Excel Office 365 Worksheet Options ~ With Clear-Cut Examples!!
Tags: excelpreface, worksheetoptionsinex, exceltutorials
Published: 2020-12-11 03:36:54

---
title: Excel Office 365 Worksheet Options ~ With Clear-Cut Examples!!
published: true
date: 2020-12-10 20:33:53 UTC
tags: ExcelPreface,WorksheetOptionsinEx,ExcelTutorials
canonical_url: https://geekexcel.com/excel-office-365-worksheet-options/
---

In this tutorial, we will guide you to know the various **Worksheet Options in Excel Office 365** with clear-cut examples. 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)**
## Create a Worksheet:

If you want to [create a new worksheet](https://geekexcel.com/how-to-insert-sheet-in-microsoft-excel-365/) from the current workbook, follow the below steps.

- To create a new worksheet, you need to **click** the **Add** button.

![Add a sheet](https://geekexcel.com/wp-content/uploads/2020/12/Add-a-sheet.png)<figcaption id="caption-attachment-19300">Add a sheet</figcaption>

## Rename a Worksheet:

You can easily rename a worksheet using the following two ways.

- **#1)** – You need to **double-click** on the **Sheet tab.** Then, it is selected and marked with a background.
- Now, you can **rename** a worksheet.

![Click the Sheet tab](https://geekexcel.com/wp-content/uploads/2020/12/Click-the-Sheet-tab.png)<figcaption id="caption-attachment-19301">Click the Sheet tab</figcaption>

- **#2)** – On the **Home tab, select** the **Format** option in the **Cells** section. Then, you need to **select** the **Rename Sheet** option from the menu.

![Rename sheet](https://geekexcel.com/wp-content/uploads/2020/12/Rename-sheet.png)<figcaption id="caption-attachment-19302">Rename sheet</figcaption>

## Insert a Worksheet:

- To insert a worksheet, just **click** the ” **+** ” symbol near the sheet tabs.
- You can also **right-click** on the **Sheet tab,** and then **select** the **Insert** option from the menu.

![Insert option](https://geekexcel.com/wp-content/uploads/2020/12/Insert-option.png)<figcaption id="caption-attachment-19303">Insert option</figcaption>

## Copy a Worksheet:

- First, you need to **right-click** on the **sheet** that you want to copy.
- Then, **select** the **Move or Copy** option from the menu.

![Move or Copy option](https://geekexcel.com/wp-content/uploads/2020/12/Move-or-Copy-option.png)<figcaption id="caption-attachment-19306">Move or Copy option</figcaption>

- It will **open** the **Move or Copy window.**
- Under the **Before sheet** , choose where you want to place the copy. For example, if you wish to place a copy of **Sheet4** before **Sheet1** , you have to select the **Sheet1**.
- Then, you need to **check** the **Create**  **a copy** option and **click** the **OK** button.

![Move or Copy window](https://geekexcel.com/wp-content/uploads/2020/12/Move-or-Copy-window.png)<figcaption id="caption-attachment-19307">Move or Copy window</figcaption>

- Finally, you can see a copy of the selected sheet as shown in the below image.

## Move a Worksheet:

Follow the below method to move a worksheet in Excel.

- **Method 1 –**  **Place the cursor** on the sheet that you want to move and then **drag and release the cursor** to the required place.
- **Method 2 – Right-click** on the **sheet** that you want to move, then **select** the **Move or Copy** option.
- It will **open** the **Move or Copy window.**
- Under the **Before sheet** , choose where you want to move the sheet. For example, if you wish to move the **Sheet4** before **Sheet1** , you have to select the **Sheet1**.
- Then, **click** the **OK** button.

![Move or Copy window](https://geekexcel.com/wp-content/uploads/2020/12/1-23.png)<figcaption id="caption-attachment-19309">Move or Copy window</figcaption>

- Now, you can see that the selected Sheet4 is moved before Sheet1.

## Switch a Worksheet:

- You need to **right-click** on the **right arrow** near Sheet1.
- It will display the **Activate window,** then you need to **select** the **sheet** and **click** the **OK ** button.

## Change Background Color:

- To do this, **right-click** on the **Sheet1,** then **select** the **Tab Color** option,
- Now, you need to **select** the **color** that you want to apply as a background color.

![Select the color](https://geekexcel.com/wp-content/uploads/2020/12/2-14.png)<figcaption id="caption-attachment-19310">Select the color</figcaption>

## Hide & Unhide a Worksheet:

### Hide:

- You need to **right-click** on the **Sheet tab** and **select** the **Hide** option.
- Now, the selected worksheet will be hidden.

![Hide option](https://geekexcel.com/wp-content/uploads/2020/12/Hide-option-1.png)<figcaption id="caption-attachment-19311">Hide option</figcaption>

### Unhide:

- **Right-click** on the **Sheet tab,** then **select** the **Unhide** option from the menu.

![Unhide option](https://geekexcel.com/wp-content/uploads/2020/12/Unhide-option-1.png)<figcaption id="caption-attachment-19312">Unhide option</figcaption>

- It will open the **Unhide window.**
- Now, **select** the **sheet** and **click** the **OK** button.

![Unhide window](https://geekexcel.com/wp-content/uploads/2020/12/3-13.png)<figcaption id="caption-attachment-19313">Unhide window</figcaption>

## Delete a Worksheet:

- You need to **right-click** on the **Sheet tab**  and then **click** the **Delete** option from the menu.

![Delete option](https://geekexcel.com/wp-content/uploads/2020/12/4-13.png)<figcaption id="caption-attachment-19314">Delete option</figcaption>

## A Short Synopsis:

In this tutorial, we guided you to know the various **Worksheet Options in Excel Office 365** with clear-cut examples. Kindly, share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

## Related Articles:

- [Excel Office 365 Rows – [Insert, Delete, Hide, Unhide]](https://geekexcel.com/excel-office-365-rows-insert-delete-hide-unhide/)
- [Create a Combo Chart in Excel Office 365 ~ Simple Instructions!!](https://geekexcel.com/create-a-combo-chart-in-excel-office-365-simple-instructions/)