Most Used Excel Shortcut Keys

The most used Excel shortcut keys on Windows are Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo, Ctrl+S to save, Ctrl+F to find, Ctrl+Arrow keys to move through data, Ctrl+1 to format cells, and Alt+= to insert a sum. These shortcuts cover common editing, navigation, formatting, and calculation tasks; the best ones to learn first are the commands you repeat every day.

The everyday shortcuts to learn first

For Microsoft Excel for Microsoft 365 on Windows, these are useful starting points. Press and hold the first key, then tap the second; for a three-key combination, hold the first two keys while tapping the third.

Ctrl+C / Ctrl+X / Ctrl+V: copy, cut, and paste selected cells or content.
Ctrl+Z / Ctrl+Y: undo the last action and redo an action that was undone.
Ctrl+S: save the workbook. For a new file, Excel may ask you to choose a name and location.
Ctrl+F / Ctrl+H: find text or values, and open Find and Replace.
Ctrl+1: open the Format Cells dialog, where you can change number formats, alignment, borders, and more.
Ctrl+B / Ctrl+I / Ctrl+U: toggle bold, italic, and underline for selected cells or text.
Alt+=: insert an AutoSum formula in a suitable nearby cell.
Ctrl+Arrow key: jump to the edge of a continuous block of data in that direction.

These are not the only useful combinations, and a shortcut does not always do precisely the same thing in every context. For example, Ctrl+C copies selected cells, but if you are editing text inside a cell, Excel copies the selected text instead. Knowing what is selected is part of using shortcuts reliably.

Move around a worksheet faster

Navigation shortcuts reduce the need to scroll through large sheets. Ctrl+Home moves to the beginning of the worksheet, usually cell A1. Ctrl+End moves to the last cell Excel considers used, which can be farther down or to the right than the visible data if formatting or old entries remain there. Ctrl+Arrow moves to the edge of a contiguous data region; if the adjacent cell is blank, the jump may stop at the next filled area rather than at the end of the sheet.

Home: move to the beginning of the current row.
Page Up / Page Down: move one screen up or down.
Ctrl+Page Up / Ctrl+Page Down: switch to the previous or next worksheet tab.
F5 or Ctrl+G: open Go To, where you can enter a cell reference such as G250 and jump directly there.

For example, if a table has uninterrupted values in A1:D500, click a cell in the table and use Ctrl+Down to move to the bottom of that continuous run in the current column. If a blank cell interrupts the entries, the shortcut stops at the edge of the current block. This is why it is helpful to understand the shape of the data before relying on a jump.

Select cells, rows, and columns

Selection shortcuts pair well with navigation. Hold Shift while pressing an arrow key to extend the selection one cell at a time. Ctrl+Shift+Arrow extends the selection toward the edge of a continuous data region. This is useful for selecting a long list without dragging the mouse, but check the highlighted range before applying a change: blank cells can affect where the selection ends.

Ctrl+Space: select the entire column containing the active cell.
Shift+Space: select the entire row containing the active cell.
Ctrl+A: select the current data region; pressing it again can expand the selection, depending on where the active cell is and whether the data is in a table.
Ctrl+Shift+End: extend a selection from the active cell to the last used cell.

These commands can make whole-column or whole-row operations quick, but they can also affect more cells than intended. Before deleting, clearing, or formatting a selection, look at the row and column headers and confirm that the highlighted area is the one you mean to change.

Edit cells and manage data

Double-clicking a cell is not the only way to edit its contents. Press F2 to edit the active cell, then use the arrow keys to move the insertion point within the entry. Press Enter to commit the change, or Esc to cancel the edit. If you are entering values into a range, Enter usually confirms an entry and moves down; Tab confirms it and moves right.

Ctrl+D fills the selected cells downward using the top cell, while Ctrl+R fills to the right using the leftmost cell. These are handy when copying a formula or repeated entry through a range. Review the result when formulas refer to different rows or columns: Excel adjusts relative references as it fills, which is usually helpful but may not match every intended calculation.

To turn a data range into an Excel table, click inside the range and press Ctrl+T. Check the suggested range and whether the first row contains headers before confirming. Tables provide filter controls and can expand as you add adjacent data. Ctrl+Shift+L toggles filter buttons for a range; if you are already using a table, its header filters may already be available.

Format cells and display values

Ctrl+1 is one of the most versatile formatting shortcuts because it opens a single dialog with several categories. Use its Number tab to display values as currency, dates, percentages, or other formats; the underlying value generally remains the same. For example, formatting 0.25 as a percentage displays 25%, while applying a date format changes how Excel displays a date serial value.

Other quick formatting commands include Ctrl+B for bold, Ctrl+I for italic, and Ctrl+U for underline. To apply a built-in number format, use Ctrl+Shift+Dollar sign for Currency, Ctrl+Shift+Percent sign for Percentage, or Ctrl+Shift+Number sign for a date format. These combinations can be affected by keyboard layout and regional settings, so use Ctrl+1 if the key sequence is inconvenient or if you need to choose a specific format.

For readability, shortcuts should support a consistent layout rather than replace one. A report with many different number formats can be harder to interpret than one that uses a clear format for each kind of value. Select the relevant cells first, then apply formatting; otherwise, Excel may format only the active cell.

Work with formulas and calculation

Alt+= is the quick route to AutoSum. Select a blank cell below a column of numbers, or beside a row of numbers, and press the shortcut. Excel proposes a SUM formula based on nearby values; inspect the proposed range before pressing Enter, especially if there are blank rows or unrelated numbers nearby. AutoSum is a convenience, not a guarantee that Excel has identified the intended inputs.

When writing a formula, F4 has a useful context-dependent role. While editing a cell reference in a formula, pressing F4 cycles through reference types such as A1, $A$1, A$1, and $A1. The dollar signs control whether the row or column stays fixed when a formula is copied. Outside formula editing, F4 can repeat the last action in some contexts, though not every Excel command can be repeated this way.

Ctrl+` (the grave-accent key, often near the top-left of a US keyboard) toggles between displaying formula results and displaying formulas in the worksheet. The symbol’s location differs on some keyboard layouts. This view can help check a sheet’s formulas, but it changes the display for the worksheet rather than converting formulas into text or values.

Manage worksheets and workbook tasks

Ctrl+N creates a new workbook, Ctrl+O opens the file picker, Ctrl+P opens print settings, and Ctrl+W closes the current workbook window. Ctrl+S remains the essential habit when working on a file stored locally. Microsoft 365 files saved to OneDrive or SharePoint may also save changes automatically, but check the application’s save status rather than assuming every change has reached its destination.

To insert the current date as a fixed value, press Ctrl+; (semicolon). Ctrl+Shift+; inserts the current time. These commands enter a value at the time you use them; they do not keep updating like a formula that returns the current date or time. That difference matters for logs and records where you want to preserve when an entry was made.

For a manual line break inside a cell, press Alt+Enter while editing the cell. The row may need to be taller to show all the lines. Pressing Enter by itself normally commits the entry and moves the selection, so use the in-cell shortcut when you need a multi-line label or note.

A practical shortcut workflow

Shortcuts become easier to remember when they are attached to a repeated task. Consider cleaning a small sales list: use Ctrl+F to locate a customer name, Ctrl+T to make the range a table, and Ctrl+Shift+L if you need to toggle filters on a non-table range. Use Ctrl+Arrow to move through a continuous column, Ctrl+1 to set a consistent number format, and Ctrl+S to save. If a step produces an unintended result, Ctrl+Z can undo many actions immediately.

Build a small personal routine rather than memorizing a long chart all at once. A sensible learning order is:

Learn copy, paste, undo, save, and find.
Add navigation and selection shortcuts for the size of worksheets you use.
Learn formatting, tables, and AutoSum when those tasks come up regularly.
Practice on a copy of important data when a shortcut changes a large selection.

Excel also displays many shortcuts in menus and ScreenTips, and the exact available combinations can depend on the command, keyboard layout, and version. If a combination is hard to reach, using the ribbon or a context menu is a valid alternative; speed is useful only when the result is correct.

Windows, Mac, and Excel for the web

This guide gives Windows shortcuts. On Excel for Mac, many everyday commands use Command instead of Ctrl: for example, Command+C copies, Command+V pastes, Command+Z undoes, Command+S saves, and Command+F finds. Some shortcuts do not translate by simply swapping Ctrl for Command, and function-key behavior can depend on macOS keyboard settings. Check Excel for Mac’s menus or shortcut help when a specific combination differs.

Excel for the web runs inside a browser, so some key combinations can be intercepted by the browser or operating system. The web app also differs from desktop Excel in some features and shortcut behavior. If a shortcut opens a browser function instead of an Excel command, use the ribbon command or consult the shortcut list for the web version. The desktop Windows combinations in this article should not be assumed to work identically on every platform.

Common shortcut problems

A shortcut may appear not to work for several ordinary reasons. The active cell may be in edit mode, a dialog may be open, a different application may have focus, or a laptop may require an Fn key for function keys such as F2. If Ctrl+Arrow stops early, check for blank cells separating data. If Ctrl+End lands far beyond the visible table, the worksheet may contain old formatting or content that Excel still treats as used.

Shortcuts also have limits. Ctrl+Z does not undo every possible action, and some operations—especially actions outside the normal cell-editing history—may not be reversible. Save important work before making broad changes, and verify the selection before deleting rows, clearing content, or replacing values. For bulk edits, using a copy of the workbook provides a safer fallback than relying only on undo.

Frequently Asked Questions

What is the most useful Excel shortcut to learn first?
For many people, Ctrl+Z is a practical first choice because it quickly reverses many recent actions. Ctrl+S is equally important as a saving habit, while Ctrl+C and Ctrl+V help with routine editing. The best first shortcut depends on the task you repeat most.

What does Ctrl+1 do in Excel?
Ctrl+1 opens the Format Cells dialog. From there, you can change number formats, alignment, fonts, borders, and protection settings for the selected cells.

How do I select an entire row or column with a shortcut?
Click a cell in the target row and press Shift+Space to select the row. Click a cell in the target column and press Ctrl+Space to select the column on Windows.

Why does Ctrl+End go past my data?
Ctrl+End moves to Excel’s last used cell, which may reflect old entries or formatting beyond your visible data. Check for leftover content or formatting in distant rows and columns before deciding whether to clean up the sheet.

Are Excel shortcuts the same on Mac?
No. Many common Mac commands use Command where Windows uses Ctrl, but not all shortcuts follow that pattern. Check Excel for Mac’s menus or shortcut help for commands involving navigation, function keys, or less common actions.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.