Excel2010 format brush use

For Excel2010 form everyone will not be unfamiliar, but Excel table many functions are not very familiar, such as Excel2010 format brush how to use? The following small series will share the Excel2010 format brush usage method for everyone, I hope everyone has Helped. The Excel2010 format brush is used as follows: 1. Use the format brush to copy the format to the continuous target area. Open the Excel2010 worksheet window, select the cell area with the format, and then at the "Start” ribbon" clipboard” Click the “format brush” button in the group. When the mouse pointer shows a combined shape of a bold + and small brush, click and drag to select the target area. When you release the mouse, the format will be copied to the selected target area as shown.
Tip: The selected target area and the original area must be the same size.
2. Copy the format to a non-contiguous target area using the format brush
If you need to copy the format of the selected area of ​​the Excel2010 worksheet into multiple non-contiguous areas, you can first select the cell range with the format And then double-click the "Format Brush" button in the "Startup" section of the "Start" ribbon. When the mouse pointer presents a combined shape of a bold + and small brush, click and drag the mouse to select a non-contiguous target area. After copying, press the ESC key on the keyboard or click the “Format Brush” button again to cancel the format brush, as shown.