Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet size | Excel Discussion (Misc queries) | |||
Size of a Worksheet | Excel Worksheet Functions | |||
Worksheet size reduction | Excel Discussion (Misc queries) | |||
worksheet size limit | Excel Discussion (Misc queries) | |||
worksheet size | Excel Discussion (Misc queries) |