If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto Calculate Question / HELP!
When I click on the fill handle to drag the data down the cells fill with
data grabbed veritcally, for example: When I drag the fill handle down the formulas look like: =D21 =D22 =D23 =D24 =D25 But is there a way for Excel to be adjusted so that they attach the information laterally instead of veritcally? For example, I want to drag the auto fill DOWN but want the cells to read: =D21 =E21 =F21 =G21 =H21 Thank you! |
#2
|
|||
|
|||
Auto Calculate Question / HELP!
Try this...
Assume you enter the first formula in cell A1 =INDEX(D$21:H$21,ROWS(A$1:A1)) Drag down as needed. Adjust for the correct end of range H$21. -- Biff Microsoft Excel MVP "Andy" wrote in message ... When I click on the fill handle to drag the data down the cells fill with data grabbed veritcally, for example: When I drag the fill handle down the formulas look like: =D21 =D22 =D23 =D24 =D25 But is there a way for Excel to be adjusted so that they attach the information laterally instead of veritcally? For example, I want to drag the auto fill DOWN but want the cells to read: =D21 =E21 =F21 =G21 =H21 Thank you! |
#3
|
|||
|
|||
Auto Calculate Question / HELP!
Hi Andy
You can't do it with Autofill Insert the following formula in the cell where you want to start (ie where you want the value from D21 to appear) and copy down as far as required =INDIRECT(SUBSTITUTE(ADDRESS(1,ROW(A4)),"1","")&"2 1") -- Regards Roger Govier "Andy" wrote in message ... When I click on the fill handle to drag the data down the cells fill with data grabbed veritcally, for example: When I drag the fill handle down the formulas look like: =D21 =D22 =D23 =D24 =D25 But is there a way for Excel to be adjusted so that they attach the information laterally instead of veritcally? For example, I want to drag the auto fill DOWN but want the cells to read: =D21 =E21 =F21 =G21 =H21 Thank you! __________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Thread Tools | |
Display Modes | |
|
|