10/09/2026
📸 你知唔知 Excel 入面收埋咗個 Camera Tool?
佢唔係普通截圖 —— Camera 嘅相片會同原本嘅儲存格範圍保持連結。只要數據或格式一變,張相就會自動更新,整 KPI Dashboard、月度報告、財務模型嗰陣超好用 💡
點樣用:
1. 將 Camera 加入 Quick Access Toolbar
2. 揀選你想 capture 嘅儲存格範圍
3. 撳 Camera,然後將張動態圖放喺工作簿嘅任何位置
搵唔到 Camera?視乎你嘅 Excel 版本,可以試吓 Paste > Linked Picture 🧩
記得 save 低呢個 Post,下次做報表嗰陣試吓用啦!✅
📸Did you know Excel has a hidden Camera Tool?
Unlike a normal screenshot, a Camera picture stays linked to the original cell range. When the data or formatting changes, the picture updates automatically — making it useful for KPI dashboards, monthly reports and financial models. 💡
How to use it:
1. Add Camera to the Quick Access Toolbar.
2. Select the cell range you want to capture.
3. Click Camera, then place the live picture anywhere in the workbook. ✅
Can’t find Camera? Depending on your Excel version, try Paste > Linked Picture. 🧩
Save this post and try it in your next report!