Recently, I encountered the "Alt + enter" Line Break Problem When deleting cells in Excel in batches.
After searching for a long time, I finally found a solution:
Reference address:Http://zhidao.baidu.com/question/427377993.html
Let's talk about the principle. First, create a worksheet and double-click cell A1. Press Alt + enter, and a forced line feed appears in A1. Then, if you select B1 and enter = Code (A1), the result will be 10. Then, if the code is 10, ALT + 10 is used as the keyboard input method. That is, press the Alt key and do not let go, then press 1 and 0 in the small numeric keyboard area, that is, ALT + 10. The first solution is to press Ctrl + H and select the search content box, press Alt + 10. In this case, no content will appear in the search content box. Ignore it and simply click replace all. If your operation steps are correct, but the problem cannot be solved, there are two possibilities, first, those are not Alt + enter, and second, your operations are still incorrect.
- Comments from the questioner
-
The problem has been solved in advance, that is, the method you mentioned. Thank you for parsing the professional principles and have benefited a lot!