kingspur06
Board Regular
- Joined
- Apr 24, 2007
- Messages
- 50
I have a really strange issue that I have never seen before.
I am looking to drag and fill a formula into the cells below.
The formula fills down and correctly changes the cell reference in the formula as you would expect.
But the actual cell value being displayed is just copying the initial value showing on the first cell.
It is almost as if I have enabled some sort of 'Paste Values' default on the drag and fill.
Has anybody ever experienced this before?
And do you know how to make it stop?
thanks
Mark
I am looking to drag and fill a formula into the cells below.
The formula fills down and correctly changes the cell reference in the formula as you would expect.
But the actual cell value being displayed is just copying the initial value showing on the first cell.
It is almost as if I have enabled some sort of 'Paste Values' default on the drag and fill.
Has anybody ever experienced this before?
And do you know how to make it stop?
thanks
Mark