Excel2010 format brush how to use Excel2010 format brush tutorial

Excel2010 has a very useful function, it is the format brush, it can change the format of your selected area into a format, then how to use Excel2010 format brush? Let’s take a look!

Operation method

1. Copy the format to the continuous target area using the format brush

Open the Excel2010 worksheet window, select the cell range with the format, and then at &ldquo "Start" "Clipboard" in the "Clipboard" section of the ribbon. Click the "Format Brush" button. 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 to multiple non-contiguous In the area, you can first select the cell range with the format, and then double-click the "Format Brush" button in the "Clipboard" grouping 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.