随時更新します。

  • F1: ヘルプ
  • F2: 編集モードにする
  • F4: 直前の動作を繰り返す
  • F5: ジャンプダイアログ
  • F9: 再計算
  • F12: 名前をつけて保存
  • =: Formula
  • Insert: 挿入モード
  • Delete: アクティブセル内容を削除
  • Home: 表の初めのセルに移動
  • End: 表の終わりのセルに移動
  • Page Up: ページアップ
  • Page Down: ページダウン
  • Left Arrow: 左へ移動
  • Right Arrow: 右へ移動
  • Up Arrow: 上へ移動
  • Down Arrow: 下へ移動
  • Space Bar: スペース
  • Tab: 右へ移動
  • Shift+F1: What’s This Help
  • Shift+F2: Edit Comment
  • Shift+F3: Insert Function
  • Shift+F4: Find Again (With Find Open)
  • Shift+F5: Find
  • Shift+F6: Previous Pane
  • Shift+F8: Add To Selection
  • Shift+F9: Calculate Worksheet
  • Shift+F10: Right Click Menu
  • Shift+F11: New Worksheet
  • Shift+F12: Save
  • Shift+Left Arrow: Select Left
  • Shift+Right Arrow: Select Right
  • Shift+Up Arrow: Select Up
  • Shift+Down Arrow: Select Down
  • Shift+Space Bar: Select Row
  • Shift+Tab: Move Left
  • Ctrl+F3: Open Name Manager
  • Ctrl+F4: Close Window
  • Ctrl+F5: Restore Window Size
  • Ctrl+F6: Next Workbook
  • Ctrl+F7: Move Window
  • Ctrl+F8: Resize Window
  • Ctrl+F9: Minimize Workbook
  • Ctrl+F10: Restore Workbook
  • Ctrl+F11: New Macro Sheet
  • Ctrl+F12: Open
  • Ctrl+A: Select All 
  • Ctrl+B: Bold Selection
  • Ctrl+C: Copy Selection
  • Ctrl+D: Fill Down
  • Ctrl+F: Open Find Menu
  • Ctrl+G: Open Goto Dialog Box
  • Ctrl+H: Open Find/Replace Menu
  • Ctrl+I: Italicize Selection
  • Ctrl+K: Insert Hyperlink
  • Ctrl+N: New Workbook
  • Ctrl+O: Open Workbook
  • Ctrl+P: Print
  • Ctrl+R: Fill Right
  • Ctrl+S: Save
  • Ctrl+U: Underline Selection
  • Ctrl+V: Paste
  • Ctrl+W: Close Workbook
  • Ctrl+X: Cut
  • Ctrl+Y: Redo
  • Ctrl+Z: Undo
  • Ctrl+`: Toggle Formula View
  • Ctrl+1: Open Format Cell Menu
  • Ctrl+2: Bold Selection
  • Ctrl+3: Italicize Selection
  • Ctrl+4: Underline Selection
  • Ctrl+5: Strikethrough Selection
  • Ctrl+8: Outline
  • Ctrl+9: Hide Selected Rows
  • Ctrl+0: Hide Selected Columns
  • Ctrl+-: Delete Selection
  • Ctrl+[: Go to Dependents
  • Ctrl+]: All Dependents
  • Ctrl+;: Insert Date
  • Ctrl+/: Select Array
  • Ctrl+: Select Differences
  • Ctrl+Insert: Copy
  • Ctrl+Delete: Delete To End Of Line
  • Ctrl+Home: Start Of Worksheet
  • Ctrl+End: End Of Worksheet
  • Ctrl+Page Up: Previous Worksheet
  • Ctrl+Page Down: Next Worksheet
  • Ctrl+Left Arrow: Move to Next Cell With Data to Left
  • Ctrl+Right Arrow: Move to Next Cell With Data to Right
  • Ctrl+Up Arrow: Move to Next Cell With Data Above
  • Ctrl+Down Arrow: Move to Next Cell With Data Below
  • Ctrl+Space Bar: Select Column
  • Ctrl+Tab: Next Window
  • Ctrl+BackSpace: Goto Active Cell
  • Alt+F1: Insert Chart in Current Sheet
  • Alt+F2: Save As
  • Alt+F4: Quit Excel
  • Alt+F6: Switch To VBA
  • Alt+F8: Open Macro List
  • Alt+F11: Open VB Editor
  • Alt+D: Open Data Menu
  • Alt+E: Open Edit Menu
  • Alt+F: Open File Menu
  • Alt+H: Open Help Menu
  • Alt+I: Open Insert Menu
  • Alt+O: Open Format Menu
  • Alt+T: Open Tools Menu
  • Alt+W: Open Window Menu
  • Ctrl+Shift+F3: Create Names From Selection
  • Ctrl+Shift+F6: Previous Workbook
  • Ctrl+Shift+F12: Print
  • Ctrl+Shift+A: Formula Arguments
  • Ctrl+Shift+F: Fomat Cells Font Tab
  • Ctrl+Shift+O: Select Comments
  • Ctrl+Shift+P: Fomat Cells Font Tab
  • Ctrl+Shift+`: Format Cells – General Format
  • Ctrl+Shift+1: Format Cells – Number Format
  • Ctrl+Shift+2: Format Cells – Time Format
  • Ctrl+Shift+3: Format Cells – Date Format
  • Ctrl+Shift+4: Format Cells – Currency Format
  • Ctrl+Shift+5: Format Cells – Percent Format
  • Ctrl+Shift+6: Format Cells – Exponent Format
  • Ctrl+Shift+7: Format Cells – Apply Border
  • Ctrl+Shift+8: Select Region
  • Ctrl+Shift+9: Unhide Rows
  • Ctrl+Shift+0: Unhide Columns
  • Ctrl+Shift+-: Format Cells – Remove Border
  • Ctrl+Shift+=: Open Insert Dialog Box
  • Ctrl+Shift+[: Direct Precedents
  • Ctrl+Shift+]: All Precedents
  • Ctrl+Shift+;: Insert Time
  • Ctrl+Shift+’: Copy Cell Value Above
  • Ctrl+Shift+/: Select Array
  • Ctrl+Shift+: Select Unequal Cells
  • Ctrl+Shift+Space Bar: Select All
  • Ctrl+Shift+Tab: Previous Window
おすすめの記事