Hide and View Scroll Bars
By default, Excel displays horizontal and vertical scroll bars along the bottom and right side of the Excel screen, but you can hide them from view. If you want to increase the viewing area of the worksheet, hide the horizontal and vertical scroll bars.
Resize the Horizontal Scroll Bar
If the number of sheets in a workbook increases to the point that the names of all sheets cannot be read at one time, one way to fix this is to shrink the size of the horizontal scroll bar.
Fix the Vertical Scroll Bar Slider Range
The slider in the vertical scroll bar—the box that moves up and down the scroll bar—changes in size as the number of rows in a worksheet containing data changes. As the number of rows increases, the size of the slider decreases. If a worksheet has a small number of rows containing data, but the slider is very small and moving it causes the worksheet to jump up or down hundreds of rows, a row or a cell far down the worksheet may have been activated. To fix the problem, find and delete the row containing the last activated cell.
Find the Last Active Row
To find the last row in the worksheet containing a cell that has been activated:
Delete the Last Active Row
Since you can’t be sure that other rows have not been activated between the last row of good data and the last activated row, delete all rows below your data and the last activated row.
Check Before You Delete
Before deleting any rows, make certain that the last row of valuable data is the last row of valuable data, especially if the workbook is used by more than one person. It is not uncommon to hide data in a workbook, so do a thorough search before deleting any data.
Save the Workbook
After the rows are deleted, save the workbook. Until the workbook is saved, there will be no change in the size and behavior of the slider in the scroll bar.
