Shanaya2009
New Member
- Joined
- Mar 11, 2021
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
Hello,
If I copy one cell and paste link to another cell, the referenced cell in link is locked with $ signs (=January!$A$1).
If I copy a range of cells and paste links, the referenced cells in links are not locked (=January!A1, =January!A2,...).
How can I do that? To paste links with absolute references, if I copy a range of cells?
Thanks in advance.
If I copy one cell and paste link to another cell, the referenced cell in link is locked with $ signs (=January!$A$1).
If I copy a range of cells and paste links, the referenced cells in links are not locked (=January!A1, =January!A2,...).
How can I do that? To paste links with absolute references, if I copy a range of cells?
Thanks in advance.