How to Set Scroll Area (hide Unselected Columns & Rows) in Excel 365?
Tags: kutoolsexceltutorial, stepstosetscrollarea, kutools
Published: 2020-10-27 12:20:57

---
title: How to Set Scroll Area (hide Unselected Columns & Rows) in Excel 365?
published: true
date: 2020-10-27 12:08:43 UTC
tags: KutoolsExcelTutorial,StepstoSetScrollArea,Kutools
canonical_url: https://geekexcel.com/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](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.

## 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.

![Select a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-a-range-1.png)<figcaption id="caption-attachment-16309">Select a range</figcaption>

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

![Select Set Scroll Area option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Set-Scroll-Area-option.png)<figcaption id="caption-attachment-16311">Select Set Scroll Area option</figcaption>

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

<!--[if lt IE 9]><script>document.createElement('video');</script><![endif]--><video id="video-16305-1" width="770" height="301" loop="1" autoplay="1" preload="metadata" controls="controls"><source type="video/mp4" src="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Record.mp4?_=1"></source><a href="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Record.mp4">https://geekexcel.com/wp-content/uploads/2020/10/Record.mp4</a></video>

### 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.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Toggle All Hidden Sheets to be Visible or Invisible in Excel Office 365!!](https://geekexcel.com/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?](https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-365/)
- [How to Remove All Macros within Worksheet or Workbook in Excel?](https://geekexcel.com/how-to-remove-all-macros-within-worksheet-or-workbook-in-excel/)