Excel Shortcut Keys With Ctrl, Alt, and Shift Explained

Excel has several useful shortcuts that combine Ctrl, Alt, and Shift, but there is no single shortcut that uses all three for every task. On Windows, examples include Ctrl+Alt+V for Paste Special, Ctrl+Alt+F9 to force a full calculation, and Ctrl+Alt+Shift+F9 to rebuild formula dependencies and recalculate; other common shortcuts use just two of these keys.

What Ctrl, Alt, and Shift Do in Excel

Ctrl, Alt, and Shift are modifier keys: they change what another key does when you press them together. A shortcut written as Ctrl+Shift+L means hold Ctrl and Shift, press L, and then release the keys. For a shortcut with a function key, such as Ctrl+Alt+F9, hold the modifiers while pressing F9. The modifiers do not normally need to be pressed in a particular order.

The plus sign in a shortcut description means the keys are pressed together; it is not a direction to type a plus character. This matters for shortcuts such as Ctrl+Shift+Plus, which opens Excel’s Insert dialog. On many keyboards, typing a plus requires Shift, so the exact physical key combination can depend on your keyboard layout.

These shortcuts are for Excel for Microsoft 365 on Windows. Some are familiar across Excel versions, but updates, keyboard layouts, laptop function-key settings, and other software can affect what happens when a key combination is pressed. A shortcut may also behave differently depending on whether you are editing a cell, selecting a range, or working in a dialog box.

Useful Shortcuts That Combine Ctrl and Alt

Two Ctrl-and-Alt shortcuts are particularly useful for working with copied data and formulas:

Ctrl+Alt+V: Opens the Paste Special dialog after you copy cells. You can choose what to paste, such as values, formulas, formats, or column widths, rather than pasting everything in the copied cells.
Ctrl+Alt+F9: Forces a full calculation of worksheets in all open workbooks. This can help when formulas appear not to have updated, although it may take time in large or formula-heavy workbooks.

For Paste Special, first copy a cell or range, select the destination, and press Ctrl+Alt+V. Then choose the desired option in the dialog and confirm it. For example, if a copied cell contains a formula but you want to keep only its displayed result, choose Values. This pastes the current result without carrying over the formula. The exact dialog choices can depend on what you copied.

Ctrl+Alt+F9 is more forceful than an ordinary recalculation. It tells Excel to calculate formulas rather than relying only on its usual checks of which cells may need updating. Use it when a workbook’s displayed results seem stale, not as a routine shortcut for every edit. If calculation is set to Manual, that setting may be the reason results have not refreshed automatically; you can review it on the Formulas tab under Calculation Options.

The Shortcut That Uses Ctrl, Alt, and Shift Together

Ctrl+Alt+Shift+F9 tells Excel to recheck formula dependencies and then calculate all cells in all open workbooks. In practice, this is a full rebuild of the calculation chain followed by a calculation. It is a troubleshooting option for cases where a workbook’s calculation relationships or results seem inconsistent, not a normal everyday command.

There is a distinction between recalculating and rebuilding dependencies. Excel tracks which formulas rely on which cells so it can update affected results efficiently. Ctrl+Alt+F9 forces a full calculation; Ctrl+Alt+Shift+F9 also asks Excel to recheck those relationships before calculating. Because it can do more work, it may take noticeably longer in a large workbook. Save important changes before using it, and allow Excel time to finish.

Despite the question’s wording, most Excel shortcuts do not require all three modifiers. The three-key combination is specialized; common tasks are generally assigned to simpler combinations. If you are trying to perform a particular action, look up that action rather than assuming that adding Ctrl, Alt, and Shift will reveal a general-purpose command.

Common Ctrl-and-Shift Shortcuts

Ctrl and Shift are paired in a number of everyday Excel shortcuts. They do not all behave alike, so check your selection and task before using them:

Ctrl+Shift+L: Turns filtering on or off for the current data range. With a cell in a contiguous data region selected, Excel adds or removes filter buttons in the header row. It does not itself choose a filter condition.
Ctrl+Shift+U: Expands or collapses the formula bar. This is useful when you need to read or edit a long formula without changing the worksheet’s column widths.
Ctrl+Shift+F3: Opens Create Names from Selection. Excel can make defined names based on labels in the top row, left column, bottom row, or right column of the selected range.
Ctrl+Shift+Enter: Enters a legacy array formula in Excel versions and situations that use the older array-formula behavior. In current Microsoft 365 Excel, dynamic array formulas usually spill results and are typically confirmed with Enter instead.
Ctrl+Shift+Plus: Opens the Insert dialog, allowing you to insert cells, rows, or columns based on your selection.

For example, if you have a table with column headings and records beneath them, select a cell in the data and press Ctrl+Shift+L to add filter buttons. You can then use a heading’s button to display only the rows that match a chosen value. Pressing the shortcut again removes the filter buttons; it does not necessarily clear every filter condition in the way a user might expect, so check the visible rows before continuing.

Choosing the Right Shortcut for the Job

Start with the action you want, then choose the shortest relevant shortcut. Use Ctrl+Alt+V when you need control over the kind of content pasted. Use Ctrl+Shift+L to add or remove filter controls. Use Ctrl+Alt+F9 when formulas need a full recalculation, and reserve Ctrl+Alt+Shift+F9 for a recalculation that should also rebuild formula dependencies.

It is also useful to distinguish shortcuts that open a dialog from those that immediately perform an action. Paste Special and Insert give you choices before changing the sheet. A calculation shortcut starts recalculation, while the filter shortcut toggles filter controls. Before using a shortcut that changes a worksheet, confirm the selected cell or range; Excel often interprets the command in relation to the current selection.

If you are learning several shortcuts, practice them in a copy of a workbook or on a small sample range. This is especially sensible before inserting cells or pasting over existing data. Shortcuts can save time, but they do not make an action reversible in a different way from the corresponding ribbon command.

Why a Shortcut May Not Work

A shortcut that appears correct can fail because Excel is in a different mode or another program receives the keystroke. These checks can help narrow down the cause:

Check the active window: Make sure Excel has focus. A browser, remote desktop tool, screen utility, or another application may intercept a key combination.
Check the current context: Ctrl+Alt+V requires copied content. Some shortcuts behave differently when you are typing inside a cell or when a dialog is open.
Check laptop function keys: F9 may control a laptop feature such as brightness or media playback. Try holding Fn as well, or adjust the function-key behavior using the computer’s keyboard settings.
Check the selected range: Filter, insert, and paste commands depend on the active cell or selection. A selection outside the expected data region can lead to a different result.
Check calculation settings: If formulas do not update after ordinary edits, inspect Formulas > Calculation Options. Manual calculation can make results appear out of date until you recalculate.

Excel for the web runs inside a browser, so browser shortcuts and web-app behavior can affect some key combinations. If a shortcut does not work there, try the Excel ribbon command or check the shortcut guidance for the web version. Do not assume that a Windows desktop shortcut will behave identically in every browser.

Windows, Mac, and Keyboard Differences

The shortcuts above are Windows instructions. Excel for Mac uses a different set of keyboard conventions, often involving Command or Option where Windows instructions use Ctrl or Alt. That does not mean every Windows shortcut has a direct Mac replacement, and laptop function keys may also require the Fn key. For a specific command, use Excel for Mac’s shortcut help or the relevant ribbon/menu command rather than mechanically substituting one modifier for another.

Keyboard layout matters on Windows, too. The key labeled Alt may be positioned differently or share functions with another key, while the plus sign may require a particular Shift combination. When a shortcut includes F9, check whether your keyboard sends the function key itself or a hardware control. The same written shortcut can therefore require an extra Fn press on some laptops.

For options with a visible menu path, the ribbon is a dependable alternative when the shortcut is unavailable. For instance, Paste Special is available from the Home tab after copying cells, and calculation choices are on the Formulas tab. Menu labels and placement can vary somewhat by platform and interface version, so use the command name as well as the path when looking for it.

Frequently Asked Questions

What is the Excel shortcut using Ctrl, Alt, and Shift together?
On Windows, Ctrl+Alt+Shift+F9 rechecks formula dependencies and then calculates all cells in all open workbooks. It is mainly useful for troubleshooting calculation issues, rather than as a routine shortcut.

What does Ctrl+Alt+V do in Excel?
After you copy cells, Ctrl+Alt+V opens the Paste Special dialog. It lets you choose which parts of the copied content to paste, such as values, formulas, or formatting.

What is the shortcut to recalculate everything in Excel?
Ctrl+Alt+F9 forces a full calculation across worksheets in all open workbooks in Excel for Windows. Ctrl+Alt+Shift+F9 goes further by rechecking formula dependencies before calculating.

Does Ctrl+Shift+Enter still work in Microsoft 365 Excel?
It remains relevant for legacy array formulas and some compatibility scenarios. Most new dynamic array formulas in Microsoft 365 are entered with Enter and spill their results into neighboring cells.

Why does F9 not work on my laptop?
Your keyboard may assign F9 to a hardware function. Try Fn+F9, check the laptop’s function-key setting, and confirm that Excel is the active window. The exact behavior depends on the device and its settings.

Keep the Shortcuts That Solve Real Tasks

The most useful combinations are usually the ones matched to a repeatable task: Ctrl+Alt+V for selective pasting, Ctrl+Shift+L for filtering, and Ctrl+Alt+F9 for a full recalculation. Ctrl+Alt+Shift+F9 is worth knowing when formula dependencies may need rebuilding, but it is deliberately a more specialized tool. Learn the shortcut alongside its purpose and limits, and use the ribbon or menu when your platform or keyboard handles the keys differently.

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.