150+ Excel Shortcuts Keys | Shortcut Keys in PDF

This is based on our experience with consulting and interacting with 30,000+ students in the classroom sessions. Best for learning excel Shortcuts in Hindi. There are many more function keys in Excel 2007, Excel 2010 Excel 2016. But the running Basic Excel shortcuts keys which come in our daily use and save time in our daily routines are included. Some Example of shortcuts is as follow arrow keys shift spacebar press ctrl alt-shift.

File

Create new workbook

Print excel sheet

Open print preview window

Close current window

Ribbon

Expand or collapse the ribbon

Move to Next Ribbon Control

Move to a previous button

Accept and confirm

Get help from Microsoft Excel

Active Cell

Select active cell only

Show active cell on a worksheet

Move active cell clockwise in selection

Move active cell down in selection

Move active cell up in selection

Move active cell Right in a selection

Move active cell Left in a selection

General

Undo last action

Redo last action

Copy selected cells

Repeat last action

Cut selected cells

Paste content from clipboard

Display Paste Special

Display Find and Replace

Find with Replace selected

Find previous match

Find next match

Create Embedded Chart

Create chart in new worksheet

Toggle auto filter

Activate filter Dropdown

Select table row

Select table column

Selection

Select entire row

Select entire column

Select entire worksheet

Toggle add to selection mode

Cancel selection

Navigation

Move one cell right

Move one cell left

Move one cell up

Move one cell down

Move one screen Right

Move one screen left

Move one screen up

Move one screen down

Move to right edge of data region

Move to left edge of data region

Move to top edge of data region

Move to bottom edge of data region

Move to beginning of row

Move to last cell in worksheet

Move to first cell in worksheet

Turn End mode on

Number Formatting

Apply general format

Apply Currency Format

Apply Percentage Format

Apply Scientific Format

Apply Date Format

Apply Time Format

Apply Number Format

Extend Selection

Extend Selection by One Cell Right

Extend Selection by One Cell Left

Extend Selection by One cell Up

Extend Selection by One Cell Down

Extend the Selection to the last Cell Right

Extend the Selection to the last Cell Left

Extend the Selection to the last Cell Up

Extend the Selection to the Last Cell Down

Extend Selection Up One Screen

Extend Selection Down One Screen

Extend Selection Right One Screen

Extend Selection Left One Screen

Extend Selection to Start of Row

Extend Selection to the First Cell in the worksheet

Extend Selection to the last cell in the Worksheet

Toggle Extend Selection Mode

Select Special

Display ‘Go To’ Dialog Box

Select Row Differences

Select Column Differences

Select Cells with Comments

Select Current Region

Select Current Array

Select Direct Precedents

Select All Precedents

Select Direct Dependents

Select All Dependents

Select Visible Cells Only

Cell Edit Mode

Edit the Active Cell

Insert OR Edit Comment

Select One Character Right

Select One Character Left

Move One Word Right

Move One Word Left

Select One Word Right

Select to Beginning of cell

Select to End of the Cell

Delete Character to the Left of Cursor

Delete Character to the Right of Cursor

Start a new line in the same cell

Entering Data

Enter and Move down

Enter and Move up

Enter and Move right

Enter and Move left

Enter same data in multiple cells

Insert Current Date

Insert current time

Fill down from cell above

Fill right from cell left

Copy formulas from cell above

Copy value from cell above

Display auto complete list

Formatting

Format (almost) anything

Display format cells font tab

Apply or Remove bold formatting

Apply or Remove italic formatting

Apply or Remove Underscoring

Toggle strike through formatting

Increase font size one step

Decrease font size one step

Borders

Add Border Outline

Add OR Remove Border Right

Add OR Remove Border Left

Add OR Remove Border Top

Add OR Remove Border Bottom

Add OR Remove Border Upward Diagonal

Add OR Remove Border Horizontal Interior

Dialog Boxes

Move to Next Control

Cancel and close the dialog box

Toggle between open books

Move to previous tab

Accept and apply

Check and Uncheck box

Formulas

Toggle Absolute & Relative references

Open Insert function dialog

AutoSum selected cells

TOGGLE FORMULAS ON AND OFF

ENTER ARRAY FORMULA

CALCULATE WORKSHEETS

CALCULATE ACTIVE WORKSHEET

FORCE CALCULATE ALL WORKSHEETS

EVALUATE PART OF A FORMULA

EXPAND/COLLAPSE FORMULA BAR

DISPLAY FUNCTION ARGUMENTS DIALOG BOX

DEFINE NAME

DEFINE NAMES FROM LABELS

PASTE NAME INTO FORMULA

Pivot Table

SELECT ENTIRE PIVOT TABLE

TOGGLE PIVOT TABLE FIELD CHECKBOX

GROUP PIVOT TABLE ITEMS

UNGROUP PIVOT TABLE ITEMS

HIDE PIVOT TABLE ITEM

CREATE PIVOT CHART ON SAME WORKSHEET

CREATE PIVOT CHART ON NEW WORKSHEET

OPEN PIVOT TABLE WIZARD

INSERT CALCULATED FIELD

Grid Operations

DISPLAY INSERT DIALOG BOX

INSERT ROWS

INSERT COLUMNS

DISPLAY DELETE DIALOG BOX

DELETE ROWS

DELETE COLUMNS

DELETE CELLS

DELETE CONTENTS OF SELECTED CELLS

HIDE COLUMNS

HIDE ROWS

UNHIDE ROWS

UNHIDE COLUMNS

GROUP ROWS OR COLUMNS

UNGROUP ROWS OR COLUMNS

OPEN GROUP DIALOG BOX

OPEN UNGROUP DIALOG BOX

HIDE OR SHOW OUTLINE SYMBOLS

Workbook

INSERT NEW WORKSHEET

GO TO NEXT WORKSHEET

GO TO PREVIOUS WORKSHEET

MOVE TO NEXT PANE

MOVE TO PREVIOUS PANE

GO TO NEXT WORKBOOK

GO TO PREVIOUS WORKBOOK

MINIMIZE CURRENT WORKBOOK WINDOW

MAXIMIZE CURRENT WORKBOOK WINDOW

TOGGLE SCROLL LOCK

Other

OPEN SPELLING DIALOG BOX

OPEN THESAURUS DIALOG BOX

OPEN MACRO DIALOG BOX

OPEN VBA EDITOR

DUPLICATE OBJECT

SNAP TO GRID

HIDE OR SHOW OBJECTS

DISPLAY MODIFY CELL STYLE

DISPLAY SHORTCUTS MENU

DISPLAY CONTROL MENU

I hope you must have learned Excel Shortcut Keys or at least you must have found your daily used shortcut which can be used in your daily life. There is also a Huge list of Excel Formula Shortcuts.