Change cell formats with find-replace in excel

By Chandoo at 4 April, 2008, 1:41 pm



Do you know that you can use excel find - replace dialog to change cell formats?

Often we prepare a report or project plan and our boss or someone else in the team feels that all the red color cells need to change to blue or something similar, worry not, you can use find-replace (ctrl+h) to do this for you.

I have created a small video demo on how to do this, check it out yourself

If you are not able to see the video:

  1. Press Ctrl+h
  2. click on “Format…” button on “find what:” area and specify the source format
  3. click on “Format…” button on “replace with:” area and specify the target format
  4. Select “replace all” or “replace” depending on your need
  5. Smile, you have just automated a mechanical and boring task


Categories : Excel Tips | hacks | ideas | technology
Tagged with: | | | | | | | | | | |

Did you enjoy reading this post? If so, give me some love

Subscribe to Pointy Haired Dilbert - Chandoo.org - RSS FeedSave to Delicious by bookmarking this post Stumble this post  

Consider subscribing to my newsletter every weekday I will send you one email with hot excel tips, technology tidbits or business insights that can make you more productive. Each mail will have unsubscribe link so you can stop receiving the mails at any time you wish.


Comments
Hypnos April 5, 2008

I see that you’ve become quite the excel guru.

Maybe I should start blogging about powerpoint techniques :P

ajay April 7, 2008

thanks for this excel tip.
looking for some tips on excel

Chandoo April 7, 2008

@Hypnos .. hehe… go ahead, enlighten the world with what you know
@Ajay .. thanks for visiting phd, hope you like the content here :)

RSS feed for comments on this post. TrackBack URI

Leave a comment

   Name (required)

   E-mail (required, never displayed)

   URL