• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to limit the working area in Excel

0 Comments

How to limit the working area in Excel: Is the working space in Excel too large that you have to scroll far away from the current working area? There are several ways to limit the working area in Excel, which helps you focus on a specific working area and prevent the worksheet from drifting into other areas. This is also useful when you want to allow other people to view only a certain range of rows or columns in the worksheet. Let’s find out how to limit the working area in Excel in the following article.

Limit the scroll bar within the working area

By default, you can drag the scroll bar in the Excel interface far away. This may cause the data you are working on to drift away and be hidden from the Excel display. To limit the scroll bar to your working area, follow these instructions:

Step 1: In the worksheet that contains your working area, right-click on the current Sheet. Then select View Code from the displayed list. At this point, the Microsoft Visual Basic for Applications window will appear.

How to limit the working area in Excel

How to limit the working area in Excel

Step 2: In the Microsoft Visual Basic for Applications window, enter the working area you want to limit in the ScrollArea section on the left. The range to be limited includes column names and row names.

In the example below, the desired range to be limited is the range A1:E5. After entering it, the range you just entered will automatically change to a fixed array $A$1:$E$5.

How to limit the working area in Excel

How to limit the working area in Excel

Then close this window and return to the Excel interface. Try dragging the scroll bar to check. Now, the scroll bar moves, but even if it moves to the end, it will not exceed the data area you selected above.

How to limit the working area in Excel

How to limit the working area in Excel

Hide areas outside the working area

In addition to limiting the scroll bar as described above, you can also limit your working area by hiding areas outside it. To do this, follow these steps:

Step 1: Select the column immediately to the right of the working area.

How to limit the working area in Excel

How to limit the working area in Excel

Step 2: Press the Ctrl + Shift + → (right arrow key on the keyboard) combination to highlight the entire column of data to the right of the working area.

How to limit the working area in Excel

How to limit the working area in Excel

Step 3: Right-click on the highlighted area and select Hide from the drop-down menu. At this point, all columns to the right of the data area will be hidden.

How to limit the working area in Excel

How to limit the working area in Excel

Step 4: Continue to hide the rows below the working area. Similar to hiding columns, select the row directly below the working area you want to limit.

How to limit the working area in Excel

How to limit the working area in Excel

Then use the Ctrl + Shift + ↓ (down arrow on the keyboard) shortcut to highlight all the rows below the working area.

How to limit the working area in Excel

How to limit the working area in Excel

Next, right-click and select Hide to hide the selected rows. At this point, you have completed the process of hiding rows and columns outside of your working area. The result will be displayed as follows:

How to limit the working area in Excel

How to limit the working area in Excel

This is a guide on how to limit the working area in Excel. We invite readers to refer to and apply it in their work. We wish you success.

Rate this post
28
279 Views
Tip for easily deleting multiple Excel sheets at oncePrevTip for easily deleting multiple Excel sheets at onceMarch 24, 2023
How to quickly remove password from Excel fileMarch 24, 2023How to quickly remove password from Excel fileNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
Products
  • Buy Windows 11 Home CD Key Global Buy Windows 11 Home CD Key Global
    Rated 4.73 out of 5
    $6.00
  • Microsoft Visio Professional 2010 Key 1PC Microsoft Visio Professional 2010 Key 1PC $9.00
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows Server 2012 R2 Datacenter Key Global Windows Server 2012 R2 Datacenter Key Global
    Rated 4.71 out of 5
    $15.00
  • Kaspersky Total Security 2021 1 year 1 device key Global Kaspersky Total Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $27.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Windows 10 Pro Key Global Windows 10 Pro Key Global
    Rated 4.74 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Kaspersky Standard - 1 Device, 1 Year (Global License) Kaspersky Standard - 1 Device, 1 Year (Global License) $21.00
  • Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year $284.73
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.