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
Image Format Converter
Convert between SVG, WebP, PNG, JPG and Base64. Support drag & drop, preview, target format, quality/size settings, download and clipboard copy.
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.
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.
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.
Emoji Picker
Rich emoji picker with six categories including smileys, animals, food, travel, objects and symbols, supporting search and quick copy functionality.
Project Progress Manager
Professional project progress management tool with milestone tracking, risk alerts, progress visualization and more.
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.
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.
Excel Shortcuts Reference
Comprehensive Excel keyboard shortcuts reference with detailed usage scenarios, practical tips, and learning recommendations.
Excel Common Formulas
Provides detailed explanations, syntax usage, and practical examples of common Excel formulas to help you quickly master Excel formula techniques.
soontool.com
常用工具热门推荐轻松办公生活周边情绪价值健康养生亲子育儿风水姓氏网站工具RecordRecommendationOfficeLifestyleEntertainmentHealthParentingFortuneWebsite在线字帖工具九宫格切图工具心情日历图片格式转换器反向PUA神器体重记录仪日期计算器在线钢琴模拟器BMI许可费计算器裁员补偿估算AI消耗电量预估计算器人生格子自动驾驶分级查询养车成本预估计算器运势抽签牛马自由评估计算器屏幕尺寸计算器Emoji表情包选择器浪浪山小妖升职模拟器投胎模拟器地震查询工具PayPal手续费计算器垃圾分类查询工具跳一跳游戏项目进度管理待办事项管理卡路里计算器国际关税成本测算税后工资计算器时薪计算器衣服尺寸查询工具字符分割和格式化工具正则表达式预览工具JSON对比工具JSON格式化工具文本对比工具在线加解密工具在线画板涂鸦条形码生成器二维码生成器网址收藏夹星座查询生肖查询Excel快捷键大全Excel常用公式Vim命令大全Git命令大全Linux命令大全时间转换工具养娃成本估算器儿童身高计算器儿童体重计算器狗狗年龄计算器宝宝身高计算器宝宝体重计算器颜色搭配模拟炒股性格分析工具催眠神器数羊羊助眠神器摸鱼时光碳中和计算器房贷计算器Markdown实时预览AI大模型费用计算器大模型Token测算车牌归属地查询车牌前缀查询睡眠周期计算器最佳睡眠时长查询健康饮水助手音乐点击墙愿望清单驴磨工坊BMI健康计算器记账本Online Copybook GeneratorGrid Image CutterMood CalendarImage Format ConverterReverse PUA MasterWeight RecorderDate CalculatorOnline Piano SimulatorBMI License Fee CalculatorLayoff Compensation CalculatorAI Power Consumption CalculatorLife GridAutonomous Driving Levels QueryCar Cost CalculatorFortune StickCattle Horse Freedom CalculatorScreen Size CalculatorEmoji PickerLanglang Mountain Goblin Promotion SimulatorReincarnation SimulatorEarthquake Query ToolPayPal Fee CalculatorGarbage Sorting Query ToolJump GameProject Progress ManagerTodo List ManagerCalorie CalculatorInternational Tariff Cost CalculatorAfter-Tax Salary CalculatorHourly Wage CalculatorClothing Size CalculatorText Splitter and FormatterRegular Expression Preview ToolJSON Diff ToolJSON FormatterText Diff ToolOnline Encryption ToolOnline Drawing BoardBarcode GeneratorQR Code GeneratorBookmark ManagerConstellation QueryZodiac QueryExcel Shortcuts ReferenceExcel Common FormulasVim Commands ReferenceGit Commands ReferenceLinux Commands ReferenceTime ConverterChild Rearing Cost CalculatorChild Height CalculatorChild Weight CalculatorDog Age CalculatorBaby Height CalculatorBaby Weight CalculatorColor PaletteStock Trading SimulatorPersonality Analysis ToolHypnosis ToolSheep Counter - Sleep AidRelax TimeCarbon Neutral CalculatorMortgage CalculatorMarkdown Live PreviewAI Model Cost CalculatorLLM Token CalculatorLicense Plate Origin QueryLicense Plate QuerySleep Cycle CalculatorHuman Optimal Sleep Duration CalculatorHealth Water HelperMusic Click WallWish ListDonkey Mill WorkshopBMI Health CalculatorAccount Book