Select the formula cell as well as the neighbouring cells to fill.
Select Down, Right, Up, or Left from the Home > Fill menu. You may also use the keyboard shortcuts Ctrl+D to fill the formula down in a column and Ctrl+R to fill the formula to the right in a row.
Select the formula cell as well as the surrounding cells that you want to fill.
Select Down, Right, Up, or Left from the Home > Fill menu. You can also use Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row, using a keyboard shortcut.
Select cell A3 below and click CTRL + c to copy a formula, for example.
Select cell B3 and press CTRL + v to paste this formula.
To see that the formula refers to the values in column B, click in the formula bar.
If you don't want the cell references in a formula to alter when you copy it, make them absolute cell references. If you want the column letter to always be the same, put a "$" before it. If you want a row number to always be the same, put a "$" before it.
Learner's Ratings
4.7
Overall Rating
82%
10%
4%
3%
1%
Reviews
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
S
Souvik Dutta
4
very good course
R
Raj
5
zero to hero course excel
K
KAUSHIK PAUL
5
outstanding class, mind-blowing practical class and concept. I just love it and thank you very so much.
again Thank you sir and Thank you Madam.
Share a personalized message with your friends.