Very userful Excel Shortcuts and Tricks

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