Previous Topic Next Topic

Excel Auto Fill

Closed
Kris - 3 Nov 2011 à 09:42
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 8 Nov 2011 à 10:26
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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
8 Nov 2011 à 10:26
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

Similar discussions

Any auto clicker for Xbox One?
vic11con -
julietdcosta -

13 responses