Excel Limits and Specifications:
Submitted by: AdministratorI 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).
Submitted by: Administrator
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).
Submitted by: Administrator
Read Online Microsoft Excel Job Interview Questions And Answers
Top Microsoft Excel Questions
| ☺ | What are Excel Spreadsheet Number Formats? |
| ☺ | Using Excel is there a way to close all open Excel files at once instead of closing them one at a time? |
| ☺ | How do I combine different chart types into my Excel spreadsheet? |
| ☺ | In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format? |
| ☺ | How to Change the Sheet Tab Color of Excel Spreadsheets? |
Top Application Program Categories
| ☺ | AutoCAD Interview Questions. |
| ☺ | Microsoft Office Interview Questions. |
| ☺ | Microsoft Outlook Interview Questions. |
| ☺ | Microsoft Excel Interview Questions. |
| ☺ | MATLAB Interview Questions. |
