Apply Cell Format with Format Painter Before I started to use format painter for applying... ...cell formatting, I was using paste special with the shortcut key. Here’s how to do this: Select the cell or a range from where you want to copy cell formatting. Go to ➜ the Home Tab ➜ Clipboard. Now, make a double click on the “Format Painter” button. As soon as you do this, your cursor will convert into a paintbrush. Now, you can apply that formatting anywhere in your worksheet, in another worksheet or, even in another workbook.
I write all the information in my blog which can be useful for you. "Valuing YourselfЁЯСН Always give your Best Shot.......