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
Note: kutools for Excel 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.
- It will open the View Options dialog box, you need to select the specifications that you want to apply to your workbook.
- 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.
- You will apply all the settings to all worksheets of the current workbook using the Apply to all sheets option.
- 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. Keep Learning!
Top comments (0)