Does Excel sheet has Line Limitation

[Aanand]

I am working on Excel sheet just passing an 15 digit number to the each cell, it is product ID which i need to enter,while doing this work i was curious to know the limit of each of column of an excel sheet, or it has no limit ? could we use any number or alphabet combination into each column of sheet, and what is pivot table in excel sheet? Thanks for your suggestions.

[Mecurtis]

As per my knowledge each excel sheet column has 65536 = 2^16 value storage limit. It is an historical addressing limit that has never been updated. I think is more than enough because in my whole experience i have never seen anyone has used this much value in its column.

[Ackley]

Following are the specification of each excel sheet.

Open workbooks-> Limited by available memory and system resources
Worksheet size-> 65,536 rows by 256 columns
Column width-> 255 characters
Page breaks-> 1000 horizontal and vertical
Length of cell contents (text)-> 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
Sheets in a workbook-> Limited by available memory (default is 3 sheets)
Colors in a workbook-> 56
Cell styles in a workbook-> 4,000
Named views (view: A set of display and print settings that you can name and apply to a workbook. You can create more than one view of the same workbook without saving separate copies of the workbook.) in a workbook Limited by available memory.