# 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` `特殊目標` `空格`