View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default Spreadsheet Limit

It depends on what version of Excel. See Help for "Microsoft Excel
specifications"

Excel 2007 permits up to 2^16=65536 columns and 2^20=1048576 rows
Excel 97 through 2004 permit up to 2^8=256 columns and 2^16=65536 rows
earlier Excel versions permit up to 2^8=256 columns and 2^14=16384 rows

Beyond these hardcoded limits, size is limited by available memory on your
computer.

Jerry

"Dennis1188" wrote:

I have a 3000 line spreadsheet with 10 columns.
Each cell in each column has a formula in it.
I would like to add 10 more column also with formulas.
Is there a limit to what excel can handle?