*) CREATE A NEW WORK BOOK - CTRL + N
*) SAVE A WORK BOOK - CTRL + S
*) SAVE AS - F12
*) PRINT A WORK BOOK - CTRL + P
*) OPEN PRINT PREVIEW - CTRL + F2
*) HELP - F1
*) ACTIVATE TELL ME FIELD - CTRL + O
*) SPELL CHECK - F7
*) CALCULATE WORKSHEETS - F9
*) CREATE ABSOLUTE REFERNECE - F4
*) CLOSE A WORKBOOK - CTRL + W
*) CLOSE EXCEL - ALT + F4
TABLES & FILTERS -
*) Insert Table - CTRL + T
*) Toggle Auto Filter - CTRL + SHIFT + L
*) Activate Filter - ALT + DOWN ARROW KEY
*) Select Table Row - Shift + Spacebar
*) Select Table Column - CTRL + Spacebar
*) Select Entire Table - CTRL + A
*) Clear Slicer Filter - ALT + C
*) Toggle Table Total Row - CTRL + SHIFT + T
NUMBER FORMATTING SHORTCUTS -
*) Apply General Format - CTRL + SHIFT + -
*) Apply Currency Format - CTRL+ SHIFT + $
*) APPLY Percentage Format - CTRL + SHIFT + %
*) APPLY SCIENTIFIC Format - CTRL + SHIFT + ^
*) Apply Date Format - CTRL + SHIFT + #
*) Apply Time Format - CTRL + SHIFT + @
*) Apply Number Format - CTRL + SHIFT + !
EDITING SHORTCUT -
*) Cut - CTRL + X
*) Copy - CTRL + C
*) Paste - CTRL + V
*) Undo - CTRL + Z
*) Redo - CTRL + Y
*) Find - CTRL + F
*) Replace - CTRL + H
*) EDIT Active Cell - F2
*) Clear All Cell Contents - Delete
PIVOT TABLE SHORTCUT -
*) Select Entire Pivot Table - CTRL + A
*) Toggle Pivot Table Field Check Box - SPACE
*) Group Pivot Table Items - ALT + SHIFT + RIGHT ARROW KEY
*) Ungroup Pivot Table Items - ALT + SHIFT + LEFT ARROW KEY
*) Hide Pivot Table Item - CTRL + V
*) Create Pivot Chart On Existing Work Sheet - ALT + F1
*) Create Pivot Chart On New Worksheet - F11
*) Open Pivot Table Wizard - ALT + D + P
EXCEL NAVIGATION SHORTCUTS ---
*) Move Between Cells - All Arrow Keys
*) Move One Cell Right - TAB
*) Move One Cell Left - Shift + TAB
*) Move One Cell Up -- SHIFT + ENTER
*) Move One Cell Down - CTRL + W
*) Move Down One Screen - PAGE DOWN
*) GO TO First Cell Of A Active Row - HOME
*) Enable End Mode - END
*) Move To Cell A1 - CTRL + HOME
*) Move To Last CELL - CTRL + END
download the pdf link given below ---
