Excel Office 365 Workbook Options – QUICK STEPS!!!
Tags: excelpreface, workbookoptions, exceltutorials
Published: 2020-12-11 03:36:38

---
title: Excel Office 365 Workbook Options – QUICK STEPS!!!
published: true
date: 2020-12-10 19:59:23 UTC
tags: ExcelPreface,WorkbookOptions,ExcelTutorials
canonical_url: https://geekexcel.com/excel-office-365-workbook-options/
---

In this post, we are going to see about **Workbook Options in Excel Office 365** with clear-cut steps and practical 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 New Workbook:

To [create a new workbook in Excel](https://geekexcel.com/simple-shortcut-to-create-a-new-workbook-in-excel-365/), follow the below-given ways.

- You need to **click** the **drop-down arrow** in the quick access toolbar.
- Then, it will open the **Customize Quick Access Toolbar menu** where you need to **select** the **New** option.

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

- The new button is added to the quick access toolbar and then **click it** to open the new worksheet.

![Click New button](https://geekexcel.com/wp-content/uploads/2020/12/Click-New-button.png)<figcaption id="caption-attachment-19264">Click New button</figcaption>

- In another way, you can **click** the **File tab.**

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

- **Choose** the **New** option from the menu and then, **double-click** on the **blank workbook.**

![Select Blank Workbook option](https://geekexcel.com/wp-content/uploads/2020/12/2-13.png)<figcaption id="caption-attachment-19266">Select Blank Workbook option</figcaption>

## Open an Existing Workbook:

If you want to [open an existing workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/), use the below three ways.

- **Way 1 –** You need to **find** your **workbook** and **double-click** on it.
- **Way 2 –** Go to the **File tab, select** the **Open** option. Then, **click** the “ **This**  **PC** ” option and find the existing workbook that you want to open.

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

- **Way 3 –** Alternatively, you can **click** the **Open** option and then **click** the **Recent** option, the latest opened or edited workbook will be shown at the right window.

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

## Save a Workbook:

Follow any one of the below methods to [save the workbook](https://geekexcel.com/shortcut-to-save-workbook-in-excel-365/) in Excel.

### Save option:

- You can directly **click** the **Save** button and click the [**CTRL + S**](https://geekexcel.com/shortcut-to-save-workbook-in-excel-365/) Keys to save the workbook.

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

- **Click** the **File tab, select** the **Save** option from the menu.

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

### Save As option:

- Go to the **File tab, click** the **‘Save As’** option.
- Then, you need to **double-click** on the “ **This PC** ” option.

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

- Now, you can **select** the desired **location path** and type the filename and then click the **Save button** to **[save the current workbook](https://geekexcel.com/how-to-save-your-workbook-in-microsoft-excel-365/).**

### Save with Password:

- To save a workbook with a password, you need to click the **File tab, select** the **Info** option, **click** the **Protect Workbook** option, then **select** the **Encrypt with Password** option.

![Encrypt with Password](https://geekexcel.com/wp-content/uploads/2020/12/5-11.png)<figcaption id="caption-attachment-19275">Encrypt with Password</figcaption>

- Then, **enter** the **Password** and **Reenter Password** and **click** the **OK** button.
- After that, try to **reopen** that **workbook**. You will be asked to enter the password in order to open the workbook.

### Autosave a workbook:

- To do this, **click** on the **File**  **tab** , **select** the **Options** option. It will display the **Excel Options Dialog Box**.
- You need to **click** the **Save** option and then **select the two checkboxes** “ **Save AutoRecover information every X minutes** ” and “ **Keep the last AutoRecovered version if I close without saving** ” to autosave a workbook.

![Excel Options window](https://geekexcel.com/wp-content/uploads/2020/12/Excel-Options-window.png)<figcaption id="caption-attachment-19276">Excel Options window</figcaption>

## Recover Workbook:

If you want to recover a workbook, follow the below instructions.

### Recover Unsaved Workbook:

- **Way 1 –** On the **File tab, select** the **Info** option, then **click** the **Manage Workbook** option and **select** the **Recover unsaved Workbooks** option.

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

- **Way 2 –** On the **File tab, select** the **Open** option, then **select** the **Recent** option.
- Then, you need to **click** the **Recover Unsaved Workbooks** button.

![Recover Unsaved Workbooks](https://geekexcel.com/wp-content/uploads/2020/12/6-11.png)<figcaption id="caption-attachment-19281">Recover Unsaved Workbooks</figcaption>

## Hide and Unhide a Workbook:

### Hide:

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

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

### Note:

- If the workbook contains only one worksheet, Excel doesn’t allow to hide the worksheet.

### Unhide:

- You need to **right-click** on any **Sheet tab,** then **select** the **Unhide** option.

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

- It will display the **Unhide window** where you need to **select** the **sheet** that you want to unhide and **click** the **OK** button.

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

## Close Workbook:

### Quit Excel:

- You need to **click** the **Close** button on the right top corner or **click** the **ALT+F4** keys.

![Click the Close button](https://geekexcel.com/wp-content/uploads/2020/12/8-7.png)<figcaption id="caption-attachment-19287">Click the Close button</figcaption>

### Quit Workbook:

- You can **click** the **File Tab,** then **choose** the **Close** option or **click** the **CTRL** + **W** keys to quit workbooks easily.

![File Tab](https://geekexcel.com/wp-content/uploads/2020/12/9-6.png)<figcaption id="caption-attachment-19288">File Tab</figcaption>

## Conclusion:

In the above article, you can easily understand the **Workbook Options in Excel Office 365** with clear-cut steps and practical examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!