By default the vertical scroll bar appears even if you open a blank workbook. If your worksheet has a large data then the horizontal scroll bar will help you to scroll up or down. If you feel comfortable navigating in the worksheet through keyboard then you may hide the vertical scrollbar. This action can be reversed and you can make the vertical scrollbar visible whenever needed by perform the following steps:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.
3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, under Display options for this workbook:, do one of the following:
To show the vertical scroll bar: Click to place a checkmark besides Show vertical scroll bar.
To hide the vertical scroll bar: Click to remove the checkmark besides Show vertical scroll bar.
5. Click OK.
Note:
The setting applies to the entire workbook.
1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.
3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, under Display options for this workbook:, do one of the following:
To show the vertical scroll bar: Click to place a checkmark besides Show vertical scroll bar.
To hide the vertical scroll bar: Click to remove the checkmark besides Show vertical scroll bar.
5. Click OK.
Note:
The setting applies to the entire workbook.
0 comments:
Post a Comment