Scroll Lock Key on a Mac Posted in - Last updated Feb. 14, 2014 I am the king of random shortcuts and always seem to hit keys when typing that have unexpected consequences, such as this morning when I was doing something in Excel and managed to trigger scroll lock. But there's no scroll lock on a Mac keyboard. Excel and Scroll Lock When scroll lock is on and you use the arrow keys to navigate around a spreadsheet in Excel, it scrolls the sheet instead of moves the active selection to another cell.
This can be annoying when you were in the middle of navigating around the spreadsheet with arrow keys and then suddenly the sheet starts moving instead. The problem is scroll lock is on, and you need to switch it off again. Scroll Lock on a Mac Extended Keyboard A PC keyboard has a scroll lock key, but a Mac one doesn't appear to. If you are using an Apple Extended Keyboard it does, and the super secret scroll lock key is.
F14 I personally have the 'Use all F1, F2, etc. Keys as standard function keys' enabled in the system preferences, but found whether this was switched on or off that F14 on its own or FN+F14 would switch scroll lock on and off (on OSX Mavericks).
Mac Excel 2011 doesn't show scroll lock status anywhere. If Scroll Lock is on, your cursor moves between columns and rows, not cells. In Microsoft Excel, turning Scroll Lock on allows you to use the arrow keys to navigate your business spreadsheet without moving the cell that you have selected.
Scroll Lock on a MacBook Pro / MacBook Air / Wireless Keyboard I don't have an answer for this one, because the keyboard only has function keys from 1 to 12. I've done a fair amount of Googling for a solution but none of the shortcuts people have suggested work. Given there doesn't seem to be a scroll lock equivalent on these smaller keyboards, you're unlikely to be able to trigger scroll lock anyway, so hopefully don't have my random shortcut issue!
By 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 bar using the arrows at the right or bottom end, and you can click into the bar to change the control in specified increments. You can use scroll bars in a variety of ways. To make a scroll bar on a worksheet, take these steps: • 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 V alue: The number in the linked cell when the scroll bar is all the way to the left.
• Maximum V alue: The number in the linked cell when the scroll bar is all the way to the right. • Incremental C hange: The incremental number for how much the number increases or decreases as the scroll bar is moved. • Page C hange: 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. 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.