Topics

Feb 10, 2011

Show or hide horizontal scroll bar in Excel 2007

By default the horizontal 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 to the right or left. If you feel comfortable navigating in the worksheet through keyboard then you may hide the horizontal scrollbar. This action can be reversed and you can make the horizontal 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 horizontal scroll bar: Click to place a checkmark besides Show horizontal scroll bar.
    To hide the horizontal scroll bar: Click to remove the checkmark besides Show horizontal scroll bar.
5. Click OK.

Note:
The setting applies to the entire workbook.

0 comments:

Post a Comment