Тёмный

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

TeachExcel
Подписаться 253 тыс.
Просмотров 249 тыс.
50% 1

Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.
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.
For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
Have a great day!

Опубликовано:

 

20 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 28   
@dlaw4251
@dlaw4251 2 месяца назад
Thanks 14 years Later after making this Video
@raselkhan1384
@raselkhan1384 2 года назад
Thank you, after 11 years of making this tutorial.
@MimiNwabuokuMD
@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! 😇✅
@Phil_4_8
@Phil_4_8 3 года назад
Thank you. I was actually looking for how to copy formatting from one individual cell to another and this works.
@bocaji1176
@bocaji1176 Год назад
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!
@nuriac2480
@nuriac2480 3 года назад
Not sure why the dislikes. It works like a charm! Short and to the point! Thanks
@alexshepherd4233
@alexshepherd4233 10 лет назад
You helped me out when I was stuck, thank you.
@jeanpierreyanez8228
@jeanpierreyanez8228 4 месяца назад
Saved me so much time!
@unapologeticallynotintoyou3359
@unapologeticallynotintoyou3359 3 года назад
The way this actually saved me in work rn THANK YOU!
@crazybigyo
@crazybigyo 9 лет назад
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.
@melaniem828
@melaniem828 4 года назад
I know this video is super old but THANK YOU
@lucasamorim5506
@lucasamorim5506 3 года назад
straight to the point, awesome
@TeachExcel
@TeachExcel 3 года назад
Glad you like it :)
@lan1813
@lan1813 2 года назад
it doesn't work on my rows and columns size
@bensangha1492
@bensangha1492 3 года назад
You're amazing sir, thank you 👏🏽
@MoarJellyThanYou
@MoarJellyThanYou 3 года назад
video starts at 1:16
@ajwatypingphotocopying8971
@ajwatypingphotocopying8971 5 лет назад
very helpful was very confused and stuck, thanks
@nerishneesoobramoney4419
@nerishneesoobramoney4419 4 года назад
Thank you...was very helpful😀
@andraebruce6453
@andraebruce6453 2 года назад
Thank you
@memo6032
@memo6032 2 года назад
if it doesn't work just close then reopen the file
@mceelo
@mceelo 4 года назад
Is there a way to do that to multiple areas without having to highlight copy and paste every time?
@LoneStarStinger
@LoneStarStinger 4 года назад
I need to know how to do this but it also copies row height. 😫
@pradeeppavar7610
@pradeeppavar7610 4 года назад
How to copy and paste one by one these tabkes to word template using vba
@sathoshsathosha2157
@sathoshsathosha2157 2 года назад
Tq
@meowgirl6840
@meowgirl6840 Год назад
wait you did it with mouse how to do it on keyboard ?
@aritrachakraborty8699
@aritrachakraborty8699 2 года назад
This won't work for large tables and data. Can't click drag large chunks of data like this boss.
@gullivergimeno1520
@gullivergimeno1520 3 года назад
try to copy it that on other location? it will not work....hahaha
@Imtiaz-Hussain-Vighio
@Imtiaz-Hussain-Vighio Месяц назад
Bro! your voice is irritating its all base not sound lol
Далее
MS Excel - Copying and Filling - Tricks
7:22
Просмотров 1,3 млн
Copying Excel Formats: Format Painter & More
5:39
Просмотров 49 тыс.
Перескочила цепь
00:16
Просмотров 51 тыс.
МАМА И ВАЛДБЕРИС
00:48
Просмотров 540 тыс.
10 *SURPRISING* Copy Paste Secrets for Excel PROs
8:27
Top 10 Most Important Excel Formulas - Made Easy!
27:19
Excel Copy Paste Tricks
11:49
Просмотров 437 тыс.
8 Expert Tricks for Conditional Formatting in Excel
30:58
Перескочила цепь
00:16
Просмотров 51 тыс.