How to Insert a Scrollbar in Excel

Next Video:
How to Add Payroll Hours & Minutes in Excel....5

Inserting a scrollbar in Excel can be a great way to make your document easier to navigate. Insert a scrollbar in Excel with help from a self-taught web developer in this free video clip.

Part of the Video Series: Basics of Microsoft Excel
Promoted By Zergnet


Video Transcript

Hi, I'm Christina Chiu, I'm a computer web specialist. And today, I'm going to show you how to inset a scrollbar using Microsoft Excel. So, we have our Excel right here, we have a dummy chart here, dummy table right here. So, to insert a scrollbar, we'll simply need the Developer tab in our ribbon. If you do not have the developer tab, simply click on File, Options. And inside Options, click on Customize Ribbon, choose from, just click on the scroll down button right here. All tabs, click on Developer, then click on Add and then, click on O.K., on the bottom right hand corner. So, now, developer tab, scrollbar is inside your Controls menu, so you need Insert first, so click on Insert. Then, click on your scrollbar right here, which is next the letters. Click on scrollbar and now, your scrollbar is in your spreadsheet. You can just change the size of it by selecting the corners to make it smaller, to make it bigger. And you can change the function of it by right clicking on it, then the format, Control and it'll bring up Format Controls here. So, there you go. And you will insert any values you like, inside and click on O.K. So, that is how you insert a scrollbar using Microsoft Excel. Thank you so much for your time, my name is Christina Chiu.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!