On any Excel worksheet, pick the cell with the formatting youd like to copy.
You will see dashed lines around the selected cell.
Then select theHometab and hit theFormat Painter.Youll see your cursor now includes a paintbrush graphic.
Move to the cell where youd like to apply the formatting and punch it.
Your target cell will now have the new formatting.
Or, you could click and drag across a group of cells.
The Format Painter is a very simple, but extremely useful and time saving tool when creating complex worksheets.
