On a Mac, as far as I know, Scroll Lock status will not appear in the status bar of Excel 2011. Once you make sure that the Scroll Lock status is on, look for the Scroll lock message in the lower left.
The Scroll Lock setting here doesn't control Scroll Lock, it only displays Scroll Lock status. Right click the status bar to make sure Scroll Lock status is enabled:
If Scroll Lock status is not enabled in the status bar, it might be toggled on and you'll never see it. On Windows, the status bar will display Scroll Lock if Scroll Lock is toggled on, and if the Scroll Lock status is enabled in the status bar. You can do this by working with the status bar, the name for the bottom edge of the Excel Window, which displays various information about the state of the current worksheet. Is Scroll Lock really on?įirst, make sure Scroll Lock is really enabled.
Scroll bars not showing in excel for mac how to#
The rest of this article explains how to do that on both Mac and Windows. The "trick" is to figure out how to send the equivalent of the Scroll Lock keystroke to Excel. Unfortunately, it's harder to disable Scroll Lock if your keyboard doesn't have a Scroll Lock key. If you have a Scroll Lock key on your keyboard, just press it to toggle Scroll Lock off. If you don't understand what's going on, this can be quite distressing :)įortunately, the Scroll Lock setting is a toggle, much like Caps Lock. The up and down arrow keys scroll one row up and down, and the right and left arrow keys scroll one column right and left.
However, when Scroll Lock is enabled, the worksheet is "scrolled" instead. Usually, the arrow keys will move you one cell at a time in whatever direction you wish. WTF?!īefore you panic, and call support to tell them Excel is broken, check to see if Scroll Lock has been accidentally enabled. You press the arrow keys, but instead of the cursor moving to another cell, the entire worksheet seems to be moving about. You're working along in Excel, things are going fine, when suddenly you notice that you can no longer move around properly. Step 2: Select the File tab at the top-left of the window.Your report is due in an hour. Other workbooks and new workbooks that you create will still have the scroll bars. This does not change the default setting for these scroll bars. Note that this setting only applies to the workbook that is currently open. The steps in this article were performed in the Microsoft Excel for Office 365 version of the program, but will also work in most newer versions of Excel as well. How to Hide the Horizontal and Vertical Scroll Bars in Excel Our tutorial below will show you where to find that option in Excel for Office 365. If you find that the scroll bars are getting in the way of your navigation, or if you are often clicking on them by mistake and moving the window view to the wrong part of the spreadsheet, then you might like to get rid of those scroll bars. Constantly having to scroll to see important information can get tedious, especially if the information you need to see is only a cell or two out of view. When you are working with a lot of data in an Excel spreadsheet, screen real estate becomes very important.
0 kommentar(er)
