The hugely-useful Format Painter tool can be found in Microsoft Excel, Microsoft Word and Microsoft Outlook, and functions more or less the same in all these applications.
Say you’ve assembled a spreadsheet, document or eMail by copying and pasting from a number of sources, and so you’re left with a mishmash of information in different font types, font sizes and, perhaps, different colours.
Before the Format Painter is used, this eMail is made up of several different formats...
To use Format Painter:
1. Simply left-click and drag to select the text (or if in Excel, the cell) which contains the type of formatting you wish to apply to something else.
2. Then, with this still selected, left-click the Format Painter icon (in Microsoft Office 2007 this is found by default under the left-most tab, called ‘Home’ in Microsoft Excel and Microsfot Word and ‘Message’ in Microsoft Outlook).
3. Then select, again by left-click/dragging, the text/cells you want to amend.
4. The Format Painter will take the formatting of the originally-selected text/cell and apply it to the second selection.
Quick, easy, efficient, and it gets the job done with a minimum of time, thought and effort…
...and after the Format Painter has been used, all the text is the same format, looking far neater and more professional.
[...] Microsoft Office Quick Tip: Format Painter | Disegno Blog [...]