Excel Excel help with drag and reference cell option

R

ritesh@1989

Joined
Apr 14, 2017
Messages
1
Reaction score
0
Hey,

I am trying to put reference cell , i am able to do but when i try to drag it down it doesnt seem to work.

=a5
=a29
=a53
=a77

if i select all and drag down it should come as =a101 since they all are in interval of 24 cells. but it is showing. =a78...

please help.
 
You need to highlight a group of cells so that Excel detects the pattern. Highlight them vertically, then drag down by clicking on the bottom right corner. That should work :)
 
Back
Top