• Excel Book Excerpt

Excel Fill Formatting

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Fill Formatting

Problem: I have a thousand rows of data. I want to apply red and blue to every other row. Nothing in the Format as Table looks exactly like I want it to look and I don’t want to define my own table style.

LE10001262.jpg 

Figure 1215 Copy this formatting.

Strategy: This technique temporarily wipes out all of your data, but you get it back. It is a fast way to go.

1. Select the data in rows two and three. You will see a fill handle in the bottom right corner of the selection.

LE10001263.jpg 

Figure 1216 Double-click the fill handle.

2. Double-click the fill handle. All of your data is destroyed. Don’t panic.

3. Open the icon at the bottom right.

4. Choose Fill Formatting Only. All of your data comes back. The formatting is copied throughout.

Result: the formatting is copied. Your data that was overwritten comes back.

LE10001264.jpg 

Figure 1217 Open the Fill Options icon.

LE10001265.jpg 

Figure 1218 Only the formatting is copied!

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: