Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling down w/o dragging
Is there any way to fill down formulas w/o dragging the + cursur. I'm
working on sheets w/ 50K records and dragging is time consuming. Thank-you Zb |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling down w/o dragging
Select the cell you want copied & double click on the bottom right corner.
Excel will AutoFill down as far as the "current data" goes. Current data = first adjacent columns on either side of selected cell. When both adjacent columns contains a blank cell in the same row, the AutoFill will stop. This is a rough description of observed behaviour. Your mileage may vary. HTH, "Zb Kornecki" <zDOTkorneckiATcomcastDOTnet wrote in message ... Is there any way to fill down formulas w/o dragging the + cursur. I'm working on sheets w/ 50K records and dragging is time consuming. Thank-you Zb |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling down w/o dragging
If adjacent column has no blank cells just double-click on the fill handle to
copy all the way down. OR............. Assuming formula is in D1, type D1:D50000 in namebox then Enter then CTRL + D to copy down. Gord Dibben MS Excel MVP On Thu, 8 Feb 2007 12:24:02 -0800, Zb Kornecki <zDOTkorneckiATcomcastDOTnet wrote: Is there any way to fill down formulas w/o dragging the + cursur. I'm working on sheets w/ 50K records and dragging is time consuming. Thank-you Zb |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling down w/o dragging
Select the cell, hold Shift+Ctrl, then hit the down arrow key. When all
cells are selected, or all adjacent cells are selected (whatever the case may be), hit Ctrl+D (for down). Ctrl+R works great for filling-right. -- RyGuy "Gord Dibben" wrote: If adjacent column has no blank cells just double-click on the fill handle to copy all the way down. OR............. Assuming formula is in D1, type D1:D50000 in namebox then Enter then CTRL + D to copy down. Gord Dibben MS Excel MVP On Thu, 8 Feb 2007 12:24:02 -0800, Zb Kornecki <zDOTkorneckiATcomcastDOTnet wrote: Is there any way to fill down formulas w/o dragging the + cursur. I'm working on sheets w/ 50K records and dragging is time consuming. Thank-you Zb |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling down w/o dragging
Hi
I am doing exactly what you said below (and it has always worked really well), but today I am getting a very weird result - when I double click on bottom right of cell, I get the same number being copied in all the cells even though my first cell has a formula (the formula is: C6/C$5$) - any ideas on why this is happening and how to correct it. If I try and copy and past this formula to the other cells, I again, get the same value that is in the original cell. Thanks Alka "George Nicholson" wrote: Select the cell you want copied & double click on the bottom right corner. Excel will AutoFill down as far as the "current data" goes. Current data = first adjacent columns on either side of selected cell. When both adjacent columns contains a blank cell in the same row, the AutoFill will stop. This is a rough description of observed behaviour. Your mileage may vary. HTH, "Zb Kornecki" <zDOTkorneckiATcomcastDOTnet wrote in message ... Is there any way to fill down formulas w/o dragging the + cursur. I'm working on sheets w/ 50K records and dragging is time consuming. Thank-you Zb |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling down w/o dragging
Toolsoptionscalculation, make sure it is set to automatic
-- Regards, Peo Sjoblom "Alka" wrote in message ... Hi I am doing exactly what you said below (and it has always worked really well), but today I am getting a very weird result - when I double click on bottom right of cell, I get the same number being copied in all the cells even though my first cell has a formula (the formula is: C6/C$5$) - any ideas on why this is happening and how to correct it. If I try and copy and past this formula to the other cells, I again, get the same value that is in the original cell. Thanks Alka "George Nicholson" wrote: Select the cell you want copied & double click on the bottom right corner. Excel will AutoFill down as far as the "current data" goes. Current data = first adjacent columns on either side of selected cell. When both adjacent columns contains a blank cell in the same row, the AutoFill will stop. This is a rough description of observed behaviour. Your mileage may vary. HTH, "Zb Kornecki" <zDOTkorneckiATcomcastDOTnet wrote in message ... Is there any way to fill down formulas w/o dragging the + cursur. I'm working on sheets w/ 50K records and dragging is time consuming. Thank-you Zb |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling down w/o dragging
Thanks so much! That worked! I wasted so much time trying to figure it out
earlier! "Peo Sjoblom" wrote: Toolsoptionscalculation, make sure it is set to automatic -- Regards, Peo Sjoblom "Alka" wrote in message ... Hi I am doing exactly what you said below (and it has always worked really well), but today I am getting a very weird result - when I double click on bottom right of cell, I get the same number being copied in all the cells even though my first cell has a formula (the formula is: C6/C$5$) - any ideas on why this is happening and how to correct it. If I try and copy and past this formula to the other cells, I again, get the same value that is in the original cell. Thanks Alka "George Nicholson" wrote: Select the cell you want copied & double click on the bottom right corner. Excel will AutoFill down as far as the "current data" goes. Current data = first adjacent columns on either side of selected cell. When both adjacent columns contains a blank cell in the same row, the AutoFill will stop. This is a rough description of observed behaviour. Your mileage may vary. HTH, "Zb Kornecki" <zDOTkorneckiATcomcastDOTnet wrote in message ... Is there any way to fill down formulas w/o dragging the + cursur. I'm working on sheets w/ 50K records and dragging is time consuming. Thank-you Zb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Don't change cell content in Excel by dragging | Excel Worksheet Functions | |||
Odd behaviour in dragging data across and up and down cells | Excel Discussion (Misc queries) | |||
filling information from one cell and filling another. | Excel Worksheet Functions | |||
Dragging for automatic filling | Excel Discussion (Misc queries) | |||
In a column with no data, only color filling, how can I filter fo. | Excel Discussion (Misc queries) |