Are you saying that Excel acts as though there is information in 50,000 rows,
even though only 400 rows have data?

If that's the case, select the first empty row after your data and, while
holding down the shift key, press Ctrl-End. Now choose
Edit-Delete...-Entire Row

When done, save, close, and re-open your file. Your problem should be fixed.

"cms31" wrote:

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?