SoonTool
Simple, Practical, Useful
English

Excel Shortcuts Reference

Comprehensive Excel keyboard shortcuts reference with detailed usage scenarios, practical tips, and learning recommendations.

Basic Operations
12
Ctrl + C
Copy selected cells or content
Usage:
Select cells → Press Ctrl + C → Content is copied to clipboard
Use Cases:
Tips:
copyduplicateclipboardbasic
Ctrl + V
Paste copied content into selected cells
Usage:
Select target cell → Press Ctrl + V → Content is pasted
Use Cases:
Tips:
pasteinsertclipboardbasic
Ctrl + X
Cut selected cells or content
Usage:
Select cells → Press Ctrl + X → Content is cut and ready to paste
Use Cases:
Tips:
cutmoveclipboardbasic
Ctrl + Z
Undo the last action
Usage:
Press Ctrl + Z → Last action is undone
Use Cases:
Tips:
undorevertbackbasic
Ctrl + Y
Redo the last undone action
Usage:
Press Ctrl + Y → Last undone action is redone
Use Cases:
Tips:
redorestoreforwardbasic
Ctrl + A
Select all content in worksheet or current region
Usage:
Press Ctrl + A → All content is selected
Use Cases:
Tips:
select allentirebulkbasic
Ctrl + S
Save the current workbook
Usage:
Press Ctrl + S → Workbook is saved
Use Cases:
Tips:
savestorebackupbasic
Ctrl + O
Open existing workbook
Usage:
Press Ctrl + O → Open dialog appears
Use Cases:
Tips:
openloadbrowsebasic
Ctrl + N
Create new workbook
Usage:
Press Ctrl + N → New blank workbook opens
Use Cases:
Tips:
newcreatestartbasic
Ctrl + P
Open print dialog
Usage:
Press Ctrl + P → Print dialog appears
Use Cases:
Tips:
printoutputpdfbasic
Ctrl + F
Find text or values in worksheet
Usage:
Press Ctrl + F → Find dialog opens
Use Cases:
Tips:
findsearchlocatebasic
Ctrl + H
Find and replace text or values
Usage:
Press Ctrl + H → Find and Replace dialog opens
Use Cases:
Tips:
replacefindupdatebasic
Cell Operations
15
Enter
Move to cell below or complete cell entry
Usage:
Press Enter → Move to cell below or complete entry
Use Cases:
Tips:
entermove downcompletecell
Tab
Move to cell to the right or complete cell entry
Usage:
Press Tab → Move to cell to the right or complete entry
Use Cases:
Tips:
tabmove rightcompletecell
Shift + Tab
Move to cell to the left
Usage:
Press Shift + Tab → Move to cell to the left
Use Cases:
Tips:
shift tabmove leftbackwardcell
Arrow Keys
Navigate between cells in any direction
Usage:
Press Arrow Key → Move in that direction
Use Cases:
Tips:
arrownavigatemovecell
Ctrl + Arrow
Jump to edge of data region in arrow direction
Usage:
Press Ctrl + Arrow → Jump to data boundary
Use Cases:
Tips:
ctrl arrowjumpboundarycell
Shift + Arrow
Extend selection in arrow direction
Usage:
Press Shift + Arrow → Extend selection
Use Cases:
Tips:
shift arrowselectextendcell
Ctrl + Shift + Arrow
Select from current cell to edge of data region
Usage:
Press Ctrl + Shift + Arrow → Select to data boundary
Use Cases:
Tips:
ctrl shift arrowselect rangedatacell
Home
Move to beginning of current row
Usage:
Press Home → Move to column A of current row
Use Cases:
Tips:
homerow startbeginningcell
Ctrl + Home
Move to cell A1
Usage:
Press Ctrl + Home → Move to cell A1
Use Cases:
Tips:
ctrl homea1origincell
End
Move to end of current row
Usage:
Press End → Move to last column with data in current row
Use Cases:
Tips:
endrow endboundarycell
Ctrl + End
Move to last cell with data
Usage:
Press Ctrl + End → Move to last cell with data
Use Cases:
Tips:
ctrl endlast cellboundarycell
Page Up
Move up one screen
Usage:
Press Page Up → Move up one screen height
Use Cases:
Tips:
page upscroll upscreencell
Page Down
Move down one screen
Usage:
Press Page Down → Move down one screen height
Use Cases:
Tips:
page downscroll downscreencell
Ctrl + Page Up
Move to previous worksheet
Usage:
Press Ctrl + Page Up → Move to previous worksheet
Use Cases:
Tips:
ctrl page upprevious sheetworkbookcell
Ctrl + Page Down
Move to next worksheet
Usage:
Press Ctrl + Page Down → Move to next worksheet
Use Cases:
Tips:
ctrl page downnext sheetworkbookcell
Formatting
12
Ctrl + B
Apply or remove bold formatting
Usage:
Select cells → Press Ctrl + B → Bold formatting toggled
Use Cases:
Tips:
boldemphasisformattingtext
Ctrl + I
Apply or remove italic formatting
Usage:
Select cells → Press Ctrl + I → Italic formatting toggled
Use Cases:
Tips:
italicemphasisformattingtext
Ctrl + U
Apply or remove underline formatting
Usage:
Select cells → Press Ctrl + U → Underline formatting toggled
Use Cases:
Tips:
underlineemphasisformattingtext
Ctrl + 1
Open Format Cells dialog
Usage:
Select cells → Press Ctrl + 1 → Format Cells dialog opens
Use Cases:
Tips:
format cellsdialogadvancedformatting
Ctrl + Shift + F
Open Format Cells dialog with Font tab
Usage:
Select cells → Press Ctrl + Shift + F → Font formatting dialog opens
Use Cases:
Tips:
fontformattingtextstyle
Ctrl + Shift + P
Open Format Cells dialog with Number tab
Usage:
Select cells → Press Ctrl + Shift + P → Number formatting dialog opens
Use Cases:
Tips:
numberformattingcustomstyle
Alt + H
Access Home tab ribbon
Usage:
Press Alt + H → Home tab ribbon activated
Use Cases:
Tips:
home tabribbonaccessformatting
Alt + H + F + A
Access AutoFit column width
Usage:
Select column → Press Alt + H + F + A → Column auto-fits content
Use Cases:
Tips:
autofitcolumn widthformattingsize
Alt + H + F + C
Access column width dialog
Usage:
Select column → Press Alt + H + F + C → Column width dialog opens
Use Cases:
Tips:
column widthdialogformattingsize
Alt + H + F + O
Access row height dialog
Usage:
Select row → Press Alt + H + F + O → Row height dialog opens
Use Cases:
Tips:
row heightdialogformattingsize
Alt + H + F + S
Access AutoFit row height
Usage:
Select row → Press Alt + H + F + S → Row auto-fits content
Use Cases:
Tips:
autofitrow heightformattingsize
Alt + H + F + T
Access default column width dialog
Usage:
Press Alt + H + F + T → Default column width dialog opens
Use Cases:
Tips:
defaultcolumn widthformattingsetup
Formulas & Functions
10
F2
Edit active cell or formula
Usage:
Select cell → Press F2 → Enter edit mode
Use Cases:
Tips:
editformulacellfunction
Ctrl + Shift + Enter
Enter array formula
Usage:
Type formula → Press Ctrl + Shift + Enter → Array formula entered
Use Cases:
Tips:
array formulaadvancedcalculationfunction
Ctrl + Shift + A
Insert function arguments
Usage:
Type function name → Press Ctrl + Shift + A → Arguments inserted
Use Cases:
Tips:
function argumentssyntaxformulafunction
Ctrl + Shift + U
Expand or collapse formula bar
Usage:
Press Ctrl + Shift + U → Formula bar toggles size
Use Cases:
Tips:
formula barexpandviewfunction
Alt + F11
Open Visual Basic Editor
Usage:
Press Alt + F11 → Visual Basic Editor opens
Use Cases:
Tips:
vbamacroprogrammingfunction
Ctrl + F3
Open Name Manager
Usage:
Press Ctrl + F3 → Name Manager dialog opens
Use Cases:
Tips:
name managernamed rangesorganizationfunction
Ctrl + Shift + F3
Create names from selection
Usage:
Select range with headers → Press Ctrl + Shift + F3 → Create names dialog opens
Use Cases:
Tips:
create namesnamed rangesorganizationfunction
F9
Calculate all worksheets
Usage:
Press F9 → All worksheets recalculated
Use Cases:
Tips:
calculaterecalculateformulafunction
Ctrl + F9
Calculate active worksheet
Usage:
Press Ctrl + F9 → Active worksheet recalculated
Use Cases:
Tips:
calculateworksheetformulafunction
Shift + F9
Calculate active worksheet
Usage:
Press Shift + F9 → Active worksheet recalculated
Use Cases:
Tips:
calculateworksheetformulafunction
Navigation & Selection
10
F5
Open Go To dialog
Usage:
Press F5 → Go To dialog opens
Use Cases:
Tips:
go tonavigatejumpnavigation
Ctrl + G
Open Go To dialog
Usage:
Press Ctrl + G → Go To dialog opens
Use Cases:
Tips:
go tonavigatejumpnavigation
Ctrl + F
Find text or values in worksheet
Usage:
Press Ctrl + F → Find dialog opens
Use Cases:
Tips:
findsearchlocatebasic
Ctrl + H
Find and replace text or values
Usage:
Press Ctrl + H → Find and Replace dialog opens
Use Cases:
Tips:
replacefindupdatebasic
F3
Paste name into formula
Usage:
In formula → Press F3 → Paste name dialog opens
Use Cases:
Tips:
paste namenamed rangeformulanavigation
Ctrl + Shift + O
Select all cells with comments
Usage:
Press Ctrl + Shift + O → All cells with comments selected
Use Cases:
Tips:
select commentscommentsreviewnavigation
Alt + Page Up
Move one screen to the left
Usage:
Press Alt + Page Up → Move one screen width left
Use Cases:
Tips:
page leftscroll lefthorizontalnavigation
Alt + Page Down
Move one screen to the right
Usage:
Press Alt + Page Down → Move one screen width right
Use Cases:
Tips:
page rightscroll righthorizontalnavigation
Ctrl + Page Up
Move to previous worksheet
Usage:
Press Ctrl + Page Up → Move to previous worksheet
Use Cases:
Tips:
ctrl page upprevious sheetworkbookcell
Ctrl + Page Down
Move to next worksheet
Usage:
Press Ctrl + Page Down → Move to next worksheet
Use Cases:
Tips:
ctrl page downnext sheetworkbookcell
Instructions

How to Use

  • Enter shortcut names, descriptions, or keywords in the search box
  • Click on shortcut cards to view detailed information and use cases
  • Click copy buttons to quickly copy shortcuts
  • Use collapsible panels to view detailed tips and scenarios

Features

  • Contains commonly used Excel shortcuts organized by category
  • Detailed usage instructions and practical scenarios
  • Rich learning tips and best practices
  • Keyword search for quick shortcut location

Learning Tips

  • Start with basic operations shortcuts (Ctrl+C, Ctrl+V, etc.)
  • Practice cell navigation shortcuts to improve efficiency
  • Learn formatting shortcuts to speed up document styling
  • Master formula shortcuts for advanced Excel operations
Related Tools
Excel Common Formulas
Provides detailed explanations, syntax usage, and practical examples of common Excel formulas to help you quickly master Excel formula techniques.
Excel Shortcuts Reference
Comprehensive Excel keyboard shortcuts reference with detailed usage scenarios, practical tips, and learning recommendations.
Online Drawing Board
Powerful online drawing tool with multiple brush types, color selection, save records and download functionality. Provides brush, highlighter, eraser tools with undo/redo and work management.
International Tariff Cost Calculator
Professional international tariff cost calculation tool to help you quickly estimate the impact of tariff policy changes on product costs, providing reference for international trade decisions.
Project Progress Manager
Professional project progress management tool with milestone tracking, risk alerts, progress visualization and more.
Emoji Picker
Rich emoji picker with six categories including smileys, animals, food, travel, objects and symbols, supporting search and quick copy functionality.
AI Power Consumption Calculator
Professional AI model training power consumption estimation tool. Calculate total power consumption, electricity costs, carbon emissions, and GPU power usage. Provides model presets and real-time calculation with comparison analysis.
Layoff Compensation Calculator
Professional layoff compensation calculator that calculates compensation based on city coefficients and work experience. Supports major cities nationwide, provides real-time calculation and detailed breakdown to help you understand potential compensation amounts.
BMI License Fee Calculator
Professional BMI music licensing fee calculator for businesses. Calculate estimated annual licensing fees based on venue type, capacity, music usage type, and frequency. Provides detailed breakdown and important disclaimers.
soontool.com
常用工具热门推荐轻松办公生活周边情绪价值健康养生亲子育儿风水姓氏网站工具RecordRecommendationOfficeLifestyleEntertainmentHealthParentingFortuneWebsite记账本BMI健康计算器驴磨工坊愿望清单音乐点击墙健康饮水助手最佳睡眠时长查询车牌前缀查询车牌归属地查询大模型Token测算Markdown实时预览房贷计算器碳中和计算器摸鱼时光数羊羊助眠神器催眠神器性格分析工具模拟炒股颜色搭配宝宝体重计算器宝宝身高计算器狗狗年龄计算器儿童体重计算器儿童身高计算器养娃成本估算器时间转换工具Linux命令大全Git命令大全Vim命令大全Excel常用公式Excel快捷键大全生肖查询星座查询网址收藏夹二维码生成器条形码生成器在线画板涂鸦在线加解密工具文本对比工具JSON格式化工具JSON对比工具正则表达式预览工具字符分割和格式化工具衣服尺寸查询工具时薪计算器税后工资计算器国际关税成本测算卡路里计算器待办事项管理项目进度管理跳一跳游戏垃圾分类查询工具PayPal手续费计算器地震查询工具投胎模拟器浪浪山小妖升职模拟器Emoji表情包选择器屏幕尺寸计算器牛马自由评估计算器运势抽签养车成本预估计算器自动驾驶分级查询人生格子AI消耗电量预估计算器裁员补偿估算BMI许可费计算器在线钢琴模拟器日期计算器Account BookBMI Health CalculatorDonkey Mill WorkshopWish ListMusic Click WallHealth Water HelperHuman Optimal Sleep Duration CalculatorLicense Plate QueryLicense Plate Origin QueryLLM Token CalculatorMarkdown Live PreviewMortgage CalculatorCarbon Neutral CalculatorRelax TimeSheep Counter - Sleep AidHypnosis ToolPersonality Analysis ToolStock Trading SimulatorColor PaletteBaby Weight CalculatorBaby Height CalculatorDog Age CalculatorChild Weight CalculatorChild Height CalculatorChild Rearing Cost CalculatorTime ConverterLinux Commands ReferenceGit Commands ReferenceVim Commands ReferenceExcel Common FormulasExcel Shortcuts ReferenceZodiac QueryConstellation QueryBookmark ManagerQR Code GeneratorBarcode GeneratorOnline Drawing BoardOnline Encryption ToolText Diff ToolJSON FormatterJSON Diff ToolRegular Expression Preview ToolText Splitter and FormatterClothing Size CalculatorHourly Wage CalculatorAfter-Tax Salary CalculatorInternational Tariff Cost CalculatorCalorie CalculatorTodo List ManagerProject Progress ManagerJump GameGarbage Sorting Query ToolPayPal Fee CalculatorEarthquake Query ToolReincarnation SimulatorLanglang Mountain Goblin Promotion SimulatorEmoji PickerScreen Size CalculatorCattle Horse Freedom CalculatorFortune StickCar Cost CalculatorAutonomous Driving Levels QueryLife GridAI Power Consumption CalculatorLayoff Compensation CalculatorBMI License Fee CalculatorOnline Piano SimulatorDate Calculator