Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Does anyone know.....
how many rows does excel have? please let me no if u no...thx a bunch!x x x
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Does anyone know.....
Hi Aly
It depends on the version XL97 16384 XL 2000, XL2002 and XL2003 65536 XL2007 1 million -- Regards Roger Govier "aly" wrote in message ... how many rows does excel have? please let me no if u no...thx a bunch!x x x -- aly |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Does anyone know.....
XL97 16384
I think that you mean XL95 had 16384, my XL97 has 65536 rows -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Roger Govier" wrote in message ... Hi Aly It depends on the version XL97 16384 XL 2000, XL2002 and XL2003 65536 XL2007 1 million -- Regards Roger Govier "aly" wrote in message ... how many rows does excel have? please let me no if u no...thx a bunch!x x x -- aly |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Does anyone know.....
aly wrote:
how many rows does excel have? please let me no if u no Since that varies from version to version, the best way to find out for __your__ version is to use Help - Excel Help, search for "limits", and click on Excel Specifications and Limits. (At least, that works for Excel 2003.) |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Does anyone know.....
Quite right Sandy.
My memory is not as good as it used to be!!! and I was too darned lazy to fire up my copy of XL97 to check. -- Regards Roger Govier "Sandy Mann" wrote in message ... XL97 16384 I think that you mean XL95 had 16384, my XL97 has 65536 rows -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Roger Govier" wrote in message ... Hi Aly It depends on the version XL97 16384 XL 2000, XL2002 and XL2003 65536 XL2007 1 million -- Regards Roger Govier "aly" wrote in message ... how many rows does excel have? please let me no if u no...thx a bunch!x x x -- aly |
#6
|
|||
|
|||
Thanks! i checked and mine had 65536 rows too...i wanted to know because i am making a big spreadsheet and was wondering if it would all fit in. Many thank! Aly :D
Quote:
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Does anyone know.....
Hi Aly
If your model is anywhere approaching 65536 rows, then before starting I would think very hard about the design and whether you need to have such a large table. If you do, then you would be much better off using something like Access to handle this volume of records. -- Regards Roger Govier "aly" wrote in message ... Thanks! i checked and mine had 65536 rows too...i wanted to know because i am making a big spreadsheet and was wondering if it would all fit in. Many thank! Aly :D Roger Govier Wrote: Quite right Sandy. My memory is not as good as it used to be!!! and I was too darned lazy to fire up my copy of XL97 to check. -- Regards Roger Govier "Sandy Mann" wrote in message ...-- XL97 16384- I think that you mean XL95 had 16384, my XL97 has 65536 rows -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Roger Govier" wrote in message ...- Hi Aly It depends on the version XL97 16384 XL 2000, XL2002 and XL2003 65536 XL2007 1 million -- Regards Roger Govier "aly" wrote in message ...- how many rows does excel have? please let me no if u no...thx a bunch!x x x -- aly- - - -- aly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|