Search This Blog

The Away PA provides an "on demand" secretarial and business support service in conjunction with it's online office "Head Office". To find out more about how you can take advantage of a fully supported office, anywhere, any time, visit the Head Office website or The Away PA Website or email
or telephone 08450 527565.

Friday, 28 November 2008

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.

No comments: