How to Set Scroll Area (hide Unselected Columns & Rows) in Excel 365?

In this post, you will learn how to Set Scroll Area in Excel Office 365 using Kutools. ** You can easily hide unselected columns and rows which are not useful to you in the worksheet. Let’s get into this article!! 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.

Instructions to Set Scroll Area:

To do this, follow the below instructions.

• You need to select a range that you want to set as a scroll area as shown in the below image.

• Go to the Kutools Tab, select the Show & Hide option, choose the Set Scroll Area option from the drop-down menu.

• Now, you will get the scroll area as shown in the below video.

<!--[if lt IE 9]>document.createElement(&#39;video&#39;);<![endif]-->

Note:

• If you want to remove the scroll area, you need to select Unhide All Ranges from Show & Hide section.
• This utility supports one level Undo.
• You can select entire rows or columns to set the scroll area, but a scroll area cannot consist of multiple non-contagious ranges.
• To manually remove by right-clicking any row or column name and select the unhide option to unhide them.

Closure:

From this post, you can quickly understand the steps to Set Scroll Area in Excel Office 365 using Kutools. If you have any Queries/feedback , then leave it in the below comment section. Thanks for visiting Geek Excel. Keep Learning!

Read Also:

• Toggle All Hidden Sheets to be Visible or Invisible in Excel Office 365!!
• How to Insert a Date or Formatted Date in Excel Office 365?
• How to Remove All Macros within Worksheet or Workbook in Excel?