Excel Auto Fill

Closed
Kris - Nov 3, 2011 at 09:42 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 8, 2011 at 10:26 AM
Hello,

I am pulling informaton from a row into a column. I was wondering if there is a way to auto fill formulas in the column with the row numbers. So instead of normal auto fill for a column (e.g., A4, B4, C4) I want to auto full A4, A5, A6.

Thanks
Kris

Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Nov 8, 2011 at 10:26 AM
Hi Kris,

So you want to keep the row numbers in your formula when dragging down?

Then use absolete cell references. Put a $ symbol in front of the row numbers you want to keep, You can also click on the range in your formula and hit F4 multiple times to cycle through the different references.

Best regards,
Trowa
0