Advance Excel keyboard shortcuts
CTRL+A : SELECT ALL
CTRL+C : COPY
CTRL+X : CUT
CTRL+V : PASTE
CTRL+F : FIND
CTRL+H : REPLACE
CTRL+B : BOLD
CTRL+I : ITALICS
CTRL+U : UNDERLINE
CTRL+F5 : XL, RESTORE WINDOW SIZE
CTRL+F6 : NEXT WORKBOOK WINDOW
CTRL+SHIFT+F6 : PREVIOUS WORKBOOK WINDOWS
CTRL+F9 : TO MINIMIZE WORKBOOK
CTRL+F11 : TO OPEN VBE
CTRL+SHIFT+F6 : FOR PREVIOUS WINDOWS
CTRL+SHIFT+F1 : TO OPEN NEW WORKSHEET
CTRL+O : TO OPEN WORKBOOK
CTRL+SHIFT+TAB : TO ACTIVE PREVIOUS WORKBOOK
CTRL+N : TO CREATE NEW WORKBOOK
CTRL+SHIFT : REMOVE THE OUTLINE BORDER FORM THE SELECTED CELLS.
CTRL+SHIFT+* : SELECT THE CURRENT REGION AROUND THE ACTIVE CELL IN A PIVOTTABLE , IT SELECTS THE ENTIRE PIVOTTABLE REPORT.
CTRL+SHIFT+: : ENTERS THE CURRENT TIME
CTRL + SHIFT+" : COPIES THE VALUE FORM THE CELL ABOVE THE ACTIVE CELL INTO THE CELL OR THE FORMULA BAR.
CTRL+6 : ALTERNATES BETWEEN HIDING OBJECTS, DISPLAYING OBJECTS AND DISPLAYING PLACEHOLDERS
CTRL+8 : DISPLAYS OR HIDES THE OUTLINE SYMBOLS
CTRL+9 : HIDES THE SELECTED ROWS
CTRL+0 : HIDES THE SELECTED COLUMNS
F4 : DURING FORMULA TYPING , ADJUSTS THE REFERENCE TYPE, ABS TO RELATIVE , OTHERWISE REPEATS LAST ACTION
CTRL +;/: : INTERTS CURRENT DATE
CTRL +:/' : COPIES VALUE FROM CELL ABOVE TO CURRENT CELL
SHIFT+F2 : EDITS A CELL COMMENT
ALT+F8 : OPENS MACROS DIALOG BOX
ALT++/= : AUTO SUM SELECTED CELL AND PLACES VALUES IN CELL BENCATH.
CTRL+SHIFT+$/4 : CURRENCY FORMATS CURRENT CELL
CTRL+SHIFT+$/7 : APPLIES OUTLINE BORDER TO SELECTED CELLS
CTRL+SHIFT+!/1 : COMMA FORMATS CURRENT CELL
SHIFT+CTRL+F : ACTIVATED FONT DROP LIST
SHIFT+ CTRL+P : ACTIVATE FONT POINT SIZE DROP DOWN LIST
CTRL+P : DISPLAY THE PRINT DIALOG BOX
CTRL + R : USES THE FILL RIGHT COMMAND TO COPY THE CONTENTS AND FORMAT OF THE LEFTMOST CENLL OF A SELECTED RANGE INTO THE CELL TO THE RIGHT.
CTRL+S : SAVES THE ACTIVE FILE WITH ITS CURRENT FILE NAME , LOCATION AND FILE FORMET.
CTRL+T : DISPLAY THE CREATE TABLE DIALOG BOX
CTRL+W : CLOASE THE SELECTED WORKBOOK WINDOW
CTRL+Y : REPEATES THE LAST COMMAND OR ACTION IF POSSIABLE
CTRL+Z : USES THE UNDO COMMAND TO REVERSE THE LAST COMMAND OR TO DELETE THE LAST ENTRY THAT YOU TYPE.
CTRL+SHIFT+& : APPLIES THE OUTLINE BORDER TO THE SELECTED CELLS
CTRL+SHIFT+~ : APPLIES THE GENERAL NUMBER FORMET
CTRL+SHIFT +$ : APPLIES THE CURRENCY FORMAT WITH TWO DECIMAL PLACES
CTRL+SHIFT+% : APPLIES THE PERCENTAGE FORMAT WITH NO DECIMAL PLACES.