Cette page est actuellement disponible uniquement en anglais.

Excel Keyboard Shortcuts

Learn the most useful Excel keyboard shortcuts

We use keyboard shortcuts every day. They are one of the easiest ways to work more efficiently in Excel. They can help you work faster, reduce mouse use, and make common tasks easier.

Shortcut key	Action
`Ctrl`+`A`	Select the current region if the worksheet contains data. Press a second time to select the current region and its summary rows. Press a third time to select the entire worksheet.
`Ctrl`+`B`	Bold text or remove bold formatting.
`Ctrl`+`C`	Copy
`Ctrl`+`D`	Fill Down
`Ctrl`+`E`	Flash Fill
`Ctrl`+`F`	Find
`Ctrl`+`G`	Goto
`Ctrl`+`H`	Replace
`Ctrl`+`I`	Italicize text or remove italic formatting.
`Ctrl`+`K`	Insert Hyperlink
`Ctrl`+`N`	New Workbook
`Ctrl`+`O`	Open
`Ctrl`+`P`	Print
`Ctrl`+`R`	Fill Right
`Ctrl`+`S`	Save
`Ctrl`+`U`	Underline text or remove underline.
`Ctrl`+`V`	Paste
`Ctrl`+`Shift`+`V`	Paste values
`Ctrl`+`W`	Close
`Ctrl`+`X`	Cut
`Ctrl`+`Y`	Repeat
`Ctrl`+`Z`	Undo
`F1`	Help
`F2`	Edit
`F3`	Paste Name
`F4`	Repeat last action
`F4`	While typing a formula, switch between absolute/relative refs
`F5`	Goto
`F6`	Next Pane
`F7`	Spell check
`F8`	Extend mode
`F9`	Recalculate all workbooks
`F10`	Activate Menubar
`F11`	New Chart
`F12`	Save As
`Ctrl`+`Shift`+`:`	Insert Current Time
`Ctrl`+`;`	Insert Current Date
`Ctrl`+`Shift`+`"`	Copy Value from Cell Above
`Ctrl`+`'`	Copy Formula from Cell Above
`Shift`	Hold down shift for additional functions in Excel's menu
`Shift`+`F1`	What's This?
`Shift`+`F2`	Edit cell comment
`Shift`+`F3`	Paste function into formula
`Shift`+`F4`	Find Next
`Shift`+`F5`	Find
`Shift`+`F6`	Previous Pane
`Shift`+`F8`	Add to selection
`Shift`+`F9`	Calculate active worksheet
`Ctrl`+`Alt`+`F9`	Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
`Ctrl`+`Alt`+`Shift`+`F9`	Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
`Shift`+`F10`	Display shortcut menu
`Shift`+`F11`	New worksheet
`Shift`+`F12`	Save
`Ctrl`+`F3`	Define name
`Ctrl`+`F4`	Close
`Ctrl`+`F5`	XL, Restore window size
`Ctrl`+`F6`	Next workbook window
`Ctrl`+`Shift`+`F6`	Previous workbook window
`Ctrl`+`F7`	Move window
`Ctrl`+`F8`	Resize window
`Ctrl`+`F9`	Minimize workbook
`Ctrl`+`F10`	Maximize or restore window
`Ctrl`+`F11`	Inset 4.0 Macro sheet
`Ctrl`+`F12`	File Open
`Alt`+`F1`	Insert Chart
`Alt`+`F2`	Save As
`Alt`+`F4`	Exit
`Alt`+`F8`	Macro dialog box
`Alt`+`F11`	Open the Microsoft Visual Basic For Applications Editor.
`Alt`+`F12`	Open the Power Query Editor
`Ctrl`+`Shift`+`F3`	Create name by using names of row and column labels
`Ctrl`+`Shift`+`F12`	Print
`Alt`+`Shift`+`F1`	New worksheet
`Alt`+`Shift`+`F2`	Save
`Alt`+`=`	AutoSum
`Ctrl`+`	Toggle Value/Formula display
`Ctrl`+`Shift`+`A`	Insert argument names into formula
`Alt`+`Down arrow`	Display AutoComplete list
`Alt`+`'`	Format Style dialog box
`Ctrl`+`Shift`+`~`	Apply the General number format.
`Ctrl`+`Shift`+`!`	Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
`Ctrl`+`Shift`+`@`	Apply the Time format with the hour and minute, and AM or PM.
`Ctrl`+`Shift`+`#`	Apply the Date format with the day, month, and year.
`Ctrl`+`Shift`+`$`	Apply the Currency format with two decimal places (negative numbers in parentheses).
`Ctrl`+`Shift`+`%`	Apply the Percentage format with no decimal places.
`Ctrl`+`Shift`+`^`	Apply the Scientific number format with two decimal places.
`Ctrl`+`Shift`+`&`	Apply an outline border to the selected cells.
`Ctrl`+`Shift`+`_`	Remove the outline border from the selected cells.
`Ctrl`+`Shift`+`*`	Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report.
`Ctrl`+`Shift++`	Insert
`Ctrl`+`-`	Delete
`Ctrl`+`1`	Format cells dialog box
`Ctrl`+`2`	Bold text or remove bold formatting.
`Ctrl`+`3`	Italicize text or remove italic formatting.
`Ctrl`+`4`	Underline text or remove underline.
`Ctrl`+`5`	Apply or remove strikethrough formatting.
`Ctrl`+`6`	Switch between hiding objects, displaying objects, and displaying placeholders for objects.
`Ctrl`+`7`	Show/Hide Standard toolbar
`Ctrl`+`8`	Display or hide the outline symbols.
`Ctrl`+`9`	Hide the selected rows.
`Ctrl`+`0`	Hide the selected columns.
`Ctrl`+`Shift`+`(`	Unhide rows
`Ctrl`+`Shift`+`)`	Unhide columns
`Alt` or `F10`	Activate the menu
`Ctrl`+`Tab`	In toolbar: next toolbar In a workbook: activate next workbook
`Shift`+`Ctrl`+`Tab`	In toolbar: previous toolbar In a workbook: activate previous workbook
`Tab`	Move to the next cell in a worksheet or the next option in a dialog box.
`Shift`+`Tab`	Move to the previous cell in a worksheet or the previous option in a dialog box.
`Enter`	Do the command
`Alt`+`Enter`	Start a new line in the same cell.
`Ctrl`+`Enter`	Fill the selected cell range with the current entry.
`Shift`+`Enter`	Complete a cell entry and select the cell above.
`Shift`+`Ctrl`+`F`	Font Drop Down List
`Shift`+`Ctrl`+`P`	Point size Drop Down List
`Ctrl`+`Spacebar`	Select the entire column
`Shift`+`Spacebar`	Select the entire row
`Ctrl`+`Backspace`	Jump back to the active cell and bring it into view
`Ctrl`+`/`	Select the array containing the active cell.
`Ctrl`+`Shift`+`O`	Select all cells that contain comments.
`Ctrl`+`\`	In a selected row, select the cells that don't match the formula or static value in the active cell.
`Ctrl`+`Shift`+`\|`	In a selected column, select the cells that don't match the formula or static value in the active cell.
`Ctrl`+`[`	Select all cells directly referenced by formulas in the selection.
`Ctrl`+`Shift`+`{`	Select all cells directly or indirectly referenced by formulas in the selection.
`Ctrl`+`]`	Select cells that contain formulas that directly reference the active cell.
`Ctrl`+`Shift`+`}`	Select cells that contain formulas that directly or indirectly reference the active cell.
`Alt`+`;`	Select the visible cells in the current selection.
`Shift`+`Backspace`	With multiple cells selected, select only the active cell.
`Ctrl`+`Shift`+`Home`	Extend the selection of cells to the beginning of the worksheet.
`Ctrl`+`Shift`+`Spacebar`	Selects the entire worksheet. If the worksheet contains data, Ctrl+Shift+Spacebar selects the current region. Ctrl+Shift+Spacebar a second time selects the entire worksheet. When an object is selected, Ctrl+Shift+Spacebar selects all objects on a worksheet
`Ctrl`+`Alt`+`L`	Reapply the filter and sort on the current range so that changes you've made are included
`Ctrl`+`Alt`+`V`	Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
`Up arrow key`	Move one cell up in a worksheet.
`Down arrow key`	Move one cell down in a worksheet.
`Left arrow key`	Move one cell left in a worksheet.
`Right arrow key`	Move one cell right in a worksheet.
`Ctrl`+`Arrow key`	Move to the edge of the current data region in a worksheet.
`End`, `Arrow key`	Enter the End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the cells are blank, move to the last cell in the row or column.
`Ctrl`+`End`	Move to the last cell on a worksheet, to the lowest used row of the rightmost used column.
`Ctrl`+`Shift`+`End`	Extend the selection of cells to the last used cell on the worksheet (lower-right corner).
`Home`+`Scroll lock`	Move to the cell in the upper-left corner of the window when Scroll lock is turned on.
`Ctrl`+`Home`	Move to the beginning of a worksheet.
`Page down`	Move one screen down in a worksheet.
`Ctrl`+`Page down`	Move to the next sheet in a workbook.
`Alt`+`Page down`	Move one screen to the right in a worksheet.
`Page up`	Move one screen up in a worksheet.
`Alt`+`Page up`	Move one screen to the left in a worksheet.
`Ctrl`+`Page up`	Move to the previous sheet in a workbook.
`Ctrl`+`Alt`+`=`	Zoom in.
`Ctrl`+`Alt`+`-`	Zoom out.
`Ctrl`+`Shift`+`F2`	Insert a threaded comment or open and reply to a threaded comment.
`Ctrl`+`Shift`+`U`	Expand or collapse the formula bar.
`Ctrl`+`Q`	Display the Quick Analysis options for selected cells that contain data.
`Ctrl`+`L` or `Ctrl`+`T`	Display the Create Table dialog box.
`Ctrl`+`Shift`+`G`	Open the Workbook Statistics dialog box.
`Ctrl`+`Shift`+`Page down`	Select the current and next sheet in a workbook.
`Ctrl`+`Shift`+`Page up`	Select the current and previous sheet in a workbook.
`Shift`+`Arrow key`	Extend the selection of cells by one cell.
`Ctrl`+`Shift`+`Arrow key`	Extend the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell.
`Alt`+`Shift`+`F10`	Display the menu or message for an Error Checking button.

A special thanks goes out to Shane Devenshire who provided most of the shortcuts in this list!

Reference:
Microsoft Office: Excel shortcut and function keys

Shortcut key	Action
`F1`	Help
`F2`	View Object Browser
`F3`	Find Next
`F4`	Properies Window
`F5`	Run Sub/Form or Run Macro
`F6`	Switch Split Windows
`F7`	View Code Window
`F8`	Step Into
`F9`	Toggle Breakpoint
`F10`	Activate Menu Bar
`Shift`+`F2`	View definition
`Shift`+`F3`	Find Previous
`Shift`+`F7`	View Object
`Shift`+`F8`	Step Over
`Shift`+`F9`	Quick Watch
`Shift`+`F10`	Show Right Click Menu
`Ctrl`+`F2`	Focus To Object Box
`Ctrl`+`F4`	Close Window
`Ctrl`+`F8`	Run To Cursor
`Ctrl`+`F10`	Activate Menu Bar
`Alt`+`F4`	Close VBE
`Alt`+`F6`	Switch Between Last 2 Windows
`Alt`+`F11`	Return To Application
`Ctrl`+`Shift`+`F2`	Go to last position
`Ctrl`+`Shift`+`F8`	Step Out
`Ctrl`+`Shift`+`F9`	Clear All Breakpoints
`Insert`	Toggle Insert Mode
`Delete`	Delete
`Home`	Move to beginning of line
`End`	Move to end of line
`Page Up`	Page Up
`Page Down`	Page Down
`Left Arrow`	Left
`Right Arrow`	Right
`Up Arrow`	Up
`Down Arrow`	Down
`Tab`	Indent
`Enter`	New Line
`BackSpace`	Delete Prev Char
`Shift`+`Insert`	Paste
`Shift`+`Home`	Select To Start Of Line
`Shift`+`End`	Select To End Of Line
`Shift`+`Page Up`	Select To Top Of Module
`Shift`+`Page Down`	Select To End Of Module
`Shift`+`Left Arrow`	Extend Selection Left 1 Char
`Shift`+`Right Arrow`	Extend Selection Right 1 Char
`Shift`+`Up Arrow`	Extend Selection Up
`Shift`+`Down Arrow`	Extend Selection Down
`Shift`+`Tab`	Outdent
`Alt`+`Spacebar`	System Menu
`Alt`+`Tab`	Cycle Applications
`Alt`+`BackSpace`	Undo
`Ctrl`+`A`	Select All
`Ctrl`+`C`	Copy
`Ctrl`+`E`	Export Module
`Ctrl`+`F`	Find
`Ctrl`+`G`	Immediate Window
`Ctrl`+`H`	Replace
`Ctrl`+`I`	Turn On Quick Info
`Ctrl`+`J`	List Properties/Methods
`Ctrl`+`L`	Show Call Stack
`Ctrl`+`M`	Import File
`Ctrl`+`N`	New Line
`Ctrl`+`P`	Print
`Ctrl`+`R`	Project Explorer
`Ctrl`+`S`	Save
`Ctrl`+`T`	Show Available Components
`Ctrl`+`V`	Paste
`Ctrl`+`X`	Cut
`Ctrl`+`Y`	Cut Entire Line
`Ctrl`+`Z`	Undo
`Ctrl`+`Insert`	Copy
`Ctrl`+`Delete`	Delete To End Of Word
`Ctrl`+`Home`	Top Of Module
`Ctrl`+`End`	End Of Module
`Ctrl`+`Page Up`	Top Of Current Procedure
`Ctrl`+`Page Down`	End Of Current Procedure
`Ctrl`+`Left Arrow`	Move one word to left
`Ctrl`+`Right Arrow`	Move one word to right
`Ctrl`+`Up Arrow`	Previous Procedure
`Ctrl`+`Down Arrow`	Next Procedure
`Ctrl`+`Spacebar`	Complete Word
`Ctrl`+`Tab`	Cycle Windows
`Ctrl`+`BackSpace`	Delete To Start Of Word
`Ctrl`+`Break/Pause`	Break
`Ctrl`+`Shift`+`I`	Parameter Info
`Ctrl`+`Shift`+`J`	List Constants

Reference:
Microsoft: VBA Code window shortcut keys

By default, the following shortcuts are included in ASAP Utilities.
You can customize them by creating your own list of favorite tools and assigning keyboard shortcuts .
This helps you access your most-used tools faster and spend less time navigating menus.

Shortcut key	Action
`Ctrl`+`Alt`+`A`	Select Adjacent Matching Cells in the Column
`Ctrl`+`Alt`+`B`	Reload Installed Excel Add-ins (Refresh Menus and Commands)
`Ctrl`+`Alt`+`C`	Color Every nth Row or Column in Selection...
`Ctrl`+`Alt`+`D`	Deselect Cells...
`Ctrl`+`Alt`+`E`	Set Temporary Default File Location to Current Folder
`Ctrl`+`Alt`+`F`	List File Names and Properties from Folder...
`Ctrl`+`Alt`+`G`	Export Selection or Sheet to New File (Excel, PDF, TXT, CSV, etc.)...
`Ctrl`+`Alt`+`H`	Advanced Find and Replace...
`Ctrl`+`Alt`+`I`	Apply Calculation to Selected Cells...
`Ctrl`+`Alt`+`J`	Start the Last Used Tool Again...
`Ctrl`+`Alt`+`Shift`+`Right Arrow`	Extend Selection to the Rightmost Used Column
`Ctrl`+`Alt`+`Shift`+`Down Arrow`	Extend Selection to the Lowest Used Row
`Ctrl`+`Alt`+`M`	Move, Extend, or Shrink Range Selections...
`Ctrl`+`Alt`+`N`	Quickly Insert a Named Worksheet...
`Ctrl`+`Alt`+`O`	Advanced Criteria-Based Cell Selection...
`Ctrl`+`Alt`+`P`	Convert Formulas in Selection to Static Values
`Ctrl`+`Alt`+`Q`	Auto Numbering and Labeling of Selected Cells...
`Ctrl`+`Alt`+`R`	Reset Last Cell to Fix Ctrl+End Behavior...
`Ctrl`+`Alt`+`S`	Save File and Create Backup Copy with Timestamp...
`Ctrl`+`Shift`+`I`	Display & Navigation...
`Ctrl`+`Alt`+`X`	Cut and Paste as Values (Keeping Dependents Unchanged)...
`Ctrl`+`Alt`+`Y`	Paste Special with Combined Options...
`Ctrl`+`Shift`+`D`	Insert Current Date and Time with Seconds
`Ctrl`+`Shift`+`T`	Insert Current Time with Seconds
`Ctrl`+`Alt`+`T`	Insert Date Using a Calendar Popup...
`Ctrl`+`Alt`+`Shift`+`C`	Clean Up Data and Formatting...
`Ctrl`+`Alt`+`Shift`+`D`	Count Duplicate Values in Selection (Optional Coloring)...
`Ctrl`+`Alt`+`Shift`+`U`	Change to UPPERCASE
`Ctrl`+`Alt`+`Shift`+`T`	Remove Leading and Trailing Spaces
`Ctrl`+`Alt`+`Shift`+`N`	Convert Numbers Stored as Text to Real Numbers
`Ctrl`+`Alt`+`Z`	Find and Run a Tool...

Many users find that an external keyboard and Excel keyboard shortcuts help them work faster and more efficiently. Because your hands can stay on the keyboard, common tasks often take less time than when using a mouse.

For people with mobility or vision impairments, keyboard shortcuts can be easier to use than a touchscreen and provide an important alternative to using a mouse.