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.
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.
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.
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.