vladimiratanasiu
Active Member
- Joined
- Dec 17, 2010
- Messages
- 346
- Office Version
- 2021
- 2019
- Platform
- Windows
Hello!
I have more tables with extended series of cells, that need to be changed from simple / relative to relative / absolute references. My question is how could I convert automatically a whole range of cells, so that I may avoid editing manually the content from each one, as it's shown in the table Book1.xlsx . I used the find and replace method, but it doesn’t cover all cases properly. I also mention that the function Convert refers from Kutools for Excel is very good, but I can use it only on my own PC, not other ones too.
Thank you!
I have more tables with extended series of cells, that need to be changed from simple / relative to relative / absolute references. My question is how could I convert automatically a whole range of cells, so that I may avoid editing manually the content from each one, as it's shown in the table Book1.xlsx . I used the find and replace method, but it doesn’t cover all cases properly. I also mention that the function Convert refers from Kutools for Excel is very good, but I can use it only on my own PC, not other ones too.
Thank you!