150+ Excel Shortcuts Keys | Shortcut Keys in PDF

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. 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

Ribbon

Active Cell

General

Selection

Navigation

Number Formatting

Extend Selection

Select Special

Cell Edit Mode

Entering Data

Formatting

Borders

Dialog Boxes

Formulas

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