Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 19-06-2009
Member
 
Join Date: Apr 2009
Posts: 89
Does Excel sheet has Line Limitation

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.
Reply With Quote
  #2  
Old 19-06-2009
Member
 
Join Date: Apr 2008
Posts: 193
Re: Does Excel sheet has Line Limitation

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.
Reply With Quote
  #3  
Old 19-06-2009
Member
 
Join Date: Dec 2008
Posts: 183
Re: Does Excel sheet has Line Limitation

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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Does Excel sheet has Line Limitation"
Thread Thread Starter Forum Replies Last Post
How to use Mail Merge from one Excel Sheet to another Excel Sheet Abélard MS Office Support 2 23-02-2012 02:59 PM
What is the use of time sheet in excel Chini mao MS Office Support 1 08-01-2012 04:35 PM
Is there any Fair Usage Policy or limitation with the reliance wire line connection? Kabilan India BroadBand 6 08-08-2011 10:41 PM
How to show sheet tab bar in excel 2010 RastogiJI MS Office Support 4 02-01-2011 07:24 AM
Fax an Excel sheet From a Computer Addis Tips & Tweaks 1 24-10-2008 01:03 PM


All times are GMT +5.5. The time now is 02:53 AM.