Microsoft Excel shortcut keys

Below is a listing of all the major shortcut keys usable in Microsoft Excel.

       Shortcut                 Description

·         F2                    Edit the selected cell.

·         F3                    After a name has been created, F3 will paste names.

·         F4                    Repeat last action. For example, if you changed the color of text in another cell,
                           pressing F4 will change the text in cell to the same color.

·         F5                    Go to a specific cell. For example, C6.

·         F7                    Spell check selected text or document.

·         F11                  Create chart from selected data.

·         Ctrl + Shift + ;   Enter the current time.

·         Ctrl + ;              Enter the current date.

·         Alt + Shift + F1 Insert New Worksheet.

·         Alt + Enter        While typing text in a cell, pressing Alt + Enter will move to the next line, allowing
                            for multiple lines of text in one cell.

·         Shift + F3         Open the Excel formula window.

·         Shift + F5         Bring up search box.

·         Ctrl + 1             Open the Format Cells window.

·         Ctrl + A             Select all contents of the worksheet.

·         Ctrl + B             Bold highlighted selection.

·         Ctrl + I              Italic highlighted selection.

·         Ctrl + K             Insert link.

·         Ctrl + S             Save the open worksheet.

·         Ctrl + U             Underline highlighted selection.

·         Ctrl + 1             Change the format of selected cells.

·         Ctrl + 5             Strikethrough highlighted selection.

·         Ctrl + P             Bring up the print dialog box to begin the printing process.

·         Ctrl + Z             Undo last action.

·         Ctrl + F3           Open Excel Name Manager.

·         Ctrl + F9           Minimize current window.

·         Ctrl + F10          Maximize currently selected window.

·         Ctrl + F6           Switch between open workbooks or windows.

·         Ctrl + Page up   Move between work sheets in the same document.

·         Ctrl + Page down          Move between work sheets in the same document.

·         Ctrl + Tab          Move between Two or more open Excel files.

·         Alt + =              Create a formula to sum all of the above cells.

·         Ctrl + '              Insert the value of the above cell into the cell currently selected.

·         Ctrl + Shift + 1  Format number in comma format.

·         Ctrl + Shift + 4  Format number in currency format.

·         Ctrl + Shift + 3  Format number in date format.

·         Ctrl + Shift + 5  Format number in percentage format.

·         Ctrl + Shift + 6  Format number in scientific format.

·         Ctrl + Shift + 2  Format number in time format.

·         Ctrl + Arrow key            Move to next section of text.

·         Ctrl + Space      Select entire column.

·         Shift + Space    Select entire row.

·         Ctrl + -              Delete the selected column or row.

·         Ctrl + Shift + =  Insert a new column or row.

·         Ctrl + Home      Move to cell A1.

·         Ctrl + ~             Switch between showing Excel formulas or their values in cells.