---
# System prepended metadata

title: LINE 社群解答紀錄
tags: [PowerPoint, Word, Excel]

---

---
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)


