MAXIMUM Data Input in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know the approximate (or exact) limit of Excel for storing data?

I have heard the number 65,000 lines of data, but want to verify this number.

Thanks.
 
I guess you have never looked at a worksheet and done end +down arror to see
that, in the later versions, there are 65336 rows and 256 columns.
 
Fron Help "specifications" for workbook and worksheet specs.

65536 rows max

256 columns max

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL Maximum 2
Rebecca 2
Scrolling down my drop down box 4
Sorting a csv 2
How to have more than 65,000 rows in excel 2007 3
input file with more than 250000 lines 1
need more than 65,000 lines 6
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top