Excel For Mac Tutorial
Import Text Excel For Mac Scroll Bar Not Working

1 Rotate the Crosshairs in AutoCAD
2 Get a Checkbox Control Value in Word
3 Make a 3D Cylinder in PowerPoint
4 Create a Graph in Excel & Make It Relative in Size

A scroll bar control in a form made in Excel 2011 for Mac generates a number within a specified range, in set increments. The form user drags the scroll bar control left and right or up and down. As the user drags the control, the number increases or decreases. The form user can adjust the scroll. In the modern versions of Excel, you can unhide formula bar by going to the View tab > Show group and selecting the Formula Bar option. Show formula bar in Excel 2007 In Excel 2007, the Formula Bar option resides on the View tab > Show/Hide group. Show – This feature can be used to show or not show Formula bars, grid lines or Heading in the excel sheet. Zoom – Sometimes an excel sheet may contain lot of data and you may want to change zoom in or zoom out desired areas of the excel sheet. Ever wondered how to create an interactive Scroll Bar in Microsoft Excel? Instead of manually typing in a particular month or value, you can use the Scroll Bar control to select the months or values from a list, thus saving you time.

While Microsoft Excel is typically used to store and track data it also offers you a variety of tools to insert and edit objects. Among these features are form tools that enable you to create interactive forms. Popular form tools include radio buttons and check boxes but you may also add a scrollbar. In Excel the scrollbar control allows users to scroll through a list of pre-formatted values or text.

Launch Excel and open the spreadsheet to which you want to add a scrollbar. Click the “Developer” tab and locate the “Controls” section.

Click the “Insert” menu and select the “Scroll bar” option in the “Form Controls” section. The cursor will change to a plus sign (+). Click once in the area of the spreadsheet where you want the scrollbar to appear. The scrollbar will automatically orient vertically (up and down).

Click one of the sizing handles on the corners of the scrollbar and drag diagonally while holding down the mouse button to change the orientation to horizontal (left to right). Right click the scrollbar and select the “Properties” option, which will launch a separate window.

Type the minimum, maximum and current values for the scrollbar in the appropriate fields. Click the “OK” button.

About the Author

Cooper Temple has over 15 years of experience writing procedural and training material for a Fortune 500 company. His articles specialize in productivity programs and other business-related software. Html text editor for mac.

Cite this Article

Choose Citation Style

Temple, Cooper. 'How to Add a Scrollbar in Excel.' Small Business - Chron.com, http://smallbusiness.chron.com/add-scrollbar-excel-29980.html. Accessed 07 September 2019.

Temple, Cooper. (n.d.). How to Add a Scrollbar in Excel. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/add-scrollbar-excel-29980.html

Temple, Cooper. 'How to Add a Scrollbar in Excel' accessed September 07, 2019. http://smallbusiness.chron.com/add-scrollbar-excel-29980.html

Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.

You can use scroll bars in a variety of ways. To make a scroll bar on a worksheet, take these steps:

Excel For Mac Tutorial

While your form is unprotected, click the Scroll Bar control on the Developer Ribbon.
Drag diagonally and then let go of the mouse.
A scroll bar appears as selected on your worksheet.
Right-click the new scroll bar and choose Format Control from the pop-up menu.
The Format Control dialog displays.
On the Control tab of the Format Control dialog, set a cell link by clicking into the empty Cell Link field and then clicking a cell on any worksheet.
The linked cell is indicated in the Cell Link field in the dialog. This is where the results of the form user’s selection will display.
On the Control tab of the Format Control dialog, use spinner controls to adjust the following settings as desired:
- (Optional) Current Value: Set a default value. Displays the scroll bar’s current value if it has been changed on the form.
- Minimum Value: The number in the linked cell when the scroll bar is all the way to the left.
- Maximum Value: Similar to art text for mac. The number in the linked cell when the scroll bar is all the way to the right.
- Incremental Change: The incremental number for how much the number increases or decreases as the scroll bar is moved.
- Page Change: How much the value will change when a user clicks into the scroll bar itself, but not on the scrollbar’s drag button.
Click OK to close the Format Control dialog.

Import Text Excel For Mac Scroll Bar Not Working

Click the Lock Cells button to unlock the linked cell. The control won’t work when you protect the worksheet unless you unlock the linked cell.

Related Articles

About the Author

Choose Citation Style

Excel For Mac Tutorial

Import Text Excel For Mac Scroll Bar Not Working