---
# System prepended metadata

title: '[Excel] 選取特殊目標'
tags: [空格, EXCEL, 特殊目標]

---

# Excel 選取特殊目標

**Step.1 表格全選**

![](https://i.imgur.com/4IL8rI2.png)


**Step.2 CTRL + G**
到 >> 特殊 >> 空白
![](https://i.imgur.com/RD1jCYE.png)
↓
![](https://i.imgur.com/C63H4EG.png)

**Step.3** 
直接打=(儲存格上方那格的位置)
★按CTRL + ENTER

![](https://i.imgur.com/xY2zShq.png)

成功
![](https://i.imgur.com/2MM49lp.png)


https://medium.com/%E6%97%A5%E5%B8%B8%E5%85%AC%E5%BC%8F/excel-%E9%81%B8%E5%8F%96%E5%8A%A0%E9%80%9F%E5%99%A8-ede72395b86

###### tags: `EXCEL` `特殊目標` `空格`