Microsoft Office
Excel Shortcuts
Productivity shortcuts for Word, Excel, PowerPoint
Bold
FormattingMake selected text bold
Italic
FormattingMake selected text italic
Underline
FormattingUnderline selected text
Merge Cells
FormattingMerge selected cells into one
Center Align
FormattingCenter align cell content
Go to Cell
NavigationNavigate directly to specific cell
Find and Replace
EditFind and replace text
Insert Row
InsertInsert row above selected row
Insert Column
InsertInsert column to left of selected column
Delete Row
EditDelete selected row
Delete Column
EditDelete selected column
AutoSum
DataAuto calculate sum of selected range
Format Cells
FormattingOpen Format Cells dialog
Insert Chart
InsertCreate chart from selected data
Freeze Panes
ViewFreeze panes above and left of selected cell
Insert Function
DataOpen Insert Function dialog
Auto Calculate
DataRecalculate worksheet
Absolute Reference
DataToggle cell reference to absolute
Fill Down
EditCopy selected cells down
Fill Right
EditCopy selected cells right
Fill Series
DataCreate series data
Data Validation
DataOpen Data Validation dialog
Conditional Formatting
FormattingApply conditional formatting
Remove Duplicates
DataRemove duplicate data
Sort Ascending
DataSort selected range in ascending order
Sort Descending
DataSort selected range in descending order
Filter
DataApply or remove filter
Pivot Table
DataCreate pivot table
Chart Wizard
InsertOpen Chart Wizard
Insert Table
InsertInsert table
Name Manager
DataOpen Name Manager dialog
Go to Special
NavigationSelect special cells
Hide Columns
ViewHide selected columns
Hide Rows
ViewHide selected rows
Unhide Columns
ViewShow hidden columns
Unhide Rows
ViewShow hidden rows
Group Columns
DataGroup selected columns
Group Rows
DataGroup selected rows
Ungroup
DataUngroup grouped items
Subtotal
DataInsert subtotals
Outline
ViewShow or hide outline
Data Table
DataCreate data table
Scenario Manager
DataOpen Scenario Manager
Goal Seek
DataRun Goal Seek
Solver
DataOpen Solver
Data Analysis
DataOpen Data Analysis tools
Macro Recorder
ToolsStart/stop macro recording
Visual Basic Editor
ToolsOpen Visual Basic Editor
Add-ins
ToolsManage add-ins
Options
ToolsOpen Excel options