Nov 11 2011
To quickly enter the same text in Excel
Enter the data to Microsoft office 2010 Excel, often to a different cell type the same text data, even when using”Ctrl + C”, “Ctrl + V” to complete the input is also very troublesome. In fact, there are manyquick ways Excel can repeat the text input.
1. Using the “fill handle”
If you want to enter the same text in the cell is continuous, the first cell can first enter thetext, then drag the mouse to the right or down, “fill handle”, the text will be copied to othercells in a row .
2. The use of shortcut keys
If more than one discrete cell to enter the same text, hold down the Ctrl key while clickingwith the mouse the corresponding cell, to select those who need to enter the same text inall cells, and then enter text, and then press ”Ctrl + Enter”, all selected cells will automatically enter the same text.
If you want to input text and in front of the same cell, press ”Ctrl + D” or ”Ctrl + R”. One, “Ctrl + D” to the following cell type the same text, “Ctrl + R” is to the right input.
3. Prompted the use of
If you need to enter text in the same column has already been entered, when you enter the first few characters of the Office 2010 download text, the system will prompt, then simply press the Enter key todirect the follow-up text input.
