Excel Formatting 12 - Quickly Copy Formats to Other Cells in Excel

Excel video tutorial that shows you how to quickly and easily copy formatting from one cell or table to another cell or table. Specifically this tutorial shows you how to copy the formatting from an entire table and paste only the formatting onto other similar sized tables in Excel. This allows you to very quickly make many professional looking tables and worksheets in Excel without having to create your own theme in Excel.

This is a great Excel tip that will save you time and improve the look of your spreadsheets.


Have a great day!

[dlaw]

Thanks 14 years Later after making this Video

[raselkhan]

Thank you, after 11 years of making this tutorial.

[Phil__]

Thank you. I was actually looking for how to copy formatting from one individual cell to another and this works.

[bocaji]

Thank you for this! Haven’t used excel in a little while and needed some crash course refreshers on a few things. This was perfect!

[alexshepherd]

You helped me out when I was stuck, thank you.

[MimiNwabuokuMD]

It’s January 19, 2023 and you made me look like an OG in front of my new bosses with this one. Thank you! 😇✅

[crazybigyo]

Thank you very much! I needed to figure out how to copy the formatting of an excel sheet for work. You helped me in 2 minutes. You're the best! I'll check out your site sometime.

[unapologeticallynotintoyou]

The way this actually saved me in work rn THANK YOU!

[nuriac]

Not sure why the dislikes. It works like a charm! Short and to the point! Thanks

[bensangha]

You're amazing sir, thank you 👏🏽

[melaniem]

I know this video is super old but THANK YOU

[ajwatypingphotocopying]

very helpful was very confused and stuck, thanks

[lan]

it doesn't work on my rows and columns size

[mceelo]

Is there a way to do that to multiple areas without having to highlight copy and paste every time?

[LoneStarStinger]

I need to know how to do this but it also copies row height. 😫

[memo]

if it doesn't work just close then reopen the file

[pradeeppavar]

How to copy and paste one by one these tabkes to word template using vba

[meowgirl]

wait you did it with mouse how to do it on keyboard ?

[aritrachakraborty]

This won't work for large tables and data. Can't click drag large chunks of data like this boss.

[gullivergimeno]

try to copy it that on other location? it will not work....hahaha