Engineers-Excel.com

Multiple Formatting in the same cell



In the Batch Scheduler tool, different characters in the same cell were formatted differently to create the title "Classic Paints".

Multiple Formats

Creating such text is quite easy, first type the text as normal, then select the character that is to be formatted differently from the formula bar.

Create multiple formats step 1

Now choose Format -> Cells (or press Ctrl + 1) and change the format of the font as desired.

Create multiple formats step 2


The chosen character is now changed. Select the next character and repeat the process to get the desired formatting.

Multiple format result