Limit Number of Rows

Hello,

My problem is that I'm creating an excel sheet to handle a large amount of data and requires data validations (lists). Is there any way to limit the number of rows in a worksheet so when I add a data validation to a column it doesn't go down to row 65,000(?)? I know I could simply select the rows in the column and add the validation, but it's going across a lot of columns and this would be somewhat time consuming.

So, in essence, I'd like the worksheet to only have ~5,000 rows, rather than 65,000. Hide doesn't work, as it still adds the data validations when I select the column. The standard VBA code won't help because it leaves when the workbook is closed.

Thanks!

Now looking at Excel 2010, it defaults to having 1,048,476 columns down.

The sheet I have requires decisions to be picked from data validation lists.

When I add the data validation lists to a column, I select the whole column and add. This adds data validations all the way down to row 1,048,476, which bogs down the spreadsheet, as several columns have data validation lists.

Is there any way to make it so the maximum number of rows is, say, 5,000? Rather than 1,048,476? That way, when I add a data validation rule to a column, it only goes down 5,000 rows, rather than the remaining million??