From: Officeteacher on 22 Feb 2010 12:35 How do you quickly fill down a formula without dragging the fill handle for 3000 rows in Microsoft 2007?
From: Eduardo on 22 Feb 2010 12:45 Hi, if the adjacent column has information up to row 3000, just go to the right button of the cell where you have the formula, when you see the black cross, double click the mouse "Officeteacher" wrote: > How do you quickly fill down a formula without dragging the fill handle for > 3000 rows in Microsoft 2007?
From: T. Valko on 22 Feb 2010 12:51 One way... Select the range of cells. For large ranges you can do this quickly by typing the range address into the name box and then hitting Enter. The name box is that little "box" immediately above the column A header. For example, the range in question is A1:A3000 In the name box type A1:A3000 then hit Enter The range will be selected and cell A1 will be the active cell. Type your formula then, while holding down the CTRL key, hit Enter.  Biff Microsoft Excel MVP "Officeteacher" <Officeteacher(a)discussions.microsoft.com> wrote in message news:37B18177AF4C4EB4AB6F194B272B3E52(a)microsoft.com... > How do you quickly fill down a formula without dragging the fill handle > for > 3000 rows in Microsoft 2007?
From: Officeteacher on 22 Feb 2010 12:56 thank you "Eduardo" wrote: > Hi, > if the adjacent column has information up to row 3000, just go to the right > button of the cell where you have the formula, when you see the black cross, > double click the mouse > > "Officeteacher" wrote: > > > How do you quickly fill down a formula without dragging the fill handle for > > 3000 rows in Microsoft 2007?
From: Officeteacher on 22 Feb 2010 13:13 Is there a way to go fill down to row 3000 quickly if you do NOT have any information adjacent? "Eduardo" wrote: > Hi, > if the adjacent column has information up to row 3000, just go to the right > button of the cell where you have the formula, when you see the black cross, > double click the mouse > > "Officeteacher" wrote: > > > How do you quickly fill down a formula without dragging the fill handle for > > 3000 rows in Microsoft 2007?

Next

Last
Pages: 1 2 Prev: How to find different numbers that equal a number in another cell? Next: Excel Form 