Sometimes you need to input same contents into multiple cells in the worksheet. Here we will introduce 3 methods to fulfill this task quickly.
Suppose now you need to input the content “DataNumen Excel Repair” into the first cell of each month.
Instead of inputting into those cells one by one, now you can also use the 3 methods.
Method 1: Use Copy and Paste Feature
The copy and paste is a very common feature in Excel. And here you can also input the contents into corresponding cells quickly.
- Click one of the target cells in the worksheet. Here we select the cell A2.
- And then input the content into the cell.
- Next press the shortcut keys “Ctrl +C” on the keyboard to copy the cell.
- Now press the button “Ctrl” in the keyboard.
- Use your mouse to select all the other target cells in the worksheet.
- And then press “Ctrl + V” to paste the content. Thus, the contents will appear in all the other cells immediately.
Method 2: Use Shortcut Keys Combo
In this method, you need to use another shortcut keys in Excel.
- Press the button “Ctrl”.
- Next select all the other target cells in the worksheet.
- Now directly type the characters into the last cell.
- When you finish typing, press the shortcut keys combo “Ctrl + Enter” on the keyboard. Thus, the content will be filled in all the selected cells.
Method 3: Use VBA Codes
Instead of using the above two methods, you can also use the VBA codes to input same contents into multiple cells.
- Press the shortcut keys “Alt +F11” on the keyboard.
- And then right click in the VBA project area.
- In the new menu, move your cursor on the option “Insert”.
- Now click the option “Module” in the submenu. Thus, you have inserted a module for the file.
- And then input the codes into the new module.
Sub SameContents()
Worksheets(“Sheet1”).Range(“A2,E2,I2,A15,E15,I15”).Select
Selection.FormulaR1C1 = “DataNumen Excel Repair”
End Sub
In your actual file, you need to change the name of the worksheet, the cell reference and the contents in the codes. You can see that the codes are actually very simple. First we select the certain cells in the worksheet. And then we assign the content to those cells.
- Now press the button F5 to run the codes. After that, you can come back to the worksheet to see the result. You will get the same result as the result of the other two methods.
A Comparison of the Three Methods
If you don’t know what method to choose, you can refer to the table below and see the differences of the three methods.
Comparison | Use Copy and Paste Feature | Use Shortcut Keys | Use VBA Codes |
Advantages | 1. Copy and paste is the most common feature in Excel and it is very easy to manipulate.
2. If there are a small number of cells, this method can finish this task quickly. |
1. This method only needs four steps to finish the task.
2. Like the first method, if the number of cells is small, you can use this method quickly. |
1. You can directly input the cell references into the VBA codes, which is quicker than the other two methods.
2. You can use this VBA project in other worksheet or workbook by simply changing certain elements in codes. |
Disadvantages | 1. If there are many cells, you need spend a lot of time on selecting those cells.
2. Every time you need to input same contents into multiple cells, you need to repeat the steps again. |
1. Select all the cells can be time-consuming.
2. This method only takes effect for once. The next time you also need to repeat the steps again in other worksheet or workbook. |
1. Using VBA code will make the task more complicated.
2. If you are not familiar with VBA, you will easily make mistakes. |
According to the above analysis, you will have a better understanding of the three methods. And the next time if you need to input same contents into multiple cells, you can choose the most suitable method.
Don’t Permit Excel Crash to Ruin Your Data
Data disaster will happen from time to time. And among all those accidents, Excel corruption will also happen unexpectedly. You have already arranged data in a perfect condition in Excel. If Excel corrupts, things will go bad and the data in Excel will be in a mess. Therefore, you need a powerful Excel recovery tool for help. Equipped with the most advanced technology, this tool is able to solve almost all the problems in Excel.
Author Introduction:
Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com
Leave a Reply