Pinterest Pixel

Replace Excel Formatting with Another Formatting

Imagine this, you have a table full of bold text.  The bold text could also be all... read more

Download Excel Workbook
Bryan
Posted on

Overview

Replace Excel Formatting with Another Formatting | MyExcelOnline Replace Excel Formatting with Another Formatting | MyExcelOnline

Imagine this, you have a table full of bold text.  The bold text could also be all over your worksheet in random cells.

Then you decide that the bold text does not suit your expected design and prefer red colored text instead.

What would you do?

Changing all of the formatting one by one would be a big pain!!!

Thankfully, Excel allows you to replace formatting with another formatting!

This is our initial Table:

Replace Excel Formatting with Another Formatting

Replace Excel Formatting with Another Formatting | MyExcelOnline

Download excel workbookReplace-Formatting-with-Another-Formatting.xlsx

STEP 1: Go to Home > Find  & Select

Replace Excel Formatting with Another Formatting

Then select the Replace option.

Replace Excel Formatting with Another Formatting

 

STEP 2: Select Options.

Replace Excel Formatting with Another Formatting

 

STEP 3: Select Format.  We will set the format that we want to change.

Replace Excel Formatting with Another Formatting

Make sure Bold is selected. Click OK.

Replace Excel Formatting with Another Formatting

 

STEP 4: Select the second Format.  We will set the format that we want to be the final formatting.

Replace Excel Formatting with Another Formatting

 

Make sure the color Red is selected. Click OK.

Replace Excel Formatting with Another Formatting

 

STEP 5: Click Replace All and see the magic happen!

Replace Excel Formatting with Another Formatting

 

The formatting is now replaced with the color Red!

Replace Excel Formatting with Another Formatting

Replace Excel Formatting with Another Formatting

 

Helpful Resource:

728x90

 

If you like this Excel tip, please share it
Replace Excel Formatting with Another Formatting | MyExcelOnline Replace Excel Formatting with Another Formatting | MyExcelOnline
Replace Excel Formatting with Another Formatting | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  SUBSTITUTE Function - Replace Characters in Excel!

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...