Format Painter: quickly copy formats

In Excel, if you want to copy the format of a group of cells into another, you can use the Copy command and then make a Paste and selecting, on the Paste Options, the Formatting one. This is how most people do. But Excel has a function, called Format Painter, designed for this task. Let’s see an example. We have this table of data on our worksheet:


It' has some font style, color, size and borders applied. Now we make a new table for the 2nd Quarter Sales, like this:


We want to apply the same format to this table that we had for the 1st Quarter Sales one. Select the complete table (in this case cells B2:C6) and on your Home tab, on your Clipboard group, click on the Format Painter button. You will see your cursor change to a plus and a brush icon.


Now click on your B8 cell so that Excel applies the formatting from cells B2:C6 on this new table. This will be the result:


If you have more than one place where you want to copy the formatting, instead of clicking once on the Format Painter button, click it twice. On this example, we want to copy the formatting from cells B2:C6 into the table starting on cells B8 and B14.


So, select the cells B2:C6, click twice on the Format Painter button and click once on each cell (B8 and B14) so that Excel applies the formatting to this two tables. When you finish, just click ESC key to close the Format Painter copy. The result will be this:


This is just another example on how you can improve your Excel productivity using tools that are already available to help you.

10 comentários:

Unknown said...

Intersting and beautiful blog lovely presentation thanks for sharing your excel support|Excel Support|microsoft excel 2010

athletic clothing said...

brilliant work for Excel Users. expecting more info!!!

Photoshop Services said...

Photo Editing Pricing value on the images editing requirements. The exact price of the Photoshop services you use can vary greatly. Depending on the vendor/contractor, the complexity of the image editing volume of images and how quickly you need the edited photos back Forget an idea about our prices you can check our Photo Editing Price List

bobovbob said...

Вероятность поправить свое финансовое положение привлекает разных пользователей. Некоторые пробуют свои силы в казино вулкан, однако в прибыли остаются считанные единицы. Грамотные игроки в казино с успехом используют различные способы. Онлайн казино предлагают множество игр, начиная с рулетки и заканчивая игровыми автоматами. Казино Вулкан Stars – замечательный способ получения дополнительной прибыли.

ahmed said...

Vérifier les dates: n'oubliez pas de vérifier les dates de péremption des ingrédients avant utilisation. Triez régulièrement les vieux articles dans le garde-manger et jetez tout ce qui a été stocké depuis longtemps.
شركة رش مبيدات
شركة مكافحة النمل الابيض بجدة
شركة مكافحة حشرات بجدة
شركة رش مبيدات بجدة

William Alex said...

We are providing background removal service for your business.
Are you professional photographers, photography agencies, eCommerce retailers? If so Orbit Graphics is the right co-partner for your eCommerce product photo editing solutions including background removal service.

prashant said...
This comment has been removed by the author.
Photographer John said...

Amazing, exceptionally useful post I cherished it and wish to see more posts like that structure this blog. as of late I composed an article about photography on the off chance that anybody is keen on photography you can peruse it by clicking here.

ايمن وهنا said...

Kelly said...

Thanks for sharing. keep up the good work.