- Picture and text skills
Are you still formatting cells one by one?
Using the format painter can help you quickly apply cell formats, greatly improving efficiency.
￭ The basic method of using format brush is:
Hold down the left mouse button to select the formatted cells, and click "Format Painter" under the "Start" menu bar.
Click another cell range and find that the format is copied immediately.
To copy the cell format of an entire row/column, select the row number/column label operation.
But in this way, after copying once, you have to re-select the cells to set the format brush, which is more troublesome.
￭ At this point, you can use the double-click format brush method.
After double-clicking the format painter, the format painter will be fixed and the format can be applied to other cells unlimited times.
To cancel the format brush, just hit the Enter key.
But when setting "interlaced fill" like this, it is still a bit troublesome.
￭ Let’s teach you how to quickly “fill every other line”.
Select the two rows of cells you want to copy, click the format painter, select the range of cells you want to apply the format to, and done!
￭ In the same way, you want to copy the format of an entire cell range.
Frame-select a range of cells, click the format painter, and then frame-select another range of cells.
After releasing the mouse, you will find that the format has been applied!
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/ge-shi-shua-pi-liang-tiao-zheng-yang-shi.html
支付宝扫一扫 
评论列表（196条）
测试