View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Using the "Fill" function

hi Mike,

on sheet2, select the range a1:k1

use an array formula:

=transpose(sheet1!a1:a10)

enter with ctrl+shift+enter not just enter

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Mike" escreveu:

I have a list of numbers/information going down in the same column (eg.
A1:A10). On another tab, I would like to "fill" this information in but I
would like to go across columns on the same row (eg. A1:K1). I have tried to
use the "=Sheet!A1:K1" however the source data is going down, not across.

Example:
Sheet1:
45
58
22
65
44
69

Sheet2(I would like the data above to be 'filled' across, not down):
45 58 22 65 44 69

Can anyone help?