Microsoft Excel shortcut key

Control + 1                open the format cells dialog box

Control + 2                    Bold

control + 3                           Italic

 control +  4                         underline

 control +5                      strikethrough

 control + 6                      Show / hide object

control +  9                  Hide row

Control+ shift + 9             Unhide row

Control + o               hide column

Control +  shift + o       unhide  column

Control+ ~         increase column width

Control + page down      switch to the next worksheet

Control +  page up           switch to the previous sheet

Home                           return to the first cell of the current row in a  worksheet

Control + home                        move to the beginning of a worksheet

Control + end                   move to the last used cell of the current worksheet

Control +  space                 select entire column

Shift + space                           select entire row

Ctrl+ -  delete                          row column or cell

Ctrl + ;                                     insert current date

Ctrl + shift + :                       insert current time

Ctrl + F1                            Show / hide the excel ribbon

Ctrl + F4                              close window

Ctrl + F9                                Minimize workbook

Ctrl+ F10                               maximize window

Ctrl + F12                                 open file

F2                                     Edit the current cell

Alt+ Enter                            In cell editing mode ,enter a new line

Ctrl + Shift + End               select entire range of  cell from start to end

Control + shift + "                 copy value from cell above

Control + shift + &                  place outline border a row selected cell

Control + shift +   -                  remove  outline border

 control + shift +  +                   Insert  (row column or cell)

Control + shift + ~                      General number format

 control + shift + !                       Two decimal places thousand  saparator example( 16618 ) change

                                                         ( 16,618.8 )

Control + shift +$                      currency format with two decimal places

Control + shift + %             Percentage format with no decimal places (apply blank cell)

Control +  shift+ ^             Scientific notation number format with two decimal

Alt + ctrl +v                          Paste special box

CTRL +ALT +V +T                      Paste format only

ALT + W+ F                               freeze window

   F8                                         Anchor to highlight

F11                                                  New chart

F12                                                       Save as

Shift+ F2                                          Insert a comment

Shift+ F3                                       Insert function box

Shift + F5                                                   Find

Shift + F8                                               Add to selection

Shift + F10                                           Display shortcut menu

Shift + F11                                            New worksheet