Copy Excel Formatting the Easy Way with Format Painter
- by DigitalGeekery
The Format Painter in Excel makes it easy to copy the formatting of a cell and apply it to another. With just a few clicks you can reproduce formatting such as fonts, alignment, text size, border, and background color.
On any Excel worksheet, click on the cell with the formatting you’d like to copy. You will see dashed lines around the selected cell. Then select the Home tab and click on the Format Painter.
You’ll see your cursor now includes a paintbrush graphic. Move to the cell where you’d like to apply the formatting and click on it.
Your target cell will now have the new formatting.
If you double-clicking on Format Painter you can then click on multiple individual files to which to apply the format. Or, you can click and drag across a group of cells. When you are finished applying formats, click on Format Painter again, or on the Esc key, to turn it off.
The Format Painter is a very simple, but extremely useful and time saving tool when creating complex worksheets.
Similar Articles
Productive Geek Tips
Use Conditional Formatting to Find Duplicate Data in Excel 2007Remove Text Formatting in Firefox the Easy WayMake Excel 2007 Always Save in Excel 2003 FormatUsing Conditional Cell Formatting in Excel 2007Make Word 2007 Always Save in Word 2003 Format
TouchFreeze Alternative in AutoHotkey
The Icy Undertow Desktop
Windows Home Server – Backup to LAN
The Clear & Clean Desktop
Use This Bookmarklet to Easily Get Albums
Use AutoHotkey to Assign a Hotkey to a Specific Window
Latest Software Reviews
Tinyhacker Random Tips
DVDFab 6
Revo Uninstaller Pro
Registry Mechanic 9 for Windows
PC Tools Internet Security Suite 2010
New Firefox release 3.6.3 fixes 1 Critical bug
Dark Side of the Moon (8-bit)
Norwegian Life
If Web Browsers Were Modes of Transportation
Google Translate (for animals)
Roadkill’s Scan Port scans for open ports
