ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Worksheet Size (https://www.excelbanter.com/excel-discussion-misc-queries/169908-worksheet-size.html)

TQ

Worksheet Size
 
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[_2_]

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 !





All times are GMT +1. The time now is 05:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com