infinite rows?

  • Thread starter Thread starter Pauline
  • Start date Start date
P

Pauline

Is there a way to limit the number of rows on a worksheet? I am able
to use the mouse roller to scroll down apparently infinitely. I'd like
to limit the number of rows on my sheet, if possible, so that users can
know when they've reached the end. Please advise!
 
Hi Pauline

actually there is a limitation of rows in excel => there are 65536
(in Excel 07 there will be a lot more! )

if you want the user to just see the first 100 rows you could hide
the other rows.

Hth Carlo
 
Back
Top