Fill Down not working

Mar 7th, 2002, 01:32 PM

After I typed in my formula and tried to fill down the column by selecting Edit->Fill->down
But it doesn't work why?>

Mark W. · Mar 7th, 2002, 01:36 PM

Select the cell containing your formula and cells below it that you want to fill.

Mar 7th, 2002, 01:59 PM

I have a formula
=if(a2="something",J2,J2)
I am wondering is there a way to keep the second J2 for the rest of the rows when the formula fill down and not change to J3, J4...
Thanks

Steve Hartman · Mar 7th, 2002, 02:10 PM

Use =if(a2="something",J2,$J$2)

[ This Message was edited by: Steve Hartman on 2002-03-07 13:10 ]

Mark W. · Mar 7th, 2002, 02:21 PM

=IF(A2="something",J2,J$2)

...will work too.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 01:32 PM	#1
Guest Posts: n/a	After I typed in my formula and tried to fill down the column by selecting Edit->Fill->down But it doesn't work why?>

Mar 7th, 2002, 01:36 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Select the cell containing your formula and cells below it that you want to fill.

Mar 7th, 2002, 01:59 PM	#3
Guest Posts: n/a	I have a formula =if(a2="something",J2,J2) I am wondering is there a way to keep the second J2 for the rest of the rows when the formula fill down and not change to J3, J4... Thanks

Mar 7th, 2002, 02:10 PM	#4
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Use =if(a2="something",J2,$J$2) [ This Message was edited by: Steve Hartman on 2002-03-07 13:10 ]

Mar 7th, 2002, 02:21 PM	#5
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=IF(A2="something",J2,J$2) ...will work too.