K KiwiBrian Dec 23, 2004 #1 After entering a formula into a cell, say b2, how do I tell excel to copy the formula right down to b3005? TIA Brian Tozer
After entering a formula into a cell, say b2, how do I tell excel to copy the formula right down to b3005? TIA Brian Tozer
G Guest Dec 23, 2004 #2 Select B2 again, press F5, type in B3005, hold down shift key and press enter, press ctrl + d Regards, Peo Sjoblom
Select B2 again, press F5, type in B3005, hold down shift key and press enter, press ctrl + d Regards, Peo Sjoblom
G Guest Dec 23, 2004 #3 OR If there is data in all of the associated cells to the formula, just double click on the little black square in the bottom right of B2 HTH Michael
OR If there is data in all of the associated cells to the formula, just double click on the little black square in the bottom right of B2 HTH Michael
G Gord Dibben Dec 23, 2004 #4 D-Click will work only if there is data down to row 3005 in an adjacent column. Gord Dibben Excel MVP
D-Click will work only if there is data down to row 3005 in an adjacent column. Gord Dibben Excel MVP
K KiwiBrian Dec 24, 2004 #5 Thanks everyone you have helped mightily. Brian. Gord Dibben said: D-Click will work only if there is data down to row 3005 in an adjacent column. Gord Dibben Excel MVP Click to expand...
Thanks everyone you have helped mightily. Brian. Gord Dibben said: D-Click will work only if there is data down to row 3005 in an adjacent column. Gord Dibben Excel MVP Click to expand...
