How to find the disappearance of Excel scroll bar under win7 system?

Excel must be familiar to everyone. This is an office software that office workers often use. In the process of use, some users of win7 system reported that the excel scroll bar disappeared and could not view more data. How to deal with it? Next, I'll explain to you the specific recovery method of Excel scroll bar disappearing under win7 system.

Recommended: win732-bit system download

The solution of Excel scroll bar missing;

1, open the Excel file, open the menu file-Options in turn, and enter the Excel option setting interface;

2. Select the advanced option, find the display option of this workbook in the right window (or press the shortcut key Alt+B), check the multiple boxes in front of "Show horizontal scroll bar" and "Show vertical scroll bar", and then confirm to exit the setting interface.

3. After setting the Excel options, check the worksheet. Normally, a scroll bar will be displayed in the worksheet.

4. If the scroll bar is still not displayed in the worksheet after setting the above Excel options, please select the menu to view and check whether "Protect Workbook" has been started.

5. Click "Protect Workbook", enter the password in the pop-up dialog box, and then confirm to cancel "Protect Workbook".

Here's how to find the disappearing Excel scroll bar in win7 system. If you encounter such a situation, you can take the above steps to operate, I believe it can help you.