Maximum records in Excel

M

mmamin

Can anyone tell me the maximum records(rows) and variables (columns
allowed in Excel 2003, version.
Maybe this is repeat but i tried the search and came up with nothing.
Thank
 
J

JE McGimpsey

It is a repeat, and in the future you can find it in Help under
"Specifications".

Rows: 65,536
Columns: 256
 
N

Norman Jones

Hi Mmamin,
Can anyone tell me the maximum records(rows) and variables (columns)
allowed in Excel 2003, version.
Click to expand...

Rows 65536
Columns 256
Maybe this is repeat but i tried the search and came up with nothing.
Thanks
Click to expand...

Try looking in Excel Help for 'Specifications' .
 
N

Norman Jones

Hi Cadwan,
What if you need more than 256 columns? Can more columns be added?
Click to expand...

No, the row and column limits are invariable.

Perhaps, however, your application could use multiple sheets; alternatively,
you could consider changing the application's logic to transpose rows and
column.
 
A

Andy Wiggins

If you are that desperate for more than 256 columns you can always use
Quattro Pro (it also has a million rows!).
 
C

Cadwan

Tried transposing, but lost the visual clarity and required too much
horizontal (x-axis) display for vertical (y-axis) options. Thanks!
 
Top