How-To Geek on MSN
Stop using format painter in Excel: Find and replace formatting instead
First, set up a model cell with the replacement formatting. Next, press Ctrl+H to launch the Find and Replace dialog. There, define both the Find What and Replace With formatting by clicking "Choose ...
Please note: This item is from our archives and was published in 2004. It is provided for historical reference. The content may be out of date and links may no longer function. Q. Format Painter is a ...
How-To Geek on MSN
The 4 Excel find and replace tricks I use to save hours
Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...
1] Use the Clear Formats option to remove formatting in Excel The first and easiest method to clear formatting in your Excel workbook is to use the Clear Formats option. It is available on your ribbon ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback