How to use Excel format brushes

Source: Internet
Author: User
Tags range

To quickly set the same cell format for multiple worksheets, you can do so by copying the format and using the Excel format brush to do the following:

Method one, copy paste format

First, format the range of cells in the first worksheet. Select the formatted range of cells, press CTRL + C to copy, switch to the worksheet that you want to format, select the range of cells you want to format, right-click, and select Format in the Paste Options column of the shortcut menu that pops up. option, you can copy the formatting from the previous worksheet, as shown in the figure:

Method Two, Excel format brush

Format the range of cells in the first worksheet, select a range of cells to format, click the Format Painter button in the Start tab Clipboard Group, and then switch to a worksheet that requires the same formatting, and select the range of cells you want to format, as shown in the figure:

This allows us to format the same cells with the Excel format brush.

Skill: Double-click the Format Painter button to apply to multiple areas

To set the same formatting for more than one cell or range of cells, double-click the Format Painter button in the Clipboard group to copy the format to multiple locations without exiting the format brush mode. When you finish the copy format operation, click the Format Painter button again, or press the ESC key to exit format brush mode.

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: and provide relevant evidence. A staff member will contact you within 5 working days.