請指教： 我如何在Excel裡,不使用mouse,只用keyboard shortcut key 來select column ?
回答 (2)
2015-10-12 7:12 am
keyboard shortcut key to select whole column:
CTRL+SPACEBAR
Select the entire column.
Other shortcut keys:
SHIFT+SPACEBAR
Select the entire row.
CTRL+A
Select the entire worksheet.
SHIFT+BACKSPACE
With multiple cells selected, select only the active cell.
CTRL+SHIFT+SPACEBAR
With an object selected, select all objects on a sheet.
CTRL+6
Alternate between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+SPACEBAR
Select the entire column.
Other shortcut keys:
SHIFT+SPACEBAR
Select the entire row.
CTRL+A
Select the entire worksheet.
SHIFT+BACKSPACE
With multiple cells selected, select only the active cell.
CTRL+SHIFT+SPACEBAR
With an object selected, select all objects on a sheet.
CTRL+6
Alternate between hiding objects, displaying objects, and displaying placeholders for objects.
2015-10-12 7:11 am
愚見供參…
按下CTRL+G，就可以鍵入想要的儲存格位置
例如B15、C:C或3:3等
按下CTRL+G，就可以鍵入想要的儲存格位置
例如B15、C:C或3:3等
收錄日期: 2021-04-20 16:02:44
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20151011222221AATL800