The problem is, that the scroll bar on the right has so many rows, that it is
not useful for scrolling through the 400 rows of data that I have since that
is such a small portion of the entire workbook. When I hide rows, this does
not help the scrolling issue. I want to be able to somehow reset the
scrollbar so that the top is at row 1 and the bottom is at row 400 instead of
row 50,000. Do you know any way to do this?

"Gary''s Student" wrote:

Select the rows you do not want to see and hide them.
--
Gary''s Student


"cms31" wrote:

I have a file with about 400 rows of data, however 50,000 rows are displayed.
So it is difficult to use the scroll bars, as my data is a very small
portion of the entire workbook. How do I limit the display to show and
scroll only through my 400 rows?