Problems that Excel cannot do

Any software has a dead end, every software programmer wants to do this software can be universal. But every person with software wants to use the software to be very suitable for themselves, there is no corner. This is why a good software also needs to be constantly updated and perfected. Why is it that powerful industry software also needs custom functionality. We also have a corner of Excel, some problems can not be done. Today blue1000 to share a few Excel can not do the problem, so that people encounter such problems in the future do not waste time and the manager to find the answer.

1 The conditions of a custom format cannot exceed 3, but can be increased to 6 colors (borders, etc.) by custom cell formatting other restrictions include: cannot enter constant array, cannot copy paste, cannot change conditional order 2 cannot add AutoFormat.

3 functions cannot be nested more than 7 layers (but you can use the "define name" method to remove the restriction of nested functions, the number of parameters of a function can be up to 30 (also a breakthrough) the length of the 4 name cannot exceed 255 characters, and the character limit of the formula in the cell is 1024 characters.

5 EXCEL is automatically populated, and characters with more than 11 digits cannot be automatically populated.

6 There is no way to insert a GIF animated picture. (but can be implemented by referencing a control or an API clock in program development) 7 references between workbooks can only be absolute and cannot be relative.

8 The reference in effectivity must be a reference to a range of cells and cannot use an array formula.

The text in 9 cells can set the color font separately, but there is no way to set the spacing between two lines of text in the same cell Gegne.

10 in a shared workbook, cells cannot be moved, cannot be inserted, cannot be sorted, and none of the data involved can be moved.

11 scenarios in Scenario manager have up to 32 variable cells, and formulas entered in changing cells are converted to numeric storage.

12 shortcut to the format brush and merged cells The maximum font size for the 13 font is 409 points, which is the maximum size of the 10cmx10cm word.

14 The number of rows in the AutoFilter list is up to 1000, but does not mean that it cannot be filtered without showing.

15 The Consolidate feature can only hold one set of merged data at a time.

Limitations in Version differences: (Since my office is only 2000 and 2003, the other version of Excel also want to provide testing) 1 in the 2000 version of the inserted picture can not rotate, 2003 in the toolbar this rotation tool 2 in the 2000 version of the "China * Olympic" in the middle of such a * The field filter of the number will have an incomplete problem. This problem is not available in version 2003.

3 XP version below in footer and header there is no way to insert a picture.

More than 4 2000 versions can be centered across rows in a cell format to achieve the previous "merged cells" effect.