 Excel Keyboard Shortcuts – Workbook |
|
Create a new blank Workbook. |
Ctrl + N |
Displays the Open Dialogue box to Open/Find a file. |
Ctrl + O |
Saves the Workbook with its current file name, location, and file type. |
Ctrl + S |
Opens the Save As dialogue box. |
F12 |
Opens the Print Preview Window. |
Ctrl + F2 |
Maximize or Restore Selected Workbook Window. |
Ctrl + F10 |
Minimize Workbook. |
Ctrl + F9 |
Switch to the Next Workbook. |
Ctrl + Tab |
Switch to the Previous Workbook. |
Ctrl + Shift + Tab |
Close Current Workbook. |
Alt + F4 |
Excel Keyboard Shortcuts – Cell Editing |
|
Edit Active Cell. |
F2 |
Start a New Line in the Same Cell. |
Alt +Enter |
Select One Character on the Right of the Cursor. |
Shift + → |
Select One Character on the Left of the Cursor. |
Shift + ← |
Jump one Word on the Right of the Cursor. |
Ctrl + → |
Jump one Word on the Left of the Cursor. |
Ctrl + ← |
Select one Word on the Right of the Cursor. |
Ctrl + Shift + → |
Select one Word on the Left of the Cursor. |
Ctrl + Shift + ← |
Delete One Character on the Left of the Cursor. |
Backspace |
Delete Character on the Right of the Cursor. |
Delete |
Delete to the End of the line (from the cursor). |
Ctrl + Delete |
Cancel Entry. |
Esc |
Excel Keyboard Shortcuts – Navigation |
|
Move One Cell Up. |
↑ |
Move One Cell Down. |
↓ |
Move One Cell to the Right. |
→ |
Move One Cell to the Left. |
← |
Down One Screen. |
PageDown |
Up One Screen. |
PageUp |
Move One Screen to the Right. |
Alt + PageDown |
Move One Screen to the Left. |
Alt + PageUp |
Move to the Right Edge of the Data Region. |
Ctrl + → |
Move to the Left Edge of Data Region. |
Ctrl + ← |
Move to Bottom edge of data region. |
Ctrl + ↓ |
Move to the Top Edge of Data Region. |
Ctrl + ↑ |
Move to the Bottom-right used Cell in the Worksheet. |
Ctrl + End |
Go to the First Cell in the Current Region. |
Ctrl + Home |
Move to the Beginning of the Row. |
Home |
Move to Next Worksheet. |
Ctrl + PageDown |
Move to Previous Worksheet. |
Ctrl + PageUp |
Excel Keyboard Shortcuts – General |
|
Opens Help. |
F1 |
Repeats the last command or action. |
Ctrl + Y |
Repeats Last Action. |
F4 + |
Undo. |
Ctrl + Z |
Spell Check. |
F7 + |
Apply Data Filter. |
Ctrl + Shift + L |
Activate Filter (when the cell with filter is selected). |
Alt + ↓ |
Display Go To Dialogue Box. |
F5 |
Display Go To Dialogue Box. |
Ctrl + G |
Recalculate All Workbooks. |
F9 |
Calculate Active Worksheet. |
Shift + F9 |
Display the Print Menu. |
Ctrl + P |
Turn On End Mode. |
End |
Excel Keyboard Shortcuts – Cut, Copy, Paste |
|
Copy Selected Cells. |
Ctrl + C |
Cut Selected Cells. |
Ctrl + X |
Paste Content from the Clipboard. |
Ctrl + V |
Copy Formula from the Cell Above. |
Ctrl + ' |
Copy Value from the Cell Above. |
Ctrl + " |
Display Paste Special Dialogue Box. |
Ctrl + Alt + V |
Excel Keyboard Shortcuts – Data Entry |
|
Enter and Move Down. |
Enter |
Enter and Remain on the Same Cell. |
Ctrl+ Enter |
Enter and Move Up. |
Shift + Enter |
Enter and Move right. |
Tab |
Enter and Move Left. |
Shift + Tab |
Enter Same Data in All Selected Cells. |
Ctrl+ Enter |
Display AutoComplete list. |
Alt + ↓ |
Fill Down. |
Ctrl + D |
Fill Right. |
Ctrl + R |
Insert Current Date. |
Ctrl + ; |
Insert Current Time. |
Ctrl + Shift + ; |
Start a New Line in the Same Cell. |
Alt + Enter + |
Cancel Cell Entry. |
ESC |
Excel Keyboard Shortcuts – Clear |
|
Clear Everything. |
Alt + H + E + A |
Clear Formats Only. |
Alt + H + E + F |
Clear Content Only. |
Alt + H + E + C |
Clear Hyperlinks Only. |
Alt + H + E + L |
Clear Comments Only. |
Alt + H + E + M |
Excel Keyboard Shortcuts – Selection |
|
Select the Current Region / Select All. |
Ctrl + A |
Select Visible Cells in the Current Region. |
Alt + ; |
Select the Current Region Around the Active Cell. |
Ctrl + Shift + * |
Select Entire Row. |
Shift + Space |
Select Entire Column. |
Ctrl + Space |
Select All Cells that Contain Comments. |
Ctrl + Shift + O |
Select Row Differences. |
Ctrl + \ |
Select Column Differences. |
Ctrl + Shift + | |
Select Direct Precedents. |
Ctrl + [ |
Select all Precedents. |
Ctrl + Shift + { |
Select Direct Dependents. |
Ctrl + ] |
Select all Dependents. |
Ctrl + Shift + } |
Display Go To Dialogue Box. |
Ctrl + G |
Excel Keyboard Shortcuts – Extending the Selection |
|
Extend Selection to the Right by One Cell. |
Shift + → |
Extend Selection to the Left by One Cell. |
Shift + ← |
Extend Selection Upwards by One Cell. |
Shift + ↑ |
Extend Selection Downwards by One Cell. |
Shift + ↓ |
Extend the Selection to the Right till the Last Cell. |
Ctrl + Shift + → |
Extend the Selection to the Left till the Last Cell. |
Ctrl + Shift + ← |
Extend the Selection Upwards to the Last Cell. |
Ctrl + Shift + ↑ |
Extend Selection Upwards by One Screen. |
Shift + PageUp |
Extend Selection Downwards by One Screen. |
Shift + PageDown |
Extend Selection to the Right by One Screen. |
ALT + Shift + PageUp |
Extend Selection to the Left by One Screen. |
ALT + Shift + PageDown |
Extend Selection to the Start of the Row. |
Shift + Home |
Extend Selection to First Cell in the Worksheet. |
Ctrl + Shift + Home |
Extend Selection to the Last Cell in the Worksheet. |
Ctrl + Shift + End |
Toggle Extend Selection Mode. |
F8 |
Excel Keyboard Shortcuts – Alignment |
|
Align Content to the Center of the Cell. |
Alt + H + A + C |
Align Content to the Left of the Cell. |
Alt + H + A + L |
Align Content to the Right of the Cell. |
Alt + H + A + R |
Align Content to the Middle of the Cell. |
Alt + H + A + M |
Excel Keyboard Shortcuts – Hide/Unhide (Rows, Columns, Objects) |
|
Hide Selected Rows. |
Ctrl + 9 |
Hide Selected Columns. |
Ctrl + 0 |
Unhide Hidden Rows in Selection. |
Ctrl + Shift + 9 |
Unhide Hidden Columns in Selection. |
Ctrl + Shift + 0 |
Show/Hide Objects. |
Ctrl + 6 |
Excel Keyboard Shortcuts – Insert |
|
Insert New Line in Same Cell. |
Alt + Enter |
Insert New Worksheet. |
Shift + F11 |
Insert Row/Cell (shows dialogue box). |
Ctrl + Shift + = |
Insert Current Date. |
Ctrl + ; |
Insert Current Time. |
Ctrl + Shift ; |
Insert Table. |
Ctrl + T |
Insert Hyperlink. |
Ctrl + K |
Insert Argument Names into Formula. |
Ctrl + Shift A |
Insert/Edit Cell Comment. |
Shift + F2 |
Delete Row/Cell (shows dialogue box). |
Ctrl + - |
Excel Keyboard Shortcuts – Formatting |
|
Make Text Bold. |
Ctrl + B |
Make Text Italics. |
Ctrl + I |
Place outline Border around the Selected Cells. |
Ctrl + Shift + 7 |
Remove Outline Border. |
Ctrl + Shift + _ |
Underline Text. |
Ctrl + U |
Apply Strikethrough Format. |
Ctrl + 5 |
Apply Indent. |
Alt + H + 6 |
Remove Indent. |
Alt + H + 5 |
Increase Font Size by One Step. |
Alt + H + F + G |
Decrease Font Size by One Step. |
Alt + H + F + K |
Apply the Number format with Two Decimal Places, Thousands Separator, and a Minus Sign for Negative Values. |
Ctrl + Shift + ! |
Apply the Date format with the Day, Month, and Year. |
Ctrl + Shift + # |
Apply the Currency Format with Two Decimal Places. |
Ctrl + Shift + $ |
Apply the Percentage Format with No Decimal Places. |
Ctrl + Shift + % |
Apply the Time format with the Hour and Minute, and indicate A.M. or P.M. |
Ctrl + Shift + @ |
Apply the General Number Format. |
Ctrl + Shift + ~ |
Apply the Exponential Format. |
Ctrl + Shift + ^ |
Displays the Format Style Dialog Box. |
Alt + ' |
Displays the Format Cells Dialogue Box. |
Ctrl + 1 |
Displays the Font Dialogue Box. |
Shift + Ctrl + F |
Excel Keyboard Shortcuts – Formula Related |
|
Insert Autosum Formula. |
Alt + = |
While Typing a Formula, Switches Cell Reference from Absolute to Relative. |
F4 |
Expand/Collapse Formula Bar. |
Ctrl + Shift + U |
Display the Insert Function Dialog Box. |
Shift + F3 |
Enter a Formula as an Array Formula. |
Ctrl + Shift + Enter |
Evaluate Part of the Formula. |
F9 |
Select the Array Containing the Active Cell. |
CTRL + / |
Select All Cells Directly or Indirectly Referenced by Formulas in the Selection. |
CTRL + [ |
Select Cells that Contain Formulas that Directly or Indirectly Reference the Active Cell. |
CTRL + ] |
Toggle Value/Formula display. |
Ctrl + ` |
Rechecks Dependent Formulas and then Calculates all Cells in all Open Workbooks. |
Ctrl + Alt |
Shift + F9 |
|
Excel Keyboard Shortcuts – Find and Replace |
|
Display Find and Replace Dialogue Box (Find Selected). |
Ctrl + F |
Display Find and Replace Dialogue Box (Replace Selected). |
Ctrl + H |
Find Next Match. |
Shift + F4 |
Find Previous Match. |
Ctrl + Shift |
F4 |
|
Excel Keyboard Shortcuts – Conditional Formatting |
|
Open Conditional Formatting Dialogue Box. |
Alt + O + D |
Clear Conditional from Selected Cells. |
Alt + H + L + C + S |
Clear Conditional from the Entire Worksheet. |
Alt + H + L + C + E |
Excel Keyboard Shortcuts – Charting |
|
Inserts Chart in the Worksheet (using the selected data). |
Alt + F1 |
Inserts a ChartSheet with a Chart (using the selected data). |
F11 |
Excel Keyboard Shortcuts – Drag (Mouse) |
|
Drag and Copy. |
Ctrl + Drag |
Drag and Cut. |
Drag |
Drag and Insert. |
Shift + Drag |
Duplicate Worksheet. |
Ctrl + Drag |
Switch Position of Cells/Rows/Columns. |
Ctrl + Shift + Drag |
Excel Keyboard Shortcuts – Named Ranges |
|
Get a List of All Defined Named Ranges. |
F3 |
Create Named Range from Selection. |
Ctrl + Shift + F3 |
Define Name Dialog Box. |
Ctrl + F3 |
Excel Keyboard Shortcuts – Pivot Table |
|
Display Insert Pivot Table Dialogue Box. |
Alt + N +V |
Open Pivot Table Wizard. |
Alt + D + P |
Select Entire Pivot Table (excluding Report Filters). |
Ctrl + A |
Add/Remove Checkmark for Selected Field in PivotTable Field List. |
Space |
Group Selected Pivot Table Items. |
Alt + Shift + → |
UnGroup Pivot Table Items. |
Alt + Shift + ← |
Select the Next Item in PivotTable Field List or Items List. |
↓ |
Select a Previous Item in PivotTable Field List or Items List. |
↑ |
Select Last Visible Item in List. |
End |
Select First Visible Item in List. |
Home |
Open Field List for Active Cell. |
Alt + ↓ |
Hide Selected Item or Field. |
Ctrl + – |
Opens Calculated Field dialog box (when data field is selected). |
Shift + Ctrl + = |
Opens Calculated Item Dialog box (when field heading cell is Selected). |
Shift + Ctrl + = |
Excel Keyboard Shortcuts – Others |
|
Restore Window Size. |
Ctrl + F5 |
Move Window. |
Ctrl + F7 |
Resize Window. |
Ctrl + F8 |
Previous Window. |
Ctrl + Shift + F6 |
Next Pane. |
F6 |
Previous Pane. |
F8 |
Extend Mode. |
Shift + F10 |
Display Shortcut Menu. |
Shift + F6 |
Turns On the Add to Selection Mode. |
Shift + F8 |
Excel Keyboard Shortcuts – VBA |
|
Switch between Excel Worksheet and the VBA editor. |
Alt + F11 |
VB Help. |
F1 |
View Object Browser. |
F2 |
View Properties. |
F4 |
View Code window. |
F7 |
View Immediate window. |
Ctrl + G |
View Shortcut Menu. |
Shift + F10 |
Run a Sub/UserForm. |
F5 |
Step Into. |
F8 |
Step Over. |
Shift + F8 |
Step Out. |
Ctrl + Shift + F8 |
Run to Cursor. |
Ctrl + F8 |
Toggle Breakpoint. |
F9 |
Clear All Breakpoints. |
Ctrl + F9 |
Close VBA Editor and Return to the Excel Worksheet. |
Alt + Q |
Excel Keyboard Shortcuts – Formatting |
|
Make Text Bold. |
Ctrl + B |
Make Text Italics. |
Ctrl + I |
Place outline Border around the Selected Cells. |
Ctrl + Shift + 7 |
Remove Outline Border. |
Ctrl + Shift + _ |
Underline Text. |
Ctrl + U |
Apply Strikethrough Format. |
Ctrl + 5 |
Apply Indent. |
Alt + H + 6 |
Remove Indent. |
Alt + H + 5 |
Increase Font Size by One Step. |
Alt + H + F + G |
Decrease Font Size by One Step. |
Alt + H + F + K |
Apply the Number format with Two Decimal Places, Thousands Separator, and a Minus Sign for Negative Values. |
Ctrl + Shift + ! |
Apply the Date format with the Day, Month, and Year. |
Ctrl + Shift + # |
Apply the Currency Format with Two Decimal Places. |
Ctrl + Shift + $ |
Apply the Percentage Format with No Decimal Places. |
Ctrl + Shift + % |
Apply the Time format with the Hour and Minute, and indicate A.M. or P.M. |
Ctrl + Shift + @ |
Apply the General Number Format. |
Ctrl + Shift + ~ |
Apply the Exponential Format. |
Ctrl + Shift + ^ |
Displays the Format Style Dialog Box. |
Alt + ' |
Displays the Format Cells Dialogue Box. |
Ctrl + 1 |
Displays the Font Dialogue Box. |
Shift + Ctrl + F |
Excel Keyboard Shortcuts – Formula Related |
|
Insert Autosum Formula. |
Alt + = |
While Typing a Formula, Switches Cell Reference from Absolute to Relative. |
F4 |
Expand/Collapse Formula Bar. |
Ctrl + Shift + U |
Display the Insert Function Dialog Box. |
Shift + F3 |
Enter a Formula as an Array Formula. |
Ctrl + Shift + Enter |
Evaluate Part of the Formula. |
F9 |
Select the Array Containing the Active Cell. |
CTRL + / |
Select All Cells Directly or Indirectly Referenced by Formulas in the Selection. |
CTRL + [ |
Select Cells that Contain Formulas that Directly or Indirectly Reference the Active Cell. |
CTRL + ] |
Toggle Value/Formula display. |
Ctrl + ` |
Rechecks Dependent Formulas and then Calculates all Cells in all Open Workbooks. |
Ctrl + Alt |
Shift + F9 |
|
Excel Keyboard Shortcuts – Find and Replace |
|
Display Find and Replace Dialogue Box (Find Selected). |
Ctrl + F |
Display Find and Replace Dialogue Box (Replace Selected). |
Ctrl + H |
Find Next Match. |
Shift + F4 |
Find Previous Match. |
Ctrl + Shift |
F4 |
|
Excel Keyboard Shortcuts – Conditional Formatting |
|
Open Conditional Formatting Dialogue Box. |
Alt + O + D |
Clear Conditional from Selected Cells. |
Alt + H + L + C + S |
Clear Conditional from the Entire Worksheet. |
Alt + H + L + C + E |
Excel Keyboard Shortcuts – Charting |
|
Inserts Chart in the Worksheet (using the selected data). |
Alt + F1 |
Inserts a ChartSheet with a Chart (using the selected data). |
F11 |
Excel Keyboard Shortcuts – Drag (Mouse) |
|
Drag and Copy. |
Ctrl + Drag |
Drag and Cut. |
Drag |
Drag and Insert. |
Shift + Drag |
Duplicate Worksheet. |
Ctrl + Drag |
Switch Position of Cells/Rows/Columns. |
Ctrl + Shift + Drag |
Excel Keyboard Shortcuts – Named Ranges |
|
Get a List of All Defined Named Ranges. |
F3 |
Create Named Range from Selection. |
Ctrl + Shift + F3 |
Define Name Dialog Box. |
Ctrl + F3 |
Excel Keyboard Shortcuts – Pivot Table |
|
Display Insert Pivot Table Dialogue Box. |
Alt + N +V |
Open Pivot Table Wizard. |
Alt + D + P |
Select Entire Pivot Table (excluding Report Filters). |
Ctrl + A |
Add/Remove Checkmark for Selected Field in PivotTable Field List. |
Space |
Group Selected Pivot Table Items. |
Alt + Shift + → |
UnGroup Pivot Table Items. |
Alt + Shift + ← |
Select the Next Item in PivotTable Field List or Items List. |
↓ |
Select a Previous Item in PivotTable Field List or Items List. |
↑ |
Select Last Visible Item in List. |
End |
Select First Visible Item in List. |
Home |
Open Field List for Active Cell. |
Alt + ↓ |
Hide Selected Item or Field. |
Ctrl + – |
Opens Calculated Field dialog box (when data field is selected). |
Shift + Ctrl + = |
Opens Calculated Item Dialog box (when field heading cell is Selected). |
Shift + Ctrl + = |
Excel Keyboard Shortcuts – Others |
|
Restore Window Size. |
Ctrl + F5 |
Move Window. |
Ctrl + F7 |
Resize Window. |
Ctrl + F8 |
Previous Window. |
Ctrl + Shift + F6 |
Next Pane. |
F6 |
Previous Pane. |
F8 |
Extend Mode. |
Shift + F10 |
Display Shortcut Menu. |
Shift + F6 |
Turns On the Add to Selection Mode. |
Shift + F8 |
Excel Keyboard Shortcuts – VBA |
|
Switch between Excel Worksheet and the VBA editor. |
Alt + F11 |
VB Help. |
F1 |
View Object Browser. |
F2 |
View Properties. |
F4 |
View Code window. |
F7 |
View Immediate window. |
Ctrl + G |
View Shortcut Menu. |
Shift + F10 |
Run a Sub/UserForm. |
F5 |
Step Into. |
F8 |
Step Over. |
Shift + F8 |
Step Out. |
Ctrl + Shift + F8 |
Run to Cursor. |
Ctrl + F8 |
Toggle Breakpoint. |
F9 |
Clear All Breakpoints. |
Ctrl + F9 |
Close VBA Editor and Return to the Excel Worksheet. |
Alt + Q |
Comments
Post a Comment