Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/zhang-wo-ji-qiao-jing-zhun-zhui-zong-dan-yuan-ge-de-guan-lian-dong-tai.html
"Master the skill: accurately track the correlation dynamics of cells"
At work, we often need to deal with various data tables. If you want to see which other cells reference the data of a cell, you can follow the steps below: 1. Taking a table as an example, suppose we want to know which cells the F9 cell where employee A's "commission ratio" is located is referenced. Quote. 2. Hover the mouse over cell F9, and then click "Formulas" -> "Track Dependent Cells" in the menu bar above. At this time, an arrow will appear in the table, indicating that the data in cell F9 is referenced. 3. Through these arrows, we can know that the data in cell F9 is referenced by cells K2, K3, K4, K5 and K6. 4. If you need to remove these arrows, you can click "Remove Arrows" -> "Remove Dependent Cell Tracking Arrows". The following are links to image resources mentioned in the original article: - Tutorial dividing line picture: [Tutorial dividing line.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/bccf8f501a092ee62d67745e209abab1.png)- Operation demonstration GIF of tracking slave cells: [1.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/45bc61d53a6078bc55d21f64600f855d.gif)- Operation demonstration of removing the tracking arrow of slave cells GIF: [2.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/55e3e7d9d586043176476bcacd550a3a.gif) Please note that since this is a text reply, video and picture content cannot be displayed directly. If you need to watch the video, please use the following link: - Video tutorial: [6d4db68f382b1f00c37c32887368ad76.mp4](https://font2020.oss-cn-beijing.aliyuncs.com/wps/videos/6d4db68f382b1f00c37c32887368ad76.mp4)
Like (810)
Reward
支付宝扫一扫
![支付宝扫一扫](/wpcom/picture/wechat_shoukuan.jpg)
评论列表(196条)
测试