excel2010 Format Brush Use method

Source: Internet
Author: User

Using the Format Painter feature, you can quickly copy the selected area's formatting from the EXCEL2010 worksheet to another area, where the user can copy the selected range's formatting to a contiguous target range, or copy the selected region's formatting to a noncontiguous range of destinations. The following describes how to do this.

1. Use the format brush to copy the format to a contiguous target area

Open the EXCEL2010 Worksheet window, select the range of cells that contains the formatting, and then click the Format Painter button in the Clipboard group in the start Ribbon. When the mouse pointer renders a combination of bold + and small brushes, click and drag the mouse to select the target area. When you release the mouse, the format is copied to the selected target area, as shown in Figure 1.

Figure 1 Click the Format Painter button

Tip: The selected target area must be the same size as the original area.

2. Use the Format Painter to copy the format to a discontinuous target area

If you want to copy the formatting from the EXCEL2010 worksheet selection to multiple areas that are not contiguous, you can first select the range of cells that contain the formatting, and then double-click the Format Painter button in the Clipboard group in the start Ribbon. When the mouse pointer renders a combination of bold + and small brushes, click and drag the mouse to select the noncontiguous target area, respectively. When you are finished copying, press ESC on your keyboard or click the Format Painter button again to cancel the format brush, as shown in Figure 2.

Figure 2 using the Format Painter to copy the format to a noncontiguous target area

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.