Worksheet Size

[TQ]

Hi,

1. Is that there is a limit coloum in one sheet ? A to IV & 1 to 65536 is
the maximun ? Can increase by any solution ?

2. How many sheets can have in one file ? Can increse sheets as many as
possible by any solution ?

Thanks !

 

[David Biddulph]

If you are using Excel 2003 or earlier, 256 columns by 65 536 rows is your
limit. Type "specification limits" into Excel help, or look at
http://office.microsoft.com/en-us/excel/HA101375451033.aspx.
Number of worksheets in a workbook is limited only by available memory. If
you want to insert a worksheet, use the command Insert/ Worksheet.

Excel 2007 increases the row & column limits to 16 384 columns by 1 048 576
rows:
http://office.microsoft.com/en-us/excel/HP100738491033.aspx?pid=CH101030621033#WorksheetWorkbook