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 ! |
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