98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in - Text
microsoft excel courses in - Text
Resolved · Low Priority · Version Standard
Jenny has attended:
Excel Intermediate course
Text
When typing text into an excel cell how do I create a new paragraph in the same cell rather than the text continuing on from the previous sentence? Hitting 'enter' doesn't seem to work.
RE: Text
Hiya Jenny,
Thanks for the question.
Excel does not have the word processing abilities of word and text formatting options are limited. There is no paragraph break, however, have you tried starting the new paragraph in a new cell further down the page?
Tracy
RE: Text
Alternatively you could create a text box with the drawing toolbar at the bottom of your screen and using this you can section off paragraphs. The button to the right of the oval shape.
Tracy
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Converting an American date format to European using FormulaExcel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following. |