How do I use format brushes continuously in Excel tables?

How do I use format brushes continuously in Excel tables?

1, format brush in the "Common toolbar" above the pasted next

2. Select the range of cells that contain the format

3, click the format brush, the selected cells will have ants around the line appears

4, click and drag the mouse to select the target area, you will be copied to the selected target area.

5, select the range of cells containing the format, double-click the format brush

6, you can put the same format "brush" to more than one cell, can be discontinuous cell

7. Exit Method: Keyboard ESC or click format icon