When entering data into Excel, it is often necessary to enter the same text data into different cells, even using “Ctrl+C” and “Ctrl+V” to complete the input is very troublesome. In fact, there are many shortcut methods in Excel to achieve repeated input of text.

1. Use the “fill handle”

If you want to enter the same text in consecutive cells, you can first enter the text into the first cell, then drag the “Fill Handle” right or down with the mouse, the text will be copied to other consecutive cells middle.

Tips for quickly entering the same text into Excel?

2. Use shortcut keys

If you need to enter the same text in multiple non-consecutive cells, you can hold down the Ctrl key and click the corresponding cells with the mouse to select all the cells that need to enter the same text, then enter the text content, and then press Press “Ctrl+Enter”, the same text will be automatically entered in all selected cells.

If the text to be entered is the same as the previous cell, press Ctrl+D or Ctrl+R. Among them, “Ctrl+D” is to input the same text to the cell below, and “Ctrl+R” is to input to the right.

3. Use system prompts

If the text to be entered has been entered before in the same column, when you enter the first few characters of the text, the system will prompt you, then just press the Enter key directly to enter the subsequent text.

Let Excel cells automatically adjust the font size?

In the process of using Excel, we often make the table according to the requirements first. At this time, the column width of the cell has been fixed, but the number of characters in some columns varies.

For example, when entering home addresses, some home addresses are relatively long, so that the contents of the cells cannot be completely displayed on the screen. The font size of the cell.

In the process of using Excel, we often make the table according to the requirements first. At this time, the column width of the cell has been fixed, but the number of characters in some columns varies.

For example, when entering home addresses, some home addresses are relatively long, so that the contents of the cells cannot be completely displayed on the screen. The font size of the cell.

Tips for quickly entering the same text into Excel?

If we adjust one by one, it will greatly increase our workload. In fact, we can use the following methods to automatically adjust the font size:

Select the range of cells where the font size needs to be adjusted, select the “Format → Cells” menu command in turn, the “Format Cells” dialog box will appear, select the “Alignment” tab, and check “Shrink Font Fill” in the “Text Control” box Check box, click the “OK” button.

Now, when we enter data in these cells, if the length of the entered data exceeds the width of the cell, Excel will automatically reduce the size of the characters so that the data is all displayed in the cell.

Recommended reading:

How to change the color of the taskbar in win10?

How to turn on the camera in win10?

Leave a Reply

Your email address will not be published. Required fields are marked *