Learn 200+ Excel Shortcuts to Increase Productivity

Search
Generic filters

Table of Contents

Excel Keyboard Shortcuts – Extending the Selection

  • Short Cut for Create a new blank Workbook: Ctrl N
  • Short Cut for Displays the Open Dialogue box to Open/Find a file: Ctrl + O
  • Short Cut for Saves the Workbook with its current file name, location, and file type: Ctrl + S
  • Short Cut for Opens the Save As dialogue box: F12
  • Short Cut for Opens the Print Preview Window: Ctrl + F2
  • Short Cut for Maximize or Restore Selected Workbook Window: Ctrl + F10
  • Short Cut for Minimize Workbook: Ctrl + F9
  • Short Cut for Switch to the Next Workbook: Ctrl + Tab
  • Short Cut for Switch to the Previous Workbook: Ctrl + Shift + Tab
  • Short Cut for Close Current Workbook: Alt+F4+Back
Blue-Fluid-Business-Plan-powerpoint-template-or-google-slides-theme-720x405-1
Download from 1000 Free PowerPoint Presentations, Themes, Infographics and Background Designed by Professionals

Short Cuts for Excel Keyboard Shortcuts – Cell Editing

  • Short Cut for Edit Active Cell: F2
  • Short Cut for Start a New Line in the Same Cell: Alt + Enter
  • Short Cut for Select One Character on the Right of the Cursor: Shift + →
  • Short Cut for Select One Character on the Left of the Cursor: Shift + ←
  • Short Cut for Jump one Word on the Right of the Cursor: Ctrl + →
  • Short Cut for Jump one Word on the Left of the Cursor: Ctrl + ←
  • Short Cut for Select one Word on the Right of the Cursor: Ctrl + Shift + →
  • Short Cut for Select one Word on the Left of the Cursor: Ctrl + Shift + ←
  • Short Cut for Delete One Character on the Left of the Cursor: Backspace
  • Short Cut for Delete Character on the Right of the Cursor: Delete
  • Short Cut for Delete to the End of the line (from the cursor): Ctrl + Delete
  • Short Cut for Cancel Entry: Esc + Back

Short Cuts for Excel Keyboard Shortcuts – Navigation

  • Short Cut for Move One Cell Up:
  • Short Cut for Move One Cell Down :
  • Short Cut for Move One Cell to the Right:
  • Short Cut for 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 the Bottom edge of the 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 the Previous Worksheet: Ctrl + PageUp

Excel Keyboard Shortcuts – General

  • Opens Help: F1
  • Repeats the last command or action: Ctrl + Y
  • Repeats the 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: Control + 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: Control + 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 + Back

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 + Back
  • 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 the Same Cell: Alt + Enter
  • Insert New Worksheet: Shift + F11
  • Insert Row/Cell (shows a dialog 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 the dialog 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 Auto sum 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 the 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 Chart Sheet with a Chart (using the selected data): F11
  • Excel Keyboard Shortcuts – Drag (Mouse)
  • Drag and Copy: Ctrl + Drag
  • Drag and Cut
  • 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 the 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 Template Categories

Download Editable Excel Templates:

Training_Attendance_Sheet_V1.0

Training Attendance Sheet

Whether you’re organizing any training program for an athletic event. A technology course, or a chess tournament, a good attendance …

Download Now
Weekly_Attendance_Sheet_V1.0

Weekly Attendance Sheet

Our “Weekly Attendance Sheet” is simple, compact, and useful an all-purpose attendance tracker. This attendance tracker includes one worksheet with …

Download Now
Student_Attendance_Sheet_Weekly_Monthly

Student Attendance Sheet

These student attendance sheet records is create to help teachers keep track of attendance of their students. There are two …

Download Now
Shift_Planner_with_Attendance_Tracker_Pro-employee

Shift Planner with Tracker

Shift Planner with Tracker for Excel is a powerful spreadsheet that help any Human Resources or operational managers creating their …

Download Now
Employee_Attendance_Tracker_Pro_V2.55

Employee Attendance Tracker

The free employee attendance tracker template is one of my popular excel templates. I have create a more general employee …

Download Now
Islamic_Calendar

Islamic Calendar

The Islamic calendar (it is known also as Muslim calendar or Hijri calendar) is a lunar calendar based on 12 …

Download Now
Chinese_Calendar

Chinese Calendar

The Chinese Lunar New Year is the longest chronological record in history, dating from 2600 BC, when Emperor Huang Ti …

Download Now

We Create Your Life Easy With Our Free Excel Templates & Spreadsheet Dashboards

Use free Excel Templates, Tools and Dashboards to create and draft a professional looking dashboards and computation sheet for your personal and business use. You can Explore Calendars, Activity Planners, Invoice Templates, Sales Forecast Sheets, Budget templates and various business information delivering Templates in Excel and Spreadsheet at XLSX Templates. 

These templates, dashboards and tools are useful in various occasions. You can also customize these templates as per your requirement. Modification of fields and data source helps in making the template more relevant.

Learn Microsoft Excel : Blogs and Articles

Learn about various tips and tricks in Microsoft Excel and Spreadsheet. Create best templates and dashboards using free tricks and tutorials in excel and spreadsheet. These tutorial posts are useful for everyone who wants to master the skills in excel and spreadsheet.

Deselect Cells in Excel

How To Deselect Cells in Excel

Table of Contents How to Deselect Cells in Excel After adding the deselecting cells feature in Excel, this  becomes so  …

Select Non-Contiguous Cells in Excel

Learn how to Select Non-Contiguous Cells in Excel

Table of Contents Select cell without using Ctrl Key By following these simple steps we can do it. At first, …

Format Painter in Excel

How to use Format Painter in Excel

Table of Contents Where’s the Format Painter Button? It’s there on your Home Tab. If you look at the clipboard …

Apply Strikethrough in Excel [Shortcut + Command]

How to apply Strikethrough in Excel [Shortcut + Command]

Table of Contents Shortcut Key to Apply Strikethrough to a Cell Let’s say you’re in hurry and don’t want to …

Formula Bar in Excel

Formula Bar in Excel

Table of Contents Key Points To Consider Using Formula Bar You can hide or unhide the formula bar. You can …

Convert Date into Day

Convert Date into Day Sub date2day() Dim tempCell As Range Selection.Value = Selection.Value For Each tempCell In Selection If IsDate(tempCell) …

Basic VBA Macro Codes in Excel

Custom Header & Footer

Sub CustomHeader() Dim myText As String myText = InputBox(“Enter your text here”, “Enter Text”) With ActiveSheet.PageSetup .LeftHeader = “” .CenterHeader …

Get Macro Code

Add Header and Footer Date

Sub DateInHeader() With ActiveSheet.PageSetup .LeftHeader = “” .CenterHeader = “&D” .RightHeader = “” .LeftFooter = “” .CenterFooter = “” .RightFooter …

Get Macro Code

Open Calculator

Sub OpenCalculator() Application.ActivateMicrosoftApp Index:=0 End Sub In Windows, there is a specific calculator and by using this macro code you …

Get Macro Code

Unmerge Cells

Sub UnmergeCells() Selection.UnMerge End Sub Unmerge Cells code simply uses the unmerge options which you have on the HOME‌ tab. …

Get Macro Code

Remove Text Wrap

Sub RemoveTextWrap() Range(“A1”).WrapText = False End Sub This code will help you to remove text wrap from the entire worksheet …

Get Macro Code

Auto Fit Rows

Sub AutoFitRows() Cells.Select Cells.EntireRow.AutoFit End Sub You can use this code to auto-fit all the rows in a worksheet. When …

Get Macro Code

Auto Fit Columns

Sub AutoFitColumns() Cells.Select Cells.EntireColumn.AutoFit End Sub Use above Excel macro code to auto fit rows in all your sheet at …

Get Macro Code

Insert Multiple Columns

Sub InsertMultipleColumns() Dim i As Integer Dim j As Integer ActiveCell.EntireColumn.Select On Error GoTo Last i = InputBox(“Enter number of …

Get Macro Code

Insert Multiple Rows

Sub InsertMultipleRows() Dim i As Integer Dim j As Integer ActiveCell.EntireRow.Select On Error GoTo Last i = InputBox(“Enter number of …

Get Macro Code