This tips aims to provide some information on the rationale of values ??(specifications and limits) apparently arbitrary under Excel:
- Why is there a limitation of 256 displayable characters in a cell and not 250 or 300?
- Why 16,384 columns in Excel 2007, and not 16,000 or 17,000?
"I'm faced with a limitation of 65,536 rows under Excel, but I do not understand the reasons for this limitation.. Could someone explain the logic behind?
A byte consists of 8 bits (binary digit: 0 or 1) and can be represented as 2 ^ 8 = 256 different values. Hence the restriction
- 256 ASCII codes
- 256 displayable characters in an Excel cell,
- 256 columns in Excel 2003, etc..
- With 2 bytes, or 16 bits, you can define 2 ^ 16 = 65536 values, number of rows in Excel 2003.
- With 14 bits, you can define 2 ^ 14 = 16384 values. This is the number of columns in Excel 2007.
- With 20 bits, you can define 2 ^ 20 = 1048576 values. This is the number of rows in Excel 2007.
In the Excel 2007 Help Topics go to the "Specifications and limits for spreadsheets and workbooks" chapter:
You shall notice that that most of these limitations are based on power of 2:
- 2 ^ 4 = 16 layers and line styles
- 2 ^ 5 = 32 styles, fields in a form
- 2 ^ 9 = 512 fonts for workbook
- 2 ^ 10 = 1024 page breaks
- 2 ^ 15 = 32767 characters stored in a cell.
It should be noted that Excel 2010 specifications are the same as the ones used for Excel 2007.
- Excel - Specifications and limitations of Sheets
- Excel copy data from one sheet to another automatically - How-To - Excel
- Excel copy rows from one sheet to another based on criteria ✓ - Forum - Excel
- Excel copy row to another sheet based on cell value ✓ - Forum - Excel
- Automatically transfer data from one sheet to another ✓ - Forum - Excel
- Excel move row to another sheet based on cell value without macro ✓ - Forum - Excel