Excel shortcuts

MS Excel Shortcut Keys: The Complete Guide

Welcome to our complete guide to Microsoft Excel shortcut keys. This guide covers all the essential shortcut keys that will help you work faster and more efficiently in Excel. We'll start with the most basic and essential shortcut keys and move on to more advanced and specific shortcut keys that will help you work with large data sets, perform complex calculations, and more.

The first thing to know about Excel shortcut keys is that they are context-sensitive. This means that the shortcut keys you use in one part of Excel may not work in another part. For example, the shortcut keys for inserting a new row in a worksheet will not work when you are editing a cell. To make things easier, we've organized this guide by task, so you can quickly find the shortcut keys you need for the task at hand.

Basic Shortcut Keys

These are the shortcut keys that you will use most often. They will help you navigate around Excel, enter and edit data, and format cells.

Navigating Around Excel

The following shortcut keys will help you move around your worksheet and between different worksheets in a workbook:

  • Ctrl+arrow keys - Move to the edge of the current data region in the direction of the arrow keys.
  • Ctrl+PgUp/PgDn - Move to the previous/next worksheet.
  • Alt+PgUp/PgDn - Move to the previous/next worksheet in the workbook.
  • Ctrl+Tab - Move to the next open workbook.
  • Ctrl+F6 - Move to the next open workbook window.
  • F5 - Display the Go To dialog box.
  • Ctrl+G - Display the Go To dialog box.
  • Ctrl+Home - Move to the beginning of the worksheet.
  • Ctrl+End - Move to the last used cell on the worksheet.
  • Ctrl+Page Up - Move one screen to the left in a worksheet.
  • Ctrl+Page Down - Move one screen to the right in a worksheet.

Entering and Editing Data

The following shortcut keys will help you enter and edit data in cells:

  • F2 - Edit the active cell.
  • Enter - Complete a cell entry and move down one cell in the same column.
  • Shift+Enter - Complete a cell entry and move up one cell in the same column.
  • Ctrl+Enter - Complete a cell entry and move down one cell in the same column, but do not move to the next cell.
  • Tab - Move to the next cell in the same row.
  • Shift+Tab - Move to the previous cell in the same row.
  • Alt+Enter - Insert a line break in the same cell.
  • Ctrl+Shift+' - Copy the value from the cell above the active cell into the cell or the Formula Bar.
  • Ctrl+' - Copy a formula from the cell above the active cell into the cell or the Formula Bar.
  • Shift+F2 - Edit a cell comment.
  • Ctrl+Shift+O - Insert the contents of the clipboard as an object.
  • Ctrl+Shift+~ - Apply the General number format.
  • Ctrl+Shift+! - Apply the Comma number format.
  • Ctrl+Shift+^ - Apply the Exponential number format.
  • Ctrl+Shift+# - Apply the Date number format with the day, month, and year.
  • Ctrl+Shift+@ - Apply the Time number format with the hour, minute, and second.
  • Ctrl+Shift+$ - Apply the Currency number format.
  • Ctrl+Shift+% - Apply the Percent number format.
  • Ctrl+Shift+& - Apply the Outline border to the selected cells.
  • Ctrl+- - Delete the selected cells.
  • Ctrl+Shift+( - Insert cells.
  • Ctrl+Shift+) - Delete cells.
  • Ctrl+Shift+& - Apply or remove the Outline border from the selected cells.
  • F4 - Repeat the last action.
  • Ctrl+Y - Repeat the last action.
  • Ctrl+Z - Undo the last action.
  • Ctrl+Shift+Z - Redo the last action.
  • Ctrl+A - Select all cells in the worksheet.
  • Ctrl+B - Apply or remove bold formatting.
  • Ctrl+I - Apply or remove italic formatting.
  • Ctrl+U - Apply or remove underline formatting.
  • Ctrl+Shift+< - Decrease the font size.
  • Ctrl+Shift+> - Increase the font size.
  • Ctrl+[ - Apply or remove the Superscript font style.
  • Ctrl+] - Apply or remove the Subscript font style.
  • Ctrl+Shift+" - Apply or remove the Double Underline font style.
  • Ctrl+5 - Apply or remove the Strikethrough font style.
  • Ctrl+E - Center the selected cells.
  • Ctrl+J - Justify the selected cells.
  • Ctrl+L - Align the selected cells to the left.
  • Ctrl+R - Align the selected cells to the right.
  • Ctrl+M - Indent the selected cells.
  • Ctrl+Shift+M - Outdent the selected cells.
  • Ctrl+Shift+< - Decrease the font size of the selected cells.
  • Ctrl+Shift+> - Increase the font size of the selected cells.
  • Ctrl+Shift+" - Apply or remove the Double Underline font style from the selected cells.
  • Ctrl+Shift+5 - Apply or remove the Strikethrough font style from the selected cells.
  • Ctrl+1 - Display the Format Cells dialog box.
  • Ctrl+2 - Apply or remove bold formatting from the selected cells.
  • Ctrl+3 - Apply or remove italic formatting from the selected cells.
  • Ctrl+4 - Apply or remove underline formatting from the selected cells.
  • Ctrl+9 - Hide the selected cells.
  • Ctrl+0 - Show the selected cells.
  • Ctrl+& - Apply or remove the Outline border from the selected cells.
  • Ctrl+_ - Delete the selected cells.
  • Ctrl+Shift+' - Copy the value from the cell above the active cell into the cell or the Formula Bar.
  • Ctrl+Shift+" - Apply or remove the Double Underline font style from the selected cells.
  • Ctrl+Shift+# - Apply the Date number format with the day, month, and year to the selected cells.
  • Ctrl+Shift+@ - Apply the Time number format with the hour, minute, and second to the selected cells.
  • Ctrl+Shift+! - Apply the Comma number format to the selected cells.
  • Ctrl+Shift+^ - Apply the Exponential number format to

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.