Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drag the column
Let say I have the data and I want to fill in the data in another sets of
table. All i need to do is to put"=" and it will copy. What if I want to drag the copy by changing the colum for example I will drag from A1 and rather than it will change to A2, I want to change it to B1,C1 and excetra. I've tried A$1 and $A1 but failed. Please help me (*^*) |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drag the column
One way
In the start cell, say in B3: =INDEX($1:$1,ROWS($1:1)) Copy down to return A1, B1, C1, etc Success? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Syahira" wrote: Let say I have the data and I want to fill in the data in another sets of table. All i need to do is to put"=" and it will copy. What if I want to drag the copy by changing the colum for example I will drag from A1 and rather than it will change to A2, I want to change it to B1,C1 and excetra. I've tried A$1 and $A1 but failed. Please help me (*^*) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I drag formulas from one column to the next | Excel Discussion (Misc queries) | |||
How do I drag a,b,c,d down a column into a series? | Excel Discussion (Misc queries) | |||
Increment column on drag down | Excel Discussion (Misc queries) | |||
Formulas won't drag down the column | Excel Discussion (Misc queries) | |||
Column Drag Down | Excel Discussion (Misc queries) |