If you write reports in Excel, you may get annoyed by try to get your paragraphs to line up nicely in multiple cells. There is another way.
Write your paragraph in a single cell. Typically it will go over the column width. Now you can decide how to handle.
One way is to use the wrap text to fit it all into a single cell, where the height increases.
Another way is to have Excel split the sentence up into segments that fit into the current column width. You can do this with the FILL, JUSTIFY option.
- Highlight the cell with the paragraph and the number of cells below it that you want to use.
- Then click on the HOME tab, and under EDITING, click on the FILL drop-down and choose justify.
- If we used the sentence above in Excel and used this tool it would look like this:
- Highlight the cell with the paragraph
- and the number of cells below it that
- you want to use. Then click on the
- HOME tab, and under EDITING, click
- on the FILL drop-down and choose
A shortcut to achieve the same is by pushing ALT then E then I then J.
You can watch the video clip below as well
Learn more at our live advanced Excel courses in South Africa. Visit www.AuditExcel.co.za Live Excel Training page