strongman86
Board Regular
- Joined
- Feb 15, 2017
- Messages
- 115
- Office Version
- 2019
- Platform
- Windows
Lads,
I have formula applied to entire column e.g. =A1+B1. When I change formula in one cell I need and hit enter this new formula automatically applies to the rest of column. Then I hit backspace and formulas on rest of column goes back to normal and my just edited cell has got the new formula which works ok until I save spreadsheet & reopen it and my edited formula changes back to match entire column. I have tried absolute cell reference e.g. =$A$1+$B$1 on this one cell I need to alter and it does the same after reopening sheet.
Is there any way around this issue? Thanks.
I have formula applied to entire column e.g. =A1+B1. When I change formula in one cell I need and hit enter this new formula automatically applies to the rest of column. Then I hit backspace and formulas on rest of column goes back to normal and my just edited cell has got the new formula which works ok until I save spreadsheet & reopen it and my edited formula changes back to match entire column. I have tried absolute cell reference e.g. =$A$1+$B$1 on this one cell I need to alter and it does the same after reopening sheet.
Is there any way around this issue? Thanks.