infinite rows?
 

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!

infinite rows?
 

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

"Pauline" wrote:

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!