Microsoft Excel offers a very interesting way to copy the same value in multiple cells. We can cater to this problem statement by using copy and paste options in excel. We can perform the below mentioned way to copy the same value in multiple cells in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel sheet with a cell with data
– Open the desired Excel workbook containing a cell with a text which can be copied to multiple cells
Step 2 – Copy the cell
– Now copy the cell which you want to paste to multiple cells
Step 3 – Data copied
– Now select the range of cells where you want to copy the value and then press “CTRL + V”.