Excel shortcut keys

  • F2 -- Edit the selected cell.
  • F5 -- Go to a specific cell.
  • F7 -- Spell check selected text and/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 the search box
  • Ctrl + A -- Select all contents of a worksheet.
  • Ctrl + B -- Bold highlighted selection.
  • Ctrl + I -- Italicize highlighted selection.
  • Ctrl + C -- Copy selected text.
  • Ctrl + V -- Paste
  • Ctrl + D -- Fill
  • Ctrl + K -- Insert link
  • Ctrl + F -- Open find and replace options.
  • Ctrl + G -- Open go-to options.
  • Ctrl + H -- Open find and replace options.
  • Ctrl + U -- Underline highlighted selection.
  • Ctrl + Y -- Underline selected text.
  • Ctrl + 5 -- Strikethrough highlighted selection.
  • Ctrl + O -- Open options.
  • Ctrl + N -- Open new document.
  • Ctrl + P -- Open print dialog box.
  • Ctrl + S -- Save.
  • 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 & Page Down -- Move between Excel worksheets in the same document.
  • Ctrl + Tab -- Move between two or more open Excel files
  • Alt + = -- Create the formula to sum all of the above cells.
  • Ctrl + -- Insert the value of above cell into the current cell.
  • 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) -- Move to next section of text.
  • Ctrl + Space -- Select entire column.
  • Shift + Space -- Select entire row.
  • Ctrl + W -- Close document.

Outlook shortcut keys

  • Alt + S -- Send the email.
  • Ctrl + C -- Copy selected text.
  • Ctrl + X -- Cut selected text.
  • Ctrl + P -- Open print dialog box.
  • Ctrl + K -- Complete name/email typed in address bar.
  • Ctrl + B -- Bold highlighted selection.
  • Ctrl + I -- Italicize highlighted selection.
  • Ctrl + U -- Underline highlighted selection.
  • Ctrl + R -- Reply to an email.
  • Ctrl + F -- Forward an email.
  • Ctrl + N -- Create a new email.
  • Ctrl + Shift + A -- Create a new appointment to your calendar.
  • Ctrl + Shift + O -- Open the outbox.
  • Ctrl + Shift + I -- Open the inbox.
  • Ctrl + Shift + K -- Add a new task.
  • Ctrl + Shift + C -- Create a new contact.
  • Ctrl + Shift+ J -- Create a new journal entry.