Mixed Cell Formatting in Excel

In Excel spreadsheets, it is possible to use more than one text size, colour or style in the same cell, to emphasise, show secondary information or just to save space. To achieve this, first click in the cell concerned and press the F2 function key to go into cell-editing mode. Now highlight only the text to be altered and from the Formatting Toolbar, select different style, size or colour. Press the Enter key to finish and check result. Repeat the process to change results. To force text onto a new line within a cell, hold down the Alt key and press the Return key.