Grab / Drag shortcut

[M@N]

This is probably a simple question, but I was wondering if it was possible to drag DOWN a formula but have it references cell ACROSS and vice-versa?

E.g. Formula in cell A1 which references cell B1, but as you drag the formula down (i.e. into cells A2, A3, A4 etc) it references cells C1, D1, E1 etc.

Is this possible?

Thanks.

[TMS]

Put this formula in cell A1 and drag down:

=OFFSET($A$1,0,ROW(),1,1)

or to avoid zeroes being returned for blank cells:

=IF(OFFSET($A$1,0,ROW(),1,1)="","",OFFSET($A$1,0,ROW(),1,1))

Regards

[M@N]

Works a treat!

Thanks