| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging a formula with cell references
Hello,
I have a problem while dragging the formula to the next cells. The formula in A1 of sheet 1 is ='Sheet2'!C34 The formula in B1 of sheet 1 is ='Sheet2'!F34 The formula in C1 of sheet 1 is ='Sheet2'!I34 Here while dragging the formula, the next cell has to take the value of the same row (34) of every third column C, F, I, L... so on. But while dragging its not coming the same way. Can anyone suggest me how to do that? Thanks in advance Sasikiran |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell formula references | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| locking formula cell references | Excel Worksheet Functions | |||
| how do i copy a formula when cell references r not together | New Users to Excel | |||
| Absolute References in cell formula | Excel Worksheet Functions | |||
Threaded Mode
