在excel中，要将一个单元格中的很多文字放到该单元格下面的多个单元格中，每个单元格中放一个文字。采用的方法是：

1.将单元格的列宽度调整为一个汉字宽。

2.选择单元格，Editor–>Fill–>Justify.

3. ok.

I renamed a sheet and am getting the error,  "While renaming a sheet or chart, you entered an invalid name, Try one of the following" blah blah blah. The sheet name is valid, does not have any characters and isn’t too long.

What’s the problem? Well, I searched internet and found this might solve the problem.

The following information is from: http://www.mrexcel.com/forum/showthread.php?t=157564

This topic may be dead, but i think i know what causes this phenomenon. And this might be helpful for someone else who might be searching the forum.
This happens to me every time I try to rename a sheet in an excel file that is in a "temp" directory. There are usually illegal characters in the file name, IE. "Sales Analysis -[1]". If I choose rename and name my sheet "Book1" Excel names the sheet ".xls]Book1", then you get the error.
At that point the only thing you can do is to "X" out of the workbook and select save changes. Then select file —>open and click My recent documents to open the workbook. Then click file save as, and save the file to a normal directory with a valid file name. Now you can change the invalid sheet name.