Right click on the sheet tab of your workbook and choose View Code.
When the Visual Basic Editor window opens, look for the Sheet Properies
section (press F4 if it is not visible)
In Scroll Area, set the range to be $A$1:$N$500
Press the Xcel icon at top left of window to return to your sheet.

You will now be restricted to only entering data or scrolling within the
range A1 to N500


--
Regards

Roger Govier


"Sachin Narute" wrote in message
...
Hi all,
I want to use only 500 cells and A to N cells not ore than 500 cells.
i want to limit this no of cells.

Regards,
Sachin