Its a great tool for those who wish to have a consistent formatting in their reports – items ranging from colours to fonts to number formats. Look at the following picture as an example.
I have specific colours decided for this particular part of the excel. Now if I have to apply similar formatting to the other tables in the tab, I’m going to use ‘Format painter’. I’m also not going to click on Format Painter every other time, I will double click on it and apply on all the tables I wish to. The formatted sheet looks somewhat like this:
Hit ‘Format Painter’ once you are done with formatting or just click on ‘Esc’ key and you are done. Now, isn’t this cool.
No comments:
Post a Comment