Hi,

I wanted to use excel for letter writting. I merged cells across. Can I go typing to next row when one row is with no further space ?

"then his unbeaten 85," should go to row 2 and "Cup century(110 not out). to row 3. Is this possible in excel ?

regards

If you ask how to move to next cell while typing - You can press Enter when you wish to move to the next cell below. Read more in the "Enter" section here.

If you ask how to transform large dataset that was already typed, you may consider VBA or Power Query add-in.

• Edited by Gil RavivMicrosoft employee 2 hours 3 minutes ago
• Proposed as answer by Gil RavivMicrosoft employee 47 minutes ago

If you ask how to move to next cell while typing - You can press Enter when you wish to move to the next cell below. Read more in the "Enter" section here.

If you ask how to transform large dataset that was already typed, you may consider VBA or Power Query add-in.

• Edited by Gil RavivMicrosoft employee Sunday, March 15, 2015 5:20 AM
• Proposed as answer by Gil RavivMicrosoft employee Sunday, March 15, 2015 6:36 AM