Thread: Worksheet Size
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Worksheet Size

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/ex...375451033.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/ex...heetWo rkbook
--
David Biddulph

"TQ" wrote in message
...
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 !