Excel can change Row to Colume, where?
2007-08-21 6:00 am
As I know, Excel have a function that can "Row" to "Colume", can anyone teach me in chinese? "欄" 轉 "列"? Thx!
回答 (1)
2007-08-21 6:43 am
✔ 最佳答案
可以用複制/選擇性貼上功能,步驟如下:1. 先選取所需轉換的儲存格,
2. 按滑鼠右鍵, 選擇功能 [ 複制 ] 以複制儲存格
3. 選擇其他空置儲存格,
4. 按滑鼠右鍵, 選擇功能 [ 選擇性貼上 ], 並剔選 [ 轉置 ] 選項, 再按 [ 確定 ]
收錄日期: 2021-04-13 13:22:24
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070820000051KK05631