Microsoft Excel Question:

Excel Limits and Specifications:

Tweet Share WhatsApp

Answer:

I need more than 256 columns and/or 65536 Rows.

In Excel 2003, and earlier versions, that's the limit. Excel 2007 has 1,048,576 rows and 16,384 columns.

How many worksheets I can put in a workbook?

It is not a limit per se, but of course there is a practical one which depends on the computer resources.

How many characters can be placed in a cell?

In Excel 97 and above, you can have up to 32K characters in a worksheet cell, but only the first 1000 or so are displayed (the exact number depends on your font and display characteristics). However, you can increase the number of characters displayed if you add line breaks in the cell (press Alt+Enter).

Download MS Excel PDF Read All 143 MS Excel Questions
Previous QuestionNext Question
How can I protect formulas from being deleted or changed?When I apply Fill pattern to a chart, it looks okay on the worksheet. However, the pattern disappears when I print the worksheet. Whats wrong?