MS Office - Excel Keyboard Shortcuts

The are the most comonly used shortcut keys for Windows systems I used them all the time and it helps me be more productive in my work.

  • Ctrl + E - Select All
  • Ctrl + N - Bold
  • Ctrl + C - Copy
  • Ctrl + D - Fill
  • Ctrl + B - Search
  • Ctrl + G - Save
  • Ctrl + L - Replace
  • Ctrl + K - Italic
  • Ctrl + U - New Workbook
  • Ctrl + A - Open
  • Ctrl + P - Print
  • Ctrl + R - Not good at all
  • Ctrl + S - Underlining
  • Ctrl + V - Paste
  • Ctrl W - Close
  • Ctrl + X - Cut
  • Ctrl + Y - Repeat
  • Ctrl + Z - Undo
  • F1 - Help
  • F2 - Editing
  • F3 - Paste the name
  • F4 - Repeat the last action.
  • F4 - When entering a formula, switch between absolute/relative references
  • F5 - Go to
  • F6 - Next Panel
  • F7 - Spell Checker
  • F8 - Mode extension.
  • F9 - Recalculate all workbooks
  • F10 - Activate the menu bar
  • F11 - New graphics
  • F12 - Save As
  • Ctrl +: - Insert the current time
  • Ctrl+; - Insert the current date.
  • Ctrl + "- Copy the value of the cell above
  • Ctrl + '- Copy the formula from the cell above
  • Change - Compensation adjustment for additional functions in Excel menu
  • Shift + F1 - What is it?
  • Shift + F2 - Edit cell comment
  • Shift + F3 - Paste the function into the formula
  • Shift + F4 - Find Next
  • Shift + F5 - Search
  • Shift + F6 - Previous Panel
  • Shift + F8 - Add to selection
  • Shift + F9 - Calculate the active spreadsheet
  • Shift + F10 - Pop-up menu display
  • Shift + F11 - New spreadsheet
  • Shift + F12 - Save
  • Ctrl + F3 - Set Name
  • Ctrl + F4 - Close
  • Ctrl + F5 - XL, restore window size
  • Ctrl + F6 - Next Workbook Window
  • Shift + Ctrl + F6 - Previous Workbook Window
  • Ctrl + F7 - Move window
  • Ctrl + F8 - Resize Window
  • Ctrl + F9 - Minimize Workbook
  • Ctrl + F10 - Maximize or Restore Window
  • Ctrl + F11 - Insert 4.0 macro sheet
  • Ctrl + F1 - Open file
  • Alt + F1 - Insert a chart
  • Alt + F2 - Save As
  • Alt + F4 - Output
  • Alt + F8 - Macro dialog box
  • Alt + F11 - Editor de Visual Basic
  • Alt + 64 - @
  • CTRL + Esc. You can quickly return to the home screen. And nothing has happened here.
  • Ctrl + Shift + F3 - Create a name using row and column label names
  • Ctrl + Shift + F6 - Previous window
  • Ctrl + Shift + F12 - Printing
  • Alt + Shift + F1 - New spreadsheet
  • Alt + Shift + F2 - Save
  • Alt + = - AutoSum
  • Ctrl + '- Change value / display of formula
  • Ctrl + Shift + A - Insert argument names into formula
  • Alt + down arrow - automatic view list
  • Alt+' - Style dialog format
  • Ctrl + Shift + ~ - General format
  • Ctrl + Shift + @ - Time format
  • Ctrl + Shift + # - Date format
  • Ctrl + Shift + $ - Currency format
  • Ctrl + Shift +% - Percentage format
  • Ctrl + Shift + ^ - Exponential format
  • Ctrl + Shift + & - Place the contour border around the selected cells
  • Ctrl + Shift + _ - Remove the edge of the outline
  • Ctrl + Shift + * - Select the current region
Excel Headers Alphabet ABC Rows and Columns