Knowledge focus: the EXCEL spreadsheet, a cell can put a lot of characters,
moncler doudoune vente, but I want to put a cell only 10 English words (including symbols, spaces, etc.), and let the rest of the word or symbol automatically moved to the next one or the other cell, and not through the cut method,
doudoune moncler homme, such as ..
in EXCEL spreadsheet, a cell can put a lot of characters, but I want to put a cell of 10 English only words (including symbols,
moncler homme, spaces, etc.), and let the rest of the word or symbol automatically move to the next one or the other cell, and not through the cut method, how to achieve it? : I refer to a cell of more than 10 words,
doudoune homme moncler, and make more than 10 words after the cell into another, not in the same cell line, can not use the cut method. 10 words for his party.
the answer in at 8:58 on May 22 have finished the 10 characters, press the Enter key to enter the next cell, press ALTA key and press the Enter key can be forced line breaks.
● If more than 10 characters have entered the cell,
the answer in 5 月 19 日 8:50
through data - disaggregated for, as long as the breakdown of lines on the 10 words and 11 words between , it can split into two cells of the. If you want to enter the sub-frame at the same time I am afraid can not do automatically,
doudoune homme, because the length of the word can not be the same.
to line sideways to press TAB (the left side of the letter Q).
like Kennedy the line to press Enter.
Excel does not have this feature,
doudoune femme! Starting a VBA
achieve this by ExcelVBA in Riga had a control sheet!
code is very simple, you change to change their own on the line wondering!