With Data Validation
Select all the worksheet (click the square where the row headers meet the
column headers; or use CTRL+A once or twice)
With everything selected: use Data Validation | Custom and in the dialog use
this formula
=ROW()<201
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Cassie" wrote in message
...
How do I format the spreadsheet to not allow data to be entered beyond a
specified row. I have a spreadsheet that I don't want data entered below
row
201. I haven't been able to find this on any of the help searches.
--
Cassie