Top 48 Advance Excel Shortcut Keyboard with AKIT GYAN

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.