How to Paste the Formatting Only in Excel
In this Excel Tutorial, I demonstrate three techniques for Copying & Pasting the Formatting Only from one location to another:
1) Use AutoFill Options - with a Contiguous Range of Cells
2) Use the Format Painter - best to "double click" it to paste the formatting only to multiple cells or cell ranges
3) Use Paste Special - Formatting. Remember to select the destination cells before using this command.
I have been teaching several online continuing education classes in Excel. As a result of one of my class assignments, I found that several students needed additional coaching on this topic.
I invite you to visit my secure online shopping website: http://shop.thecompanyrocks.com - to preview the range of resources that i offer.
Danny Rocks
The Company Rocks