Type A7 in the top cell
type A14 in the next cell

Select both cells
Drag down as far as you need

Select the range
Edit|replace
what: A
with: =A
replace all



Sasikiran wrote:

Dear,

I need to drag a simple reference formula =A7 in such a way that it follows
a pattern. Something like...

=a7
=a14
=a21
=a28
=a35

Can you please help me in doing this?

--

Dave Peterson