| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
when I drag a formula to other cells the reference is the same
Normally when i drag a formula by clicking the mouse and dragging the formula
to fill other cells the cell reference changes as intended - for some reason when I drag the formula to the right the cells reference does not change - it is staying the same - I am not using the $ |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when I drag a formula to other cells the reference is the same
Are you sure you've got a formula, and not text?
-- David Biddulph "sbags" wrote in message ... Normally when i drag a formula by clicking the mouse and dragging the formula to fill other cells the cell reference changes as intended - for some reason when I drag the formula to the right the cells reference does not change - it is staying the same - I am not using the $ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I drag a formula keeping cells the same but changing sheets | Excel Worksheet Functions | |||
| Copy drag formula down cells | Excel Worksheet Functions | |||
| Lock cell reference in formula, even when moved with click & drag | Excel Worksheet Functions | |||
| Using Index to Transpose, Update Reference Cells as you Drag Down | Excel Worksheet Functions | |||
| Cannot drag content or formula to another cells | Excel Discussion (Misc queries) | |||
Linear Mode
