How to set the size of pasted text in Excel

Friends who often use Excel may encounter this situation: "If you copy text from other places (such as Word) and paste it into Excel, the size of the text will not change because of the change of place." ”

So how do you make the size of the copied text change with the settings of Excel?

Today I will share with you how to set the size of pasted text in Excel.

Tools Raw materials.

excel2003

word2003

Method steps.

Let's take a look at an example: open the Word2003 and Excel2003 office software on the computer, enter the text in Word2003, for example, enter "experience", the font is set to bold, the font size is two, and the font is bold.

Then use the mouse to select the Chinese characters, right-click to select the copy option (or directly press the Ctrl+C key combination).

In Excel2003, we can see that the default font is "Songti", the font size is "12", and then in any cell, right-click and select "Paste".

At this time, the text in the clipboard will be pasted into its cells, and the corresponding font will also change to "bold, 22 word, bold" So how can we make the text copied in word change with the setting of excel cells, that is, let the copied word Chinese words change from "bold, number 2, bold", paste into excel to become "song font, 12 words, do not show bold"?

Method 1: Copy the text to the clipboard in Word, right-click in any cell in Excel and select "Paste", then click "Paste Options" in the lower right corner of the cell, and then select "Match Target Format".

Method 2: Copy the text to the clipboard in Word, right-click in any cell in Excel and select "Paste Special".

In the pop-up dialog box, select the "Text" format, click the OK button, method 3: copy the text to the clipboard in Word, double-click or select the cell in Excel and press the F2 key or paste it directly in the insert function line.

The text size is something that needs to be done before pasting.

Don't paste directly when pasting the congregation, click on the menu after copying, and then select selective paste, select text. Then the word is the regular font size and font. If you want to change it again, go to the font dish socks and set it inside.

Friends who often use Excel may encounter this situation: "If you copy text from other places (such as Word) and paste it into Excel, the size of the text will not change because of the change of place." ”

So how do you make the size of the copied text change with the settings of Excel?

Today I will share with you how to set the size of pasted text in Excel.

Tools Raw materials.

excel2003

word2003

Method steps.

Let's take a look at an example: open the Word2003 and Excel2003 office software on the computer, enter the text in Word2003, for example, enter "experience", the font is set to bold, the font size is two, and the font is bold.

Then use the mouse to select the Chinese characters, right-click to select the copy option (or directly press the Ctrl+C key combination).

In Excel2003, we can see that the default font is "Songti", the font size is "12", and then in any cell, right-click and select "Paste".

At this time, the text in the clipboard will be pasted into its cells, and the corresponding font will also change to "bold, 22 word, bold" So how can we make the text copied in word change with the setting of excel cells, that is, let the copied word Chinese words change from "bold, number 2, bold", paste into excel to become "song font, 12 words, do not show bold"?

Method 1: Copy the text to the clipboard in Word, right-click in any cell in Excel and select "Paste", then click "Paste Options" in the lower right corner of the cell, and then select "Match Target Format".

Method 2: Copy the text to the clipboard in Word, right-click in any cell in Excel and select "Paste Special".

Select the "text" format in the pop-up dialog box, click OK to press the button of the book, method 3: copy the text to the clipboard in word, double-click in any single Chi Peiyuan grid in Excel or select the state orange cell and press the F2 key or paste directly in the insert function row.