How to Toggle Workbook and Worksheet Settings in Excel Office 365?
Tags: kutoolsexceltutorial, stepstotoggleworkboo, kutools
Published: 2020-10-27 12:21:09

---
title: How to Toggle Workbook and Worksheet Settings in Excel Office 365?
published: true
date: 2020-10-27 12:02:37 UTC
tags: KutoolsExcelTutorial,StepstoToggleWorkboo,Kutools
canonical_url: https://geekexcel.com/how-to-toggle-workbook-and-worksheet-settings-in-excel-office-365/
---

In this article, we will discuss how to **Toggle Workbook and Worksheet Settings in Excel Office 365** using **Kutools.** 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)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## View Options Tool:

With the help of the **View Options** tool of Kutools, you can achieve the following tasks.

- You can easily set the **worksheet settings** such as grid lines, page breaks, row-column headers, display zero values, clipboard, selection pane, outline symbols, and formulas view.
- Using this tool, you can set the **workbook settings** such as sheet tabs, horizontal scroll bar, vertical scroll bar, and options.
- You can set **display settings** like status bar, formula bar, Inner tabs, comments, windows in Taskbar, and research pane.
- On the **Kutools Tab, select** the **Show & Hide** option, **choose** the **View Options** option from the drop-down menu.

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

- It will open the **View Options dialog box,** you need to **select** the **specifications** that you want to apply to your workbook.

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

- Then, you need to **click** the **OK** button.

### Note:

- If you want to restore the original settings in your Excel workbook, then **click** the **Restore defaults** option in the View Options Dialog box.

![Click Restore defaults option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Click-Restore-defaults-option.png)<figcaption id="caption-attachment-16327">Click Restore defaults option</figcaption>

- You will apply all the settings to all worksheets of the current workbook using the **Apply**   **to all sheets** option.

![Click Apply to all sheets option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Click-Apply-to-all-sheets-option.png)<figcaption id="caption-attachment-16328">Click Apply to all sheets option</figcaption>

- You need to activate the workbook before applying these settings.

## Verdict:

In the above article, you can clearly understand the steps to **Toggle Workbook and Worksheet Settings in Excel Office 365** using **Kutools.** Share your **feedback** in the comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Merge Adjacent Cells in Columns with Same Data/Value in Excel!!](https://geekexcel.com/merge-adjacent-cells-in-columns-with-same-data-value-in-excel/)
- [How to Clear All Formatting of a Range in Excel Office 365?](https://geekexcel.com/how-to-clear-all-formatting-of-a-range-in-excel-office-365/)