The Windows 10 scroll bar, which resembles a cutaway of an elevator shaft, rests along the edge of all overstuffed windows. You can even find a scroll bar along the side of an extra-long Start menu.
Excel 2016 Horizontal Scroll Bar Missing I opened an existing Excel file in Excel 2016 and I cannot get the horizontal scroll bar to appear at the bottom. I've maximized the spreadsheet and have done the 'view - arrange all' option.
Inside the shaft, a little elevator (technically, the scroll box) rides along as you move through the window’s contents. In fact, by glancing at the box’s position in the scroll bar, you can tell whether you’re viewing items in the window’s beginning, middle, or end.
By clicking in various places on the scroll bar, you can quickly view different parts of things. Here’s the dirt:
- Click inside the scroll bar in the direction you want to view. On a vertical scroll bar, for example, click above the scroll box to move your view up one page. Similarly, click below the scroll box to move your view down a page.
- The Start menu’s extreme right edge is a difficult-to-see scroll bar, but it appears when the mouse pointer is nearby. Slide the scroll bar’s box downward to view any shy apps hiding below the screen’s bottom edge.
- Don’t see a scroll bar or a box in the bar? Then you’re already seeing all that the window has to offer; there’s nothing to scroll.
- To move around in a hurry, drag the scroll box inside the scroll bar. As you drag, you see the window’s contents race past. When you see the spot you want, let go of the mouse button to stay at that viewing position.
- Are you using a mouse that has a little wheel embedded in the poor critter’s back? Spin the wheel, and the elevator moves quickly inside the scroll bar, shifting your view accordingly. It’s a handy way to explore a tile-packed Start menu, long documents, and file-filled folders.
Symptoms
One or more toolbars are missing and cannot be added in Microsoft Excel for Mac.
Cause
There are two possible causes of this behavior:
- The oval button in the upper-right corner of the document was clicked. This button 'toggles' the display of toolbars on and off.
- There is an issue with Excel preferences.
Resolution
To resolve this issue, use the following methods in order.
Method 1: Make sure that toolbar display is not turned off
- In the upper-right corner of the Excel window, click the oval button.NoteWhen this button is clicked, the toolbars are hidden (in any Microsoft Office for Mac application). A second click causes the toolbars to be displayed.
- If the toolbars reappear, quit Excel, and then restart Excel to make sure that the appropriate toolbars are displayed.
If Method 1 did not resolve the problem, try Method 2.
Method 2: Remove the Excel preferences
Step 1: Quit all applications
To quit active applications, follow these steps:
- On the Apple menu, click Force Quit.
- Select an application in the 'Force Quit Applications' window.
- Click Force Quit.
- Repeate the previous steps until you quit all active applications.
Warning
When an application is force quit, any unsaved changes to open documents are not saved.
Step 2: Remove the Excel Preferences
To remove the Excel preferences, follow these steps.
- Quit all Microsoft Office for Mac applications.
- On the Go menu, click Home.
- Open Library.NoteThe Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
- Open the Preferences folder. Click View, click Arrange by, and then select Name.
- Look for a file that is named com.microsoft.Excel.plist.
- If you locate the file, drag the file to the desktop. If you cannot locate the file, the application is using the default preferences.
- If you locate the file and move it to the desktop, start Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. Then, go to the next step. If the problem seems to be resolved, you can move the com.microsoft.Excel.plist file to the trash.
- Quit all Office for Mac applications.
- On the Go menu, click Home.
- Open Library.NoteThe Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
- Open the Preferences folder.
- Open the Microsoft Folder.
- Look for a file that is named com.microsoft.Excel.prefs.plist.
- If you locate the file, move it to the desktop. If cannot locate the file, the application is using the default preferences.
- If you locate the file and move it to the desktop, start Excel, and then check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. Then, go to the next step. If the problem seems to be resolved, you can move the com.microsoft.Excel.prefs.plist file to the trash.
- Close all Office applications.
- On the Go menu, click Home.
- Open Library.NoteThe Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
- Open the Preferences folder.
- Open the Microsoft Folder.
- Open the Office 2008 or Office 2011 folder.
- Look for a file that is named Excel Toolbars (12) or Microsoft Excel Toolbars.
- If you locate the file, move it to the desktop. If you cannot locate the file, the application is using the default preferences.
If you locate the file and move it to the desktop, start Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. If the problem seems to be resolved, you can move the Excel Toolbars (12) file or the Microsoft Excel Toolbars to the trash.
Note
If the problem still occurs after you follow these steps, the problem is not related to these files. If the problem no longer occurs, one of these files was causing the problem. If this is the case, restore the files to their original location one at a time. Test the application after you restore each file. Continue to do this until the problem occurs again. When the problem recurs, you can then assume that it is caused by the last file that you restored. Drag that file to the trash.