May 17, 2018 Scroll lock is 'on' on my excel for Mac. Is there a proper way to scroll lock on and off in Mac? This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question (11). However, the Scroll Lock key is not only related to Microsoft Excel but I have never seen or used it in any other application. So this is why this tutorial is in Excel 2016 Playlist. First, you will get to know the key difference between scrolling through Arrow Keys and Scroll Bars.
Before we get started, take out a small screwdriver or key and pop off the F1, Scroll Lock, and Insert keys from your keyboard and store them in a safe place. You should never need them again, and you won't be a modeling bad-ass until you perform this critical step.
There are many Excel keyboard shortcuts, but we focus here only on those you might actually use and benefit from. In some cases there is more than one shortcut for a given action or command. Note that these shortcuts apply to Excel 2003 (Windows) and earlier, since most companies have not yet transitioned to a newer version. That said, many of these shortcuts work in Excel 2007 as well. While there are several shortcuts that can be used to apply number formats, these default formats are rarely suitable for use in professional-looking financial models.
Therefore, you won't find a discussion of these shortcuts here. You may want to install a third-party macro (or build your own) to create shortcuts for the custom number formats you require, if your employer has not already installed such a macro on your work computer. Each shortcut is assigned a 'utility', which represents the shortcut's time-saving potential and expected frequency of use on a scale of 1 to 5. Basic Shortcuts.
Alt Ctrl + Tab – Go to the first toolbar under the Control Menu. Pressing Ctrl + Tab again will take you to the second toolbar, and so on.
Use the right/left arrow keys to reach individual buttons on the toolbars and use the down arrow keys to access their drop-down menus. Press Enter to execute the selected action. Your toolbars should be arranged so that buttons you use most often (e.g. Font color) are on the left side of the toolbars to minimize the number of times you must press the right arrow key to reach them.