- Charts
- Formula
- Printing
Increase the number of rows or columns?
Q. How can I increase the number of rows or columns in a worksheet?
In Excel, every workbook has 256 columns and 65,526 rows. Versions prior to Excel 97 have only 16,384. These values are fixed and cannot be changed. Despite what must amount to thousands of requests, Microsoft refuses to increase the size of a worksheet.
If you need more rows, you might want to consider using a database (such as Access) or another spreadsheet (Quattro Pro can handle a million rows) for data storage. In most cases, you probably don't need to work with all of your data at once. You'll usually need only a subset of your data. You can use Excel's Data, Get External Data command to query the database and bring in only the records you need.