Lets see how to select multiple cells and do the formatting for the entire block.

Now you have done a good job of learning all the stuff required but what if you dont know the code for a small task like merge, wrap or border. Its easy you just record it. But be warned that you will be overwhelmed with the amount of code excel throws when recording. So here are the tips of how to pick the relevant code from the dump when reqired.