Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding rows while sheet is protected | Excel Discussion (Misc queries) | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
Automatically inserting rows | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |