Two ways to keep formatting unchanged when you copy an Excel 2013 cell

Method One: Use the format brush function

① Select the target cell, click Start--The Format Brush button under the Clipboard, as shown in the following illustration.

② then select the other cells and press CTRL + V on the keyboard to paste them over so that the cell format is copied with the content.

Method Two: Paste selectively to achieve

① or click on the target cell, click on the menu bar-"Start"-"Paste"--"paste selective".

② in the pop-up Select Paste dialog box, check all, OK.

③ this way, the specified cell copies the contents of the previous cell format.

Defect: Although the cell format and content can be perfectly copied and pasted, but the column width and row height of the cell can not be changed, which requires us to copy and paste over, the adjustment of their own.

Classification:

• Excel Tutorials