how do I change default limits?

[Guest]

I'd like to set the limits of my worksheets to maybe 5 rows after the last entry, so that when I scroll to the bottom, I'm not scrolling to 65,000.

Is there a way to do this in Excel 2002?

Thanks,

 

[CLR]

One thing you can do is to simply "Hide" all the rows and columns you don't
want to see.........Highlight the unwanted rows, Right-click > choose
Hide..........then repeat for the unwanted columns..........then you can
adjust the column widths and row heights to fill the screen, if you
wish............

Vaya con Dios,
Chuck, CABGx3

I'd like to set the limits of my worksheets to maybe 5 rows after the last

entry, so that when I scroll to the bottom, I'm not scrolling to 65,000.

 

[JE McGimpsey]

In addition to hiding the rows, put this in your ThisWorkbook code
module (right-click the workbook titlebar and choose View Code):

Private Sub Workbook_Open()
With Sheets("Sheet1")
.ScrollArea = .Range("A1:A" & .Range( _
"A" & .Rows.Count).End(xlUp).Row + 5).EntireRow.Address
End With
End Sub

This will keep the user from scrolling