You can select the format painter option using Alt, H, F, P from the keyboard shortcut. So now you just select the cells at one go where you need to apply formatting.Īs you can see formatting is applied to the overall header of the new table.Īlternate way : Format painter Shortcut key It will still take more time if you have more than headers and rows. Now either you can apply the format of each cell like this. Now your mouse painter will also show some brush options on it. It will be different from the select option. Īs soon as you click the format painter option, you will see some changes in the selected cell display as shown above. Select the Header column (formatted table) and Go to Home tab > Format painter. Another way is format header first and then any particular column (like first column) and at last table values. We need to apply the header formatting and table values formatting as per the first table. Here we have two tables, one formatted and another is not. Let's understand how to use the function using an example. You can apply formatting to more than one cell.Īll of these might be confusing to understand. To apply, select multiple cells where you want to apply formatting at one go. This will copy the formatting of the cell. Then Go to Home tab > Under it you will find the Cut, Copy and Format Painter option. Let's understand where to find Format painter option and how to use it to apply formatting to other table.įormat painter option only applies cell features like Font size, font style, font color, Cell style, cell color and border style. And doing it manually will take a lot of time and an average excel user doesn't spend much time on table formatting.

For problems like these, we cannot find all types of format done on one cell. For example Given a table with header formatting and cell formatting and given another table values and we need to apply the same formatting of first table to second table. Sometimes we come across problems like table formatting or cell formatting.

In this article, we will learn How to copy Cell formatting in Excel.

Mac shortcut for no cell border excel