Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel filling using fill handle
Can you fill down such the cell reference goes from A1 to A3 .
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel filling using fill handle
If there is a formula in cell A1, grabbing the fill handle in the lower right
corner of A1 and pulling it down WILL copy those formulas down to cells A2 and A3. Any cell references that are NOT preceded by $ signs will adjust themselves accordingly during the fill-down. Does that answer your question? It was a little vague. -- "Actually, I AM a rocket scientist." -- JB "Pete G" wrote: Can you fill down such the cell reference goes from A1 to A3 . |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel filling using fill handle
In B1 enter =INDIRECT("A"&(ROW()-1)*2+1)
Copy down to return every second cell from column A Gord Dibben MS Excel MVP On Tue, 13 Jan 2009 02:41:01 -0800, Pete G <Pete G @discussions.microsoft.com wrote: Can you fill down such the cell reference goes from A1 to A3 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill handle in Excel | Excel Worksheet Functions | |||
Fill Handle in Excel 2007 | Excel Discussion (Misc queries) | |||
what is "fill handle". i don't see any fill handle in my excel | New Users to Excel | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
Can you change the function of the fill handle on a cell in Excel | Excel Worksheet Functions |