Excel shortcuts

Excel Shortcut Keys Chart: The Complete Guide

Welcome to our complete guide to Excel shortcut keys! This comprehensive list includes both built-in shortcut keys and custom shortcut keys that you can create yourself. We'll show you how to use both types of shortcuts to save time and boost your productivity.

Excel shortcut keys are a great way to speed up your work. By using shortcut keys, you can quickly perform common tasks, such as inserting rows or columns, without having to take your hands off the keyboard.

There are two types of shortcut keys in Excel:

  • Built-in shortcut keys: These are shortcut keys that are built into Excel. You can use them without having to create a custom shortcut key.
  • Custom shortcut keys: These are shortcut keys that you create yourself. You can use them for any task that you perform frequently.

In this guide, we'll show you how to use both types of shortcut keys. We'll also provide a list of the most popular shortcut keys so that you can start using them right away.

How to Use Shortcut Keys

Shortcut keys are a great way to save time and boost your productivity. However, they can be a bit tricky to use at first. In this section, we'll show you how to use shortcut keys effectively.

When you use a shortcut key, you'll press a combination of two or more keys at the same time. For example, the shortcut key for inserting a row is Ctrl+Shift+. To use this shortcut key, you would press and hold down the Ctrl key, then press and hold down the Shift key, and finally press the + key.

You can use shortcut keys with both the regular keyboard and the numeric keypad. However, we recommend using the regular keyboard for most shortcut keys. This is because the numeric keypad can be a bit confusing, especially if you're new to using shortcut keys.

When you use a shortcut key, you'll usually see one of two things happen:

  • A menu will appear. For example, if you use the shortcut key for inserting a row, a menu will appear with the options "Insert Row Above" and "Insert Row Below".
  • An action will be performed. For example, if you use the shortcut key for inserting a column, a column will be inserted to the left of the cell that you're currently in.

In some cases, you'll need to use a shortcut key more than once to perform an action. For example, the shortcut key for inserting a new worksheet is Ctrl+Shift+. To use this shortcut key, you would press and hold down the Ctrl key, then press and hold down the Shift key, and finally press the + key twice.

You can also use shortcut keys to access menu items. For example, the shortcut key for opening the File menu is Alt+F. To use this shortcut key, you would press and hold down the Alt key, then press the F key.

In some cases, you'll need to use a shortcut key more than once to access a menu item. For example, the shortcut key for opening the Save As dialog box is Alt+F+A. To use this shortcut key, you would press and hold down the Alt key, then press the F key, and finally press the A key.

List of Popular Shortcut Keys

In this section, we'll provide a list of the most popular shortcut keys. We'll also show you how to create custom shortcut keys for any task that you perform frequently.

The following is a list of the most popular shortcut keys:

<Shortcut KeyActionCtrl+ASelect allCtrl+BBoldCtrl+CCopyCtrl+DFill downCtrl+EAlign centerCtrl+FFindCtrl+GGo toCtrl+HReplaceCtrl+IItalicCtrl+JJustifyCtrl+KInsert hyperlinkCtrl+LAlign leftCtrl+MIndentCtrl+NNewCtrl+OOpenCtrl+PPrintCtrl+RAlign rightCtrl+SSaveCtrl+TCreate tableCtrl+UUnderlineCtrl+VPasteCtrl+WCloseCtrl+XCutCtrl+YRepeatCtrl+ZUndoCtrl+Shift+ASelect entire columnCtrl+Shift+BBordersCtrl+Shift+CCopy as valuesCtrl+Shift+DFill down as valuesCtrl+Shift+EFill rightCtrl+Shift+FFilterCtrl+Shift+GGroupCtrl+Shift+HReplace allCtrl+Shift+IInsertCtrl+Shift+JJustify distributedCtrl+Shift+KInsert hyperlinkCtrl+Shift+LRemove hyperlinksCtrl+Shift+MOutdentCtrl+Shift+NNew worksheetCtrl+Shift+OOpen hyperlinkCtrl+Shift+PPrint previewCtrl+Shift+RFill right as valuesCtrl+Shift+SSave asCtrl+Shift+TUngroupCtrl+Shift+UUnindent

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.