Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | Copy same formula into entire column in Excel 2013
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

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.

 
  Author: Brodjan | Version: Microsoft Excel 2013 | 13th January 2014 |  
 
 
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.

 
 
7.
 

The formula is now copied to every cell in the column.

Also recommended:


 
 
 
   
  Please login to post a comment
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO