| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change row reference when pasting formula
I wish to chabge the way in wich Excel updates the cell references when
dragging formulas at the moment if dragging down Excel does the following A1,A2, A3 etc.. I would like Excel to do the following A1,B1,C1. All help will be gratefully receieved! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change row reference when pasting formula
=OFFSET($A$1,0,ROW()-1)
HTH Kostis Vezerides On Apr 30, 1:54 pm, Stratful wrote: I wish to chabge the way in wich Excel updates the cell references when dragging formulas at the moment if dragging down Excel does the following A1,A2, A3 etc.. I would like Excel to do the following A1,B1,C1. All help will be gratefully receieved! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change row reference when pasting formula
Hi
You cannot change the way that Excel works. You can amend formulae to pick up data from other cells using Offset or Index. In cell A2, enter =INDEX(1:65536,1,ROW()) and copy down This will pull values from B1, C1 etc. as you go down the column. -- Regards Roger Govier "Stratful" wrote in message ... I wish to chabge the way in wich Excel updates the cell references when dragging formulas at the moment if dragging down Excel does the following A1,A2, A3 etc.. I would like Excel to do the following A1,B1,C1. All help will be gratefully receieved! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change row reference when pasting formula
Hi,
Thanks for the help, this formula works for cells B1 and C1 but any subsequent data returns a zero, any ideas on how to correct this? Many thanks Paul "Roger Govier" wrote: Hi You cannot change the way that Excel works. You can amend formulae to pick up data from other cells using Offset or Index. In cell A2, enter =INDEX(1:65536,1,ROW()) and copy down This will pull values from B1, C1 etc. as you go down the column. -- Regards Roger Govier "Stratful" wrote in message ... I wish to chabge the way in wich Excel updates the cell references when dragging formulas at the moment if dragging down Excel does the following A1,A2, A3 etc.. I would like Excel to do the following A1,B1,C1. All help will be gratefully receieved! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change row reference when pasting formula
Hi
My apologies, I forgot to make rows 1:65536 absolute =INDEX($1:$65536,1,ROW()) -- Regards Roger Govier "Stratful" wrote in message ... Hi, Thanks for the help, this formula works for cells B1 and C1 but any subsequent data returns a zero, any ideas on how to correct this? Many thanks Paul "Roger Govier" wrote: Hi You cannot change the way that Excel works. You can amend formulae to pick up data from other cells using Offset or Index. In cell A2, enter =INDEX(1:65536,1,ROW()) and copy down This will pull values from B1, C1 etc. as you go down the column. -- Regards Roger Govier "Stratful" wrote in message ... I wish to chabge the way in wich Excel updates the cell references when dragging formulas at the moment if dragging down Excel does the following A1,A2, A3 etc.. I would like Excel to do the following A1,B1,C1. All help will be gratefully receieved! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have to change a bunch of formula that need to reference a different workbook. | Excel Worksheet Functions | |||
| Is it possible to change a Sheet reference in a formula? | Excel Discussion (Misc queries) | |||
| How to change a tab name with cell reference and formula? | Excel Worksheet Functions | |||
| Change the work sheet name in a formula by using cell reference | Excel Worksheet Functions | |||
| How to change a formula reference? | Excel Discussion (Misc queries) | |||
Linear Mode
