Add more rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

remove excess (unwanted) rows from the bottom of a speadsheet 3
Auto extract data & inserts rows additional rows automatically 3
Import from Access?? 2
Filtering Multiple Areas on a Single Sheet 1
Pivot Table - include multiple worksheets with different ranges. 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How would I add a loop for this? 3
Macro/VB coding question 3

Back
Top