Skip to main content

Format Painter: Our Favorite Microsoft Office Feature

You have the liberty to apply tons of formatting styles to any text selection or graphics in your Word documents, Excel Spreadsheet cells or the Powerpoint slides.

Now let's say you are decorating a paragraph in a Word document - you first changed the font, then made the text bold, then added a border with a drop shadow, then increased the text font size by 2 points, left aligned the para and finally changed the text color from black to blue.

Excellent. The para after formatting looks so much more appealing now. You happily forward the document for review and as expected the boss is extremely impressed.

But now the problem is that the boss wants you to duplicate that formatting to another paragraph in the same document or even to a different Word document. How would you do that in two seconds ?

One [obviously bad] choice is to note down the text formatting steps that you applied to the first document and then repeat them with other documents. If you hate the guess-work, another [obviously the best] choice is to learn the Format Painter command that sits just next to the Paste Icon in your toolbar [see screenshot]

The Format Painter button works just like the standard copy-paste buttons except that it copies the formatting from the selections rather than the selection itself.

First select the text whose style you want to copy, then click the Format Painter button which changes your pointer style to a paintbrush icon. Now simply select the target text to which you want to apply the formatting.

If you want to apply the same formatting to more than one item [like all the headings of your document which are spread across multiple pages], first select the text who formatting you want to copy, double-click Format Painter, and then select each title you want to apply formatting to.

You can apply Format Paint even to Microsoft Excel spreadsheet merged cells which is a real time saver.

Popular posts from this blog

How to Download Contacts from Facebook To Outlook Address Book

Facebook users are not too pleased with the "walled garden" approach of Facebook. The reason is simple - while you can easily import your Outlook address book and GMail contacts into Facebook, the reverse path is closed. There's no "official" way to export your Facebook friends email addresses or contact phone numbers out as a CSV file so that you can sync the contacts data with Outlook, GMail or your BlackBerry. Some third-party Facebook hacks like "Facebook Sync" (for Mac) and "Facebook Downloader" (for Windows) did allow you to download your Facebook friends' names, emails, mobile phone number and profile photo to the desktop but they were quickly removed for violation of Facebook Terms of Use. How to Download Contacts from Facebook There are still some options to take Friends data outside the walls of Facebook wall. Facebook offers the Takeout option allowing you to download all Facebook data locally to the disk (include

Learn to Create a Firefox Search Plugin in Less Than 2 Minutes

Almost every blog has a site search form where you just type in the search query and press enter to digg through the archives of that blog . The only drawback here is that you first have to visit the site homepage to locate the search box. And there's also a possibility that the site has no search form at all. This tutorial will show you a very simple Firefox hack that allows you to search any blog straight from the Firefox search bar without having to visit the actual blog . And there's something for IE users as well. Related: Firefox Search Bar Hacks First the not-so-good approach though it works with IE: Type the following query in the Google IE toolbar or in the Firefox Search Box with Google selected as the default engine: adobe captivate This query will retrieve all documents about Adobe Captivate on Digital Inspiration. You can replace with any site URL that you intend to search. You may have know the above trick already but i

Digital Inspiration

Digital Inspiration is a popular tech blog by  Amit Agarwal . Our popular Google Scripts include  Gmail Mail Merge  (send personalized emails with Gmail ),  Document Studio (generate PDFs from Google Forms ) and   File Upload Forms ( receive files  in Google Drive). Also see  Reverse Image Mobile Search , Online Speech Recognition and Website Screenshots , the most useful websites on the Internet.