หน้าเว็บ

วันเสาร์ที่ 9 ตุลาคม พ.ศ. 2553

Get "Too many different cell formats " error message in Exel.

You receive a "Too many different cell formats" error message in Excel

To resolve this problem, simplify the formatting in the workbook. For example, the following are suggestions for simplifying formatting:


  • Use a standard font.

Using the same font for all cells reduces the number of formatting combinations.

  • If you use borders in a worksheet, use them consistently.

NOTE: If you apply a border to the right side of a cell, it is not necessary to apply a border to the left side of the cell that is to the right because the borders overlap.

  • If you apply patterns to the cells, remove the patterns by clicking No Color in the Patterns tab of the Format Cells dialog box.

NOTE: After you simplify or standardize the formatting in the workbook, save, close, and then reopen the workbook before you apply additional cell formatting.
 
 
Or create new file and copy old data to new file. : )
 
 
Thanks:  support.microsoft.com

1 ความคิดเห็น:

pock555 กล่าวว่า...

อ่าว เพิ่ง support ไปเมื่ออาทิตย์ก่อน โตนเคยเจอแล้วนี่หว่า