Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default copying/dragging a formula to adjacent cells in Excel

Hi,
Thanks for any help. I have a list of data in column A in worksheet 1. I
want to show that data in row 1 of worksheet 2. So, I've got data shown
vertically that I want to show horizontally in a different worksheet. When
I drag from my 1st Formula cell horizontally, the cells pull data from the
associated row in the formula. The same if I drag downward - the data is
pulled from the associated column.

Is there a way to override this default so excel with populate my row 1 in
worksheet 2 with worksheet 1's column A of data?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default copying/dragging a formula to adjacent cells in Excel

Steve

In A1 of sheet2 enter this formula.

=INDIRECT("Sheet1!A"&COLUMN(A1))

Drag/copy across row 1.

Going the other way.............

=INDEX(Sheet1!$1:$1,ROWS(Sheet1!$1:1))

Drag/copy down any column.


Gord Dibben MS Excel MVP


On Tue, 17 Apr 2007 09:22:00 -0700, Steve Brennan <Steve
wrote:

Hi,
Thanks for any help. I have a list of data in column A in worksheet 1. I
want to show that data in row 1 of worksheet 2. So, I've got data shown
vertically that I want to show horizontally in a different worksheet. When
I drag from my 1st Formula cell horizontally, the cells pull data from the
associated row in the formula. The same if I drag downward - the data is
pulled from the associated column.

Is there a way to override this default so excel with populate my row 1 in
worksheet 2 with worksheet 1's column A of data?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying adjacent cells with formula tanner Excel Worksheet Functions 4 May 15th 06 02:50 PM
Dragging/Copying Lookup Formulas Paul Sheppard Excel Discussion (Misc queries) 5 April 7th 06 02:25 PM
How do I keep a formula constant in dragging cells below the rows analyst storm Excel Discussion (Misc queries) 3 February 16th 06 02:19 AM
Dragging/copying formulas George Stauffer Excel Discussion (Misc queries) 4 October 18th 05 09:44 AM
copying formula into non-adjacent cells, EXCEL2003 jacob Excel Discussion (Misc queries) 1 July 1st 05 12:35 AM


All times are GMT +1. The time now is 10:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"