View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default How do I limit the number of rows displayed on a worksheet?

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?