Excel Excel help with drag and reference cell option

[ritesh@1989]

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.

 

[Becky]

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