UncleBajubjubs
Board Regular
- Joined
- Jul 11, 2017
- Messages
- 111
- Office Version
- 2010
Good morning,
I have a large table with many cells containing absolute references such as
=IF($AZ$36<=3,1,0)
I'd like to move this table elsewhere. Is there a way to change each formula in the table at once to remove the absolute references, or will I need to do each cell manually?
Thanks
I have a large table with many cells containing absolute references such as
=IF($AZ$36<=3,1,0)
I'd like to move this table elsewhere. Is there a way to change each formula in the table at once to remove the absolute references, or will I need to do each cell manually?
Thanks