| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximun number of rows and columns
I would like to know if the maximum number of rows and columns has increased
in Excel since version 2002 which has 65536 rows and 256 columns. Thanks in advance for any replys. Regards, OssieMac |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximun number of rows and columns
information from microsoft for excel 2007 (there was no change form office
2002 to 2003) The total number of available columns in Excel Old Limit: 256 (2^8) New Limit: 16k (2^14) The total number of available rows in Excel Old Limit: 64k (2^16) New Limit: 1M (2^20) -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "OssieMac" wrote: I would like to know if the maximum number of rows and columns has increased in Excel since version 2002 which has 65536 rows and 256 columns. Thanks in advance for any replys. Regards, OssieMac |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximun number of rows and columns
16,384 columns and 1,048,576 rows in Excel 2007 which should be enough!!
Mike "OssieMac" wrote: I would like to know if the maximum number of rows and columns has increased in Excel since version 2002 which has 65536 rows and 256 columns. Thanks in advance for any replys. Regards, OssieMac |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximun number of rows and columns
Thankyou John and Mike.
Regards, OssieMac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of Rows & Columns in a Named Range | Excel Discussion (Misc queries) | |||
| How do I change the number of columns and rows in a worksheet | Excel Discussion (Misc queries) | |||
| Number columns and rows in Excel, Example: C027R36 | Setting up and Configuration of Excel | |||
| number of columns/rows | Excel Discussion (Misc queries) | |||
| set number of rows equal in mutiple columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
