Excel is not a panacea, there are always limited in some areas people feel uncomfortable, so we see the friends he kept the forum in which there is no way to ask Excel to do the problem, but you ask me there is no question of non- asked refuses to give up the posture. Users to ask questions in order to avoid duplication and save everyone's time, I summarized the first few, I hope to inspire a friend read. Of course, there is definitely a place I did not write, just waiting for you to add.
A custom format, the conditions can not be more than three, but you can customize the Format Cells to 6 colors (borders, etc. can not be changed) http://www.excelhelp.net/cgi-bin/forum/topic.cgi? forum = 4 & topic = 1572 & show = 100. Other restrictions are: no input array constants can not copy and paste, can not change the conditions of the order
2 there is no way to add "Auto Format."
3 function can not be more than 7 levels of nesting (but can use "define name" method to lift restrictions on nested functions (http://club.excelhome.net/dispbbs.asp?BoardID=1&ID=41113), function up to 30 the number of parameters (also a breakthrough approach to http://club.excelhome.net/dispbbs.asp?BoardID=3&ID=37274)
4, the length of the name can not exceed 255 characters, the formula in cell character limit is 1024 characters.
5 EXCEL auto-fill, the median more than 11 character can not be automatically filled.
6, no way to insert animated GIF images. (However, in program development, or by reference to the control http://club.excelhome.net/dispbbs.asp?BoardID=2&replyID=33300&id=6531&skin=0 API clock to achieve http://club. excelhome.net / dispbbs.asp? BoardID = 2 & ID = 15676)
7 pairs of reference between workbooks only absolute references relative references can not be.
8 effectiveness of the reference must be a reference to a range of cells, can not use an array formula.
9, the text within a cell can set the color of the font, respectively, but there is no way to set the formatting within the same unit the distance between the two lines of text.
10 in a shared workbook, can not move cells, can not insert, can not sort the data involved can not be moved.
11 program manager in the program variable up to 32 cells, and in the "variable cell" in the formula will be entered into a number storage.
12 can not find the format brush and merge cells shortcut
Largest font size 13 font is 409 pounds, that is the biggest fight of about 10cm × 10cm size of the word.
AutoFilter list of 14 rows up to 1000 lines, but it does not mean there is no display can not be screened.
15 "combined" function you can only keep a portfolio and data.
Version of the difference in the restrictions: (Since my office is only 2000 and 2003, another version of excel would also like to provide test users)
1 inserted in the 2000 version of the picture can not do spin, 2003 spin in the tool bar, this tool
2 In the 2000 version on "The Chinese * Olympics" among such fields with * Screening of the problem appears incomplete. In the 2003 version is not the problem.
3 XP version of the following methods in the footer and header do not insert a picture.
42,000 or more versions can be branched cell formatting in the middle to achieve before, "Merge cells" can be achieved.