| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula referencing a column - autofilling in a row ???
Hi, I'm doing a HW assignment for my accounting class. Here is my problem:
On sheet 1 I have some numbers in the column B4:B9 On sheet 2 I WANT to put those numbers in the row B4:G4 like so B4 C4 D4 =+Sheet1!B4 =+Sheet1!B5 =+Sheet1!B6 ... But when I try dragging the formula =+Sheet1!B4 to the right i get B4 C4 D4 =+Sheet1!B4 =+Sheet1!C4 =+Sheet1!D4 ... How do I make excel auto fill the formula the way I want it to? I tried $B, but then the formula was the same ($B4) for every cell in the row. Thank you, CD |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula referencing a column - autofilling in a row ???
I forgot to mention that I must use cell referencing in my assignment.
That is, I can't just transpose the column to become the row I want. "Arcadiaz04" wrote: Hi, I'm doing a HW assignment for my accounting class. Here is my problem: On sheet 1 I have some numbers in the column B4:B9 On sheet 2 I WANT to put those numbers in the row B4:G4 like so B4 C4 D4 =+Sheet1!B4 =+Sheet1!B5 =+Sheet1!B6 ... But when I try dragging the formula =+Sheet1!B4 to the right i get B4 C4 D4 =+Sheet1!B4 =+Sheet1!C4 =+Sheet1!D4 ... How do I make excel auto fill the formula the way I want it to? I tried $B, but then the formula was the same ($B4) for every cell in the row. Thank you, CD |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula referencing a column - autofilling in a row ???
in b4 on sheet2 enter
=indirect("Sheet1!B"&(column()+2)) copy across to G4 "Arcadiaz04" wrote: Hi, I'm doing a HW assignment for my accounting class. Here is my problem: On sheet 1 I have some numbers in the column B4:B9 On sheet 2 I WANT to put those numbers in the row B4:G4 like so B4 C4 D4 =+Sheet1!B4 =+Sheet1!B5 =+Sheet1!B6 ... But when I try dragging the formula =+Sheet1!B4 to the right i get B4 C4 D4 =+Sheet1!B4 =+Sheet1!C4 =+Sheet1!D4 ... How do I make excel auto fill the formula the way I want it to? I tried $B, but then the formula was the same ($B4) for every cell in the row. Thank you, CD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilling using INDIRECT in a formula | Excel Discussion (Misc queries) | |||
| Autofilling incremental numbers in a formula | Excel Worksheet Functions | |||
| Autofilling next empty cell in column? | New Users to Excel | |||
| Autofilling a formula: not working? | Excel Discussion (Misc queries) | |||
| "Absolute" questions when autofilling-dragging down the column not | Excel Worksheet Functions | |||
Linear Mode
