copying a column reference into a row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet (sheet1) with a column of numbers (B2:B121). I would like
to reference these numbers on another worksheet (sheet2) but come over into a
row. I've tried using =sheet1(B2:B121), but I can't get these numbers to go
horizontally in a row.
 
lars,
Try:
={TRANSPOSE(Sheet1!B2:B121)}
This is an array formula. The exact same formula will be in all cells
on Sheet2. Array formulas have to be entered using CTRL>SHIFT>ENTER.
If this is your first time, here are the exact steps I used.
1. On Sheet2 select the horizontal range you want the Sheet1 values to
go into.
2. With the range highlighted hit =
3. In the formula bar type in TRANSPOSE(Sheet1!B2:B121)
4. Hit and hold CTRL then SHIFT then ENTER.
5. The {} brackets will be added to your formula and you are done.
HTH
 
Back
Top