???? ID: 264626 - ????? ???????: 20 ??????? 2011 - ??????: 3.0 Excel 2000 ??????????? ?? ?????
?? ????? ?????????? ???? ????? Microsoft Excel 2000 ??????????? ?? ????? ???? ??:
???? ????????? Excel ??? ???????? ?? ?????? ???? ?? ??? ???? ?? ???? ???
?????? ?? ???, ???? 65,536 ?? ???? ?????????? ????????? ?? ?????? ????? ???? ?? ????? ?????????? ?? ????????????? ???????????
Feature Maximum limit
------- -------------
Open workbooks Limited by available memory and system
resources
Worksheet size 65,536 rows by 256 columns
Column width 255 characters
Row height 409 points
Length of cell 32,767 characters. Only 1,024 display in a
contents (text) cell; all 32,767 display in the formula bar.
Sheets in a workbook Limited by available memory (default is
3 sheets)
Colors in a workbook 56
Cell styles in 4,000
a workbook
Named views in Limited by available memory
a workbook
Custom number formats Limited by available memory
Names in a workbook Limited by available memory
Windows in a workbook Limited only by system resources
Panes in a window 4
Linked sheets Limited by available memory
Scenarios Limited by available memory; a summary report
shows only the first 251 scenarios
Changing cells in 32
a scenario
Adjustable cells 200
in Solver
Custom functions Limited by available memory
Zoom range 10 percent to 400 percent
Reports Limited by available memory
Sort references 3 in a single sort; unlimited when using
sequential sorts
Undo levels 16
Fields in a data form 32
Custom toolbars in Limited by available memory
a workbook
Custom toolbar buttons Limited by available memory
?????? ???????????
Feature Maximum limit
------- -------------
Number precision 15 digits
Largest allowed 9.99999999999999E307
positive number
Smallest allowed -9.99999999999999E307
negative number
Smallest allowed 1E-307
positive number
Largest allowed -1E-307
negative number
Length of formula 1,024 characters
contents
Iterations 32,767
Worksheet arrays Limited by available memory. Also, arrays
cannot refer to entire columns. For example,
an array cannot refer to the entire column
C:C or to the range C1:C65536. However, an
array can refer to the range C1:D65535
because the range is one row short of the
maximum worksheet size and does not include
the entire C or D column.
Selected ranges 2,048
Arguments in a 30
function
Nested levels of 7
functions
Number of available 329
worksheet functions
Earliest date allowed January 1, 1900 (January 1, 1904, if 1904 date
for calculation system is used)
Latest date allowed December 31, 9999
for calculation
Largest amount of time 9999:99:99
that can be entered
PivotTable ??????? ???????????
Feature Maximum limit
------- -------------
PivotTable reports Limited by available memory
on a sheet
Items in a PivotTable 8,000
report
Row or column fields Limited by available memory
in a PivotTable report
Page fields in a 256 (may be limited by available memory)
PivotTable report
Data fields in a 256
PivotTable report
Calculated item formulas Limited by available memory
in a PivotTable report
???????????????? ?? ????????????? ??????????? ?? ???? ??? ???? ??????? ?? ??? ????? ????Microsoft Excel ???????? ???????????, ??????Microsoft Excel ???????????Office ????? ?? ????? ????????, ?? ???? ?????????? ?? ??????
???? ?????? ??????????????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??. ?????????? ?? ??????? ????????? ??????? ??:264626
(http://support.microsoft.com/kb/264626/en-us/
)
| ???? ?????? ???? ?????? ??????
????????? ?????? ??????? ???????? ??????
|






Windows Live
Facebook
Twitter
Linkedin
Digg it
Yahoo
Delicious
StumbleUpon
Yammer
Reddit
Technorati
FriendFeed
Email

????? ?? ???? ????
