Excel Format Painter,
1. Select the cell with the color you want to use…e.g. select cell A2 with yellow
2. Go to the “Home” tab in the “Clipboard” section and select the “Format Painter”
3. Then click on the cell you want to fill with that color, e.g. cell B2
4. The color in cell B2 will now be yellow as well which is reflected from cell A2
5. Repeat the steps for all required cells
You can also do it much more quickly by
6. Highlighting e.g. column A> then click on “Format Painter” in “Clipboard” group
7. Then select e.g. column B
8. The colors on column A will now be reflected in the same way on column B
9. That's it
0 comments:
Post a Comment