Excel Tips No 27 : Rapid Cell Formatting

This free microsoft excel tips no 27 is telling how to format cell quickly. we often format cell in our spreadsheet to create an interesting display. The common way to do it is using right click and choose format cell.


here is the quick step to do this

If you have a cell that have a good formating, its just simple step to make another cell have the same format.
1. Click The cell that want to be copied of it's formatting.
2. Click Format painter, your cursor will change to be a brush
3. Click cell will be formatted


You can select multiple cell, rows or column to be copy formatted.