|
|
|
|
|
Copy same formula into entire column in Excel 2013
In this lesson I will show you a simple and useful trick, how you can copy the formula from any cell and paste it into entire colunm.
|
|
 |
|
|
|
|
|
|
|
|
|
|
 |
1.
|
|
|
Open Excel document and select any cell.
|
|
| |
2.
|
|
|
Enter any formula and press Enter.
I have enterd =10+10.
|
|
| |
3.
|
|
|
Select the cell with the formula.
|
|
| |
4.
|
|
|
Copy the cell.
You can also press Ctrl + C, to copy the content of the cell.
|
|
| |
5.
|
|
|
Leave the cell selected.
Now press Shift + Ctrl + arrow down, to select the whole column.
|
|
| |
6.
|
|
|
Right-click on selected column and select Paste.
You can also press Ctrl + V, to paste the content.
|
|
|
 |
|
|
|
Basic Usage of AutoSum Function in Excel
