Add more rows

F

FlyGirl

Is it possible to add more rows to a worksheet? We have an electoral roll
that contains over 65000 names and need to get the last 4000 records on. We
want to use filtering to locate by area and street quickly so want to use the
worksheet format.
Many thanks
 
J

JE McGimpsey

XL worksheets can only contain 65536 rows.

You could use two sheets, or, more appropriately, use a database
application (which you'll probably find much more responsive and less
prone to inadvertent errors than XL).
 
Top