--- disqus: ahb0222 GA : G-CQ4L16KHK4 --- # LINE 社群解答紀錄 > [color=#40f1ef][name=LHB阿好伯, 2021/07/20][:earth_africa:](https://www.facebook.com/LHB0222/) ###### tags: `Excel` `Word` `PowerPoint` [TOC] # Excel ## 進出數量不相符跳提醒 :::danger ![](https://i.imgur.com/ZJANoQU.png) ![](https://i.imgur.com/dCIjT7O.png) ::: :::success ![](https://i.imgur.com/J4r86XR.png) 若一開始無資料錯誤樣式不能使用停止 應改為資訊 ![](https://i.imgur.com/ytGaHDx.png) ![](https://i.imgur.com/qDWwg7R.gif) ::: ## 篩選後圖片位置錯誤 :::danger ![](https://i.imgur.com/PNfRbfO.png) ::: :::success 修改圖片屬性即可 ![](https://i.imgur.com/kM8LlaK.png) ![](https://i.imgur.com/bpkii5j.gif) ::: ## 核選方塊更新表格 :::danger ![](https://i.imgur.com/fvb8JJL.png) ![](https://i.imgur.com/O2XzbAg.png) [相關檔案](https://drive.google.com/file/d/1DwRH7NxKy1Ua3c-_W-8bf4dAojAmfVR8/view?usp=sharing) ::: :::success 先將核選方塊連結到儲存格中 以利後續篩選 ![](https://i.imgur.com/BGTjBP5.png) 調整圖片屬性免得篩選後發生錯誤 ![](https://i.imgur.com/2f33wwB.png) 使用錄製方式將篩選->複製->貼上等動作錄製下來 ![](https://i.imgur.com/VwRkGf8.gif) [相關檔案]( https://1drv.ms/x/s!AuqcoLPA0_SIk7pV1i61vT7W-Y9bLQ?e=9sA0MJ) ::: 🌟全文可以至下方連結觀看或是補充 全文分享至 https://www.facebook.com/LHB0222/ https://www.instagram.com/ahb0222/ 有疑問想討論的都歡迎於下方留言 喜歡的幫我分享給所有的朋友 \o/ 有所錯誤歡迎指教 # [:page_with_curl: 全部文章列表](https://hackmd.io/@LHB-0222/AllWritings) ![](https://i.imgur.com/nHEcVmm.jpg)