how to stop scrolling

[mangesh]

hi everyone,

I have got an excell sheet. That sheet scrolls upto (column I) an
upto (rows 23) . I am sending this file for your reference, I jus
would like to know how to stop scrolling the sheet beyond a specifie
limit

Attachment filename: retirement_calculator.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62208

 

[Nick Hodge]

Mangesh

Right-click on the square between the column header for column A and the row
header for row 1. This should select the whole sheet. Now go to
Format>Row>Unhide and then Format>Column>Unhide

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Gord Dibben]

mangesh

You may want to try setting the Scroll Area.

This setting will not remain after closing the file.
Place a code line in the Workbook open event to set it
each time when you open the workbook

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A1:L23"
End Sub

Adjust to your sheetname and range.

Gord Dibben Excel MVP