---
# System prepended metadata

title: excel 資料剖析-表格練習

---

excel資料剖析練習
===
### 1.複製文件資料
![](https://hackmd.io/_uploads/rktVwhBv3.jpg)

### 2.貼到excel
![](https://hackmd.io/_uploads/HyR9v3Hvn.jpg)

### 3.將excel A欄寬度，拉開到文件適合寬度
![](https://hackmd.io/_uploads/Hysq_3SDn.jpg)
![](https://hackmd.io/_uploads/SkEiu3Hv2.jpg)

### 4.選取A欄裡，想要剖析的資料
![](https://hackmd.io/_uploads/Bky-tYUP3.jpg)

### 5.點擊excel功能分類的"資料"項目，找到資料剖析
![](https://hackmd.io/_uploads/ryMotKUDh.jpg)

### 6.步驟一 直接點選下一步
![](https://hackmd.io/_uploads/SJ6T5tUv2.jpg)

步驟二、將tab鍵選項取消，改為以"空格"為切割選項
![](https://hackmd.io/_uploads/SJUrjt8wh.jpg)

步驟三、直接點選完成
![](https://hackmd.io/_uploads/H1AIsKUv3.jpg)


### 7.將欄寬度拉寬至適合寬度，將讓資料能在格子裡
![](https://hackmd.io/_uploads/S1EToYUP3.jpg)

### 8.使用選取、搬移技巧，將資料搬到正確位置
![](https://hackmd.io/_uploads/B1XXnKUPh.jpg)


### 9.調整A、B、C欄位寬度
![](https://hackmd.io/_uploads/rysaht8P3.jpg)

### 10.選取資料加上框線
![](https://hackmd.io/_uploads/ryb8pKLwn.jpg)

![](https://hackmd.io/_uploads/rkqI6YUPh.jpg)

### 11.選取excel資料，複製貼到google文件上
![](https://hackmd.io/_uploads/S1NIRYLD2.jpg)

### 12.選取表格內範圍
![](https://hackmd.io/_uploads/Hyp80t8Pn.jpg)

### 13.選取--格式/表格/表格屬性，將"顏色"選項寬度，改為1pt
![](https://hackmd.io/_uploads/BkWClqLDh.jpg)

### 14.可以調整字形大小、行距，將頁面縮至一頁顯示
![](https://hackmd.io/_uploads/BJvMb58wh.jpg)

![](https://hackmd.io/_uploads/r1k7W98vh.jpg)
















