How to Paste the Formatting Only in Excel

Published: 10 October 2013
on channel: Danny Rocks

27,047

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

Watch video How to Paste the Formatting Only in Excel online without registration, duration hours minute second in high quality. This video was added by user Danny Rocks 10 October 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 27,047 once and liked it 78 people.

2,126,826

32K

00:00:59