Microsoft Excel Question:

Download Job Interview Questions and Answers PDF

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

MS Excel Interview Question
MS Excel Interview Question

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 Interview Questions And Answers PDF

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?