Excel Advance Shortcuts Key

Excel Advance Shortcuts Key:

Ctrl +           =  Insert New Column /Row

Ctrl -            = Delete The Selected Column/Row

Ctrl + Home = Move to cell A1

Ctrl + End    = Move to Last Cell With Content on Worksheet

Ctrl + `          = Show the Formula

Ctrl +;           = Enter the Current Date

Ctrl +Shift+1 = Format Number in comma(,) Format

Ctrl +Shift+;  = Enter the Current Date.

Ctrl + F4        = Close the program

Ctrl + F6        =  Switch between one workbook to another

Ctrl + F9        = Minimize workbook

Ctrl + F10      = Maximize workbook

Ctrl + Arrow key = Move next section of the text.

Ctrl + Space        = Select entire Column

Shift + Space       = Select entire Row

Ctrl + Page Up     = Move between one sheet to another

Ctrl + Page Down = Move between one sheet to another

Ctrl +Shift+L        = Filter

Ctrl +1                   = Open the Format cell Window.

Ctrl +9                   = Hide the selected Rows

Ctrl + Shift +(        = Unhide any hidden Row

Shift + F11             = insert New Work Sheet

Shift + F2               = insert Comment

Shift +F3                = Open the Excel Formula Window

Shift +F5                = Search Box

F1                           = Help

F2                           = Edit the selected Cell

F4                           = Repeat Last action

F5                           = Go to Specified Cell

F7                           = Spell Check Selected text

F11                         = Create chart form selected data.

F12                         = Save As

Esc Button              = Cancel a cell entry

Alt +                       = Auto Sum

Alt +F1                   = Create Chart

Alt +F4                   = Close the Program

Alt +F8                   = Display the macro

Alt +Enter               =  Wrap Text