infinite rows?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pauline - 26 Sep 2006 23:25 GMT

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!

Reply to this Message

Carlo - 27 Sep 2006 08:16 GMT

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

> 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!

Reply to this Message