Hyperlinks are great for getting around an Excel spreadsheet but they are very specific and don't change when your cells move around. A method, using the Hyperlink formula, to allow the hyperlink to follow the cells around even if they move to another sheet.
------------------------------------------------------------------------------------------------------------------------------------------------------
✅- Free check of your Excel Skill Level- excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- online-excel-training.auditex...
🇿🇦- Our main website- www.auditexcel.co.za/blogs/
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Hyperlink not working if cells move
00:24 Link to the cell you want to follow
00:40 Extract the path to the cell for use in Hyperlink
01:07 Remove the '=' sign, just the path to your link
01:30 Create the hyperlink
02:10 Hyperlink links to the cell you pointed at initially
02:24 Move the link cells to a new sheet & the hyperlink follows.
Негізгі бет Hyperlinks in Excel (formula)- tying to specific cells
Пікірлер: 30