EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Scrollbar in Excel
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Scrollbar in Excel

By Jeevan A YJeevan A Y

Scrollbar in Excel

Excel Scrollbar (Table of Contents)

  • Scrollbar in Excel
  • How to Insert Scrollbar in excel?
  • Setting up a Scrollbar
  • How to Use Scrollbar?

Scrollbar in Excel

A scroll bar in Excel is just like the one you have seen at many places while using a computer system. This is a thin bar mainly displayed in most of computer applications to move the viewing area of computer applications, left and right or up and down. Based on the direction of movement, the scrollbar is of two types:

1. Horizontal Scroll Bar (Moves left and right)

Horizontal

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

2. Vertical Scroll Bar (moves up and down)

Vertical

How to Insert Scrollbar in Excel?

To create the SCROLLBAR in Excel, follow these steps:

You can download this Scrollbar Excel Template here – Scrollbar Excel Template

First, you need to enable the Developer tab visible on the ribbon so you can get to the VBA and the ActiveX control commands. To get the Developer tab, follow the below steps:

  • Click on the Excel option to bring up the Excel Options dialog box

Step 1

  • Click Customize Ribbon.

Step 2

  • Select the Developer Check box.

Step 3

  • Click on the Excel Ribbon, then select the Developer tab.

Step 4

  • Click on Insert, then click the SCROLLBAR control to insert the new list box in excels worksheet.

Step 5

  • After that, draw a rectangle in the excel worksheet to insert a ScrollBar.

If you will move the rectangle spread more horizontally, then the Horizontal Scroll Bar control will be inserted in Excel.

Step 6

If the rectangle is spread more vertically, then a vertical scrollbar will be inserted in Excel.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,813 ratings)

Step 7

Setting up a Scrollbar for a data set.

In this section, we will understand a few properties of ScrollBar.

After inserting the scroll bar based on the instructions explained in the previous section, just right click on the scroll bar and select the FORMAT CONTROL option:

SCROLLBAR Example 1-8

This will open a dialogue box as shown below:

SCROLLBAR Example 1-9

In the above box, there are the following options:

  1. Current Value: The scrollbar is always has a numeric value associated with it. The current Value field defines the current value of the scrollbar. Basically, it will define the current position of the scrollbar.
  2. Minimum Value: This defines the minimum position value of the scrollbar
  3. Maximum Value: This defines the maximum value possible of the scrollbar. The current value will always lie between the Minimum and Maximum Value.
  4. Incremental Change: This defines the number of values to be changed in one click movement of the scrollbar. If this is set to 1, if you click the down arrow of the scrollbar, its current value will increase by 1.
  5. Page Change: Provide the amount in Page change that the value increases or decreases and the degree to which the scroll bar moves if you click between the scroll box and any end arrow of a scrollbar. Let us take an example, in a scroll bar which has minimum value 0 and maximum value 10, if the user puts 2 in Page change property, the value of the scrollbar will increase or decrease by 2 (in the same case, 20% of the value range of the scroll bar) when you click the area between the scroll bar and any of the scroll arrows.
  6. Cell Link: This value will contain a cell name, which will hold the current value of a scrollbar. You will use this value in other formulas to respond to the positioning of the scrollbar. Because of the value in this cell now ill automatically get updated whenever you will move the scrollbar.

How to Use Scrollbar?

In the above section, we have seen how to insert the scroll bar and set up its parameters; now, we will create a simple, scrollable area from a larger data set.

Let’s just take an example of a simple data set of all 26 alphabets:

SCROLLBAR Example 1-10

If you create the above data set in an excel sheet, it will consume 27 rows (1 for heading and 26 for each alphabet).

But with the help of the scroll bar now, we will try to adjust the above data set into fewer rows. To do so, follow these steps:

  • Create a space where you would like to display the data set with a scrollbar:

SCROLLBAR Example 1-11

  • Click on the Excel Ribbon, then select the Developer tab.

SCROLLBAR Example 1-12

  • Click on Insert, then click the SCROLLBAR control to insert the new list box in excels worksheet near the newly formatted space where you would like to display the scrollable data, as shown below.

SCROLLBAR Example 1-13

  • Now right click on the scrollbar and select the Format Control option.

SCROLLBAR Example 1-14

fill following data for scrollbar parameters:

  1. Current Value: 0
  2. Minimum: 0
  3. Maximum: 16
  4. Incremental Change: 1
  5. Page Change: 2
  6. Cell link: Any empty cell (we are taking H1)

SCROLLBAR Example 1-15

  • Now in E2 cell type in the following formula:

SCROLLBAR Example 1-16

  • You can read more about the OFFSET formula later, but in Excel OFFSET function can be used when you want to get a reference that offsets the specified number of rows and columns from the starting point.
  • Now copy-paste the above formula in all cells of the desired area.

SCROLLBAR Example 1-17

  • This will make the value in cells updated each time you will move the scrollbar.

SCROLLBAR Example 1-18

Recommended Articles

This has been a guide to Scrollbar in Excel. Here we discuss basic concepts like inserting a scrollbar in Excel, using the scrollbar, setting up a scrollbar, practical examples, and a downloadable excel template. You can also go through our other suggested articles –

  1. Formula Bar in Excel
  2. Excel Toolbar
  3. Status Bar in Excel
  4. Excel Error Bar
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Scrollbar Excel Template

EDUCBA

Download Scrollbar Excel Template

EDUCBA

डाउनलोड Scrollbar Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more