Microsoft Excel Question:

How can I increase the number of rows or columns in a worksheet?

Tweet Share WhatsApp

Answer:

In Excel, every workbook has 255 columns and 65,526 rows. These values are fixed and cannot be changed. 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.

Download MS Excel PDF Read All 143 MS Excel Questions
Previous QuestionNext Question
Is there a function that returns the name of the worksheet?I have saved my workbook with a password, but Excel does not recognize it and would not let me open the file. Am I out of luck?