Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,510
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,069
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,510
Default Maximun number of rows and columns

Thankyou John and Mike.

Regards,

OssieMac
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number of Rows & Columns in a Named Range Michael Excel Dude Excel Discussion (Misc queries) 0 September 3rd 06 11:05 PM
How do I change the number of columns and rows in a worksheet SteveK Excel Discussion (Misc queries) 2 October 27th 05 03:13 AM
Number columns and rows in Excel, Example: C027R36 Kezmaar Setting up and Configuration of Excel 1 July 12th 05 08:05 PM
number of columns/rows andrewm Excel Discussion (Misc queries) 1 July 10th 05 12:12 PM
set number of rows equal in mutiple columns speary Excel Discussion (Misc queries) 5 July 8th 05 12:27 AM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"