• Microsoft Excel shortcut keys

    Shortcut Key Function
    F2 Edit the selected cell.
    F5 Go to a specific cell. For example, C6.
    F7 Spell check selected text or document.
    F11 Create chart.
    Ctrl + Shift + ; Enter the current time.
    Ctrl + ; Enter the current date.
    Alt + Shift + F1 Insert New Worksheet.
    Shift + F3 Open the Excel formula window.
    Shift + F5 Bring up search box.
    Ctrl + A Select all contents of the worksheet.
    Ctrl + B Bold highlighted selection.
    Ctrl + I Italic highlighted selection.
    Ctrl + K Insert link.
    Ctrl + U Underline highlighted selection.
    Ctrl + 5 Strikethrough highlighted selection.
    Ctrl + P Bring up the print dialog box to begin printing.
    Ctrl + Z Undo last action.
    Ctrl + F9 Minimize current window.
    Ctrl + F10 Maximize currently selected window.
    Ctrl + F6 Switch between open workbooks / windows.
    Ctrl + Page up Move between Excel work sheets in the same Excel document.
    Ctrl + Page down Move between Excel work sheets in the same Excel 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 cell currently selected.
    Ctrl + Shift + ! Format number in comma format.
    Ctrl + Shift + $ Format number in currency format.
    Ctrl + Shift + # Format number in date format.
    Ctrl + Shift + % Format number in percentage format.
    Ctrl + Shift + ^ Format number in scientific format.
    Ctrl + Shift + @ Format number in time format.
    Ctrl + Right Arrow key Move to next section of text.
    Ctrl + Space Select entire column.
    Shift + Space Select entire row.
    Ctrl + W Close document
Comments are closed.