So you know how to apply formatting to text in cells using colour, bold, italics, font size, etc… You may not be aware of this little trick that will give you new options for formatting your Excel worksheets.

You can apply different formatting to different parts of text within the same cell.

Here’s how…

1) Select the cell;
2) Highlight the portion of text within the cell that you want to apply the formatting to;
3) Apply the formatting as you normally do. Don’t press Enter yet!
4) Select and apply formatting to other parts of the text;
5) When you’re done just press Enter.

Thanks to the Excel Addict for this tip.