Shortcuts Microsoft Excel for Windows

100 shortcuts8,882,642 viewssupport.office.com

Complete list of keyboard shortcuts for Microsoft Excel on Windows.

Windows	macOS	Linux	Action
`Delete / Backspace`	`Delete / Backspace`	`Delete / Backspace`	Delete one character to the right / left of the cursor
`Ctrl`+`;`	`Cmd`+`;`	`Ctrl`+`;`	Insert the current date at the cursor position
`Shift`+`Пробел`	`Shift`+`Space`	`Shift`+`Space`	Select the current row
`Ctrl`+`Пробел`	`Ctrl`+`Space`	`Ctrl`+`Space`	Select the current column
`Ctrl`+`C`	`Cmd`+`C`	`Ctrl`+`C`	Copy cells to the clipboard
`Ctrl`+`V`	`Cmd`+`V`	`Ctrl`+`V`	Paste cells from the clipboard
`Alt`+`H, AC`	`Cmd`+`Option`+`C`	`Alt`+`H, AC`	Center align
`Знак равно`	`=`	`=`	Start a formula
`Ctrl`+`Shift`+`]`	`Cmd`+`Shift`+`]`	`Ctrl`+`Shift`+`]`	Select all dependents
`Shift`+`F9`	`Shift`+`F9`	`Shift`+`F9`	Calculate active sheet
`Ctrl`+`P`	`Cmd`+`P`	`Ctrl`+`P`	Print
`G в меню печати`	`G in Druckmenü`	`G in Druckmenü`	Page setup
`Alt`+`H , IS`	`Cmd`+`Option`+`I`	`Alt`+`H , IS`	Insert sheet
`Alt`+`H , OM`	`Cmd`+`Option`+`M`	`Alt`+`H , OM`	Move sheet

Document Navigation

Windows	macOS	Linux	Action
`Клавиши со стрелками`	`Pfeiltasten`	`Клавиши со стрелками`	Navigate one cell in any direction
`Прокрутка вниз / Прокрутка вверх`	`Bild nach unten / Bild nach oben`	`Прокрутка вниз / Прокрутка вверх`	Scroll one screen down / up
`Alt`+`Прокрутка вниз / Прокрутка вверх`	`Alt`+`Bild nach unten / Bild nach oben`	`Alt`+`Прокрутка вниз / Прокрутка вверх`	Scroll one screen right / left
`Tab / Shift`+`Tab`	`Tab / Shift`+`Tab`	`Tab / Shift`+`Tab`	Move one cell right / left
`Ctrl`+`Клавиши со стрелками`	`Ctrl`+`Pfeiltasten`	`Ctrl`+`Клавиши со стрелками`	Go to the edge of the next data region (cells containing data)
`Home`	`Home`	`Home`	Go to the beginning of the row
`Ctrl`+`Home`	`Cmd`+`Home`	`Ctrl`+`Home`	Go to the beginning of the sheet
`Ctrl`+`End`	`Cmd`+`End`	`Ctrl`+`End`	Go to the last cell

Selecting and Editing Cell Content

Windows	macOS	Linux	Action
`Shift`+`Клавиши со стрелками`	`Shift`+`Pfeiltasten`	`Shift`+`Клавиши со стрелками`	Extend selection by one cell
`Ctrl`+`Shift`+`Клавиши со стрелками`	`Ctrl`+`Shift`+`Pfeiltasten`	`Ctrl`+`Shift`+`Клавиши со стрелками`	Extend selection to the next non-empty cell
`Ctrl`+`Shift`+`Home`	`Ctrl`+`Shift`+`Home`	`Ctrl`+`Shift`+`Home`	Extend selection to the first cell
`Ctrl`+`Shift`+`End`	`Ctrl`+`Shift`+`End`	`Ctrl`+`Shift`+`End`	Extend selection to the last used cell
`F2`	`F2`	`F2`	Edit cell
`Home / End`	`Home / End`	`Home / End`	Go to the beginning / end of the cell
`Клавиши со стрелками`	`Pfeiltasten`	`Клавиши со стрелками`	Move one character left / right or one line up / down
`Ctrl`+`Стрелка влево / Стрелка вправо`	`Ctrl`+`Pfeil nach links / Pfeil nach rechts`	`Ctrl`+`Стрелка влево / Стрелка вправо`	Navigate one word left / right
`Shift`+`Home / End`	`Shift`+`Home / End`	`Shift`+`Home / End`	Select from the insertion point to the beginning / end of the cell
`Ctrl`+`Shift`+`Стрелка влево / Стрелка вправо`	`Ctrl`+`Shift`+`Pfeil nach links / Pfeil nach rechts`	`Ctrl`+`Shift`+`Стрелка влево / Стрелка вправо`	Select or deselect the selected word left / right
`Delete / Backspace`	`Delete / Backspace`	`Delete / Backspace`	Delete one character to the right / left of the cursor
`Alt`+`Enter`	`Option`+`Enter`	`Alt`+`Enter`	Start a new line within the cell
`Enter / Shift`+`Enter`	`Enter / Shift`+`Enter`	`Enter / Shift`+`Enter`	Finish input in the cell and move one cell down / up
`Tab / Shift`+`Tab`	`Tab / Shift`+`Tab`	`Tab / Shift`+`Tab`	Finish input in the cell and move one cell right / left
`Ctrl`+`Enter`	`Cmd`+`Enter`	`Ctrl`+`Enter`	Finish input in the cell and do not move selection
`Ctrl`+`;`	`Cmd`+`;`	`Ctrl`+`;`	Insert the current date at the cursor position
`Ctrl`+`Shift`+`;`	`Cmd`+`Shift`+`;`	`Ctrl`+`Shift`+`;`	Insert the current time at the cursor position

Selecting Columns and Rows

Windows	macOS	Linux	Action
`Shift`+`Пробел`	`Shift`+`Space`	`Shift`+`Space`	Select the current row
`Shift`+`Пробел , затем Shift`+`Стрелка вниз / Стрелка вверх`	`Shift`+`Space, then Shift`+`Arrow Down / Arrow Up`	`Shift`+`Пробел , затем Shift`+`Стрелка вниз / Стрелка вверх`	Select the current row, then extend selection by one row down / up
`Ctrl`+`Пробел`	`Ctrl`+`Space`	`Ctrl`+`Space`	Select the current column
`Shift`+`Пробел , затем Shift`+`Стрелка вправо / Стрелка влево`	`Shift`+`Space, then Shift`+`Arrow Right / Arrow Left`	`Shift`+`Пробел , затем Shift`+`Стрелка вправо / Стрелка влево`	Select the current column, then extend selection by one column right / left

Editing Rows, Columns, and Cells

Windows	macOS	Linux	Action
`Shift`+`Пробел , затем Ctrl`+`-`	`Shift`+`Space, then Ctrl`+`-`	`Shift`+`Пробел , затем Ctrl`+`-`	Select one row; then delete
`Shift`+`Пробел , Shift`+`Стрелка вверх / Стрелка вниз , затем Ctrl`+`-`	`Shift`+`Space, Shift`+`Arrow Up / Arrow Down, then Ctrl`+`-`	`Shift`+`Пробел , Shift`+`Стрелка вверх / Стрелка вниз , затем Ctrl`+`-`	Select multiple rows; then delete
`Shift`+`Пробел , Ctrl`+`Shift`++	`Shift`+`Space, Ctrl`+`Shift`++	`Shift`+`Пробел , Ctrl`+`Shift`++	Select one row; then insert one row above
`Shift`+`Пробел , затем Ctrl`+`-`	`Shift`+`Space, then Ctrl`+`-`	`Shift`+`Пробел , затем Ctrl`+`-`	Select one (or more) columns; then delete
`Ctrl`+`Shift`++`со строками в буфере обмена и выделенной строкой`	`Ctrl`+`Shift`++`with rows in clipboard and selected row`	`Ctrl`+`Shift`++`со строками в буфере обмена и выделенной строкой`	Insert rows from the clipboard and shift existing content down
`Ctrl`+`Shift`++`со столбцом (столбцами) в буфере обмена и выбранным столбцом`	`Ctrl`+`Shift`++`with column(s) in clipboard and selected column`	`Ctrl`+`Shift`++`со столбцом (столбцами) в буфере обмена и выбранным столбцом`	Insert columns from the clipboard and shift existing content right
`Shift`+`Стрелка вниз , F2 , затем Ctrl`+`Enter`	`Shift`+`Arrow Down, F2, then Ctrl`+`Enter`	`Shift`+`Стрелка вниз , F2 , затем Ctrl`+`Enter`	Fill the content of one cell to all cells selected with Shift + Arrow Down

Cut, Copy, Paste

Windows	macOS	Linux	Action
`Ctrl`+`X`	`Cmd`+`X`	`Ctrl`+`X`	Cut the cell and paste it to the clipboard
`Ctrl`+`C`	`Cmd`+`C`	`Ctrl`+`C`	Copy cells to the clipboard
`Ctrl`+`V`	`Cmd`+`V`	`Ctrl`+`V`	Paste cells from the clipboard
`Ctrl`+`Alt`+`V`	`Cmd`+`Alt`+`V`	`Ctrl`+`Alt`+`V`	Open the Paste Special menu

Number Formats

Windows	macOS	Linux	Action
`Ctrl`+`Shift`+`~`	`Cmd`+`Shift`+`~`	`Ctrl`+`Shift`+`~`	Apply the General number format
`Ctrl`+`Shift`+`1`	`Cmd`+`Shift`+`1`	`Ctrl`+`Shift`+`1`	Apply the Number format with two decimal places
`Ctrl`+`Shift`+`2`	`Cmd`+`Shift`+`2`	`Ctrl`+`Shift`+`2`	Apply the Time format with hours and minutes
`Ctrl`+`Shift`+`3`	`Cmd`+`Shift`+`3`	`Ctrl`+`Shift`+`3`	Apply the Date format with day, month, and year
`Ctrl`+`Shift`+`4`	`Cmd`+`Shift`+`4`	`Ctrl`+`Shift`+`4`	Apply the Currency format with two decimal places
`Ctrl`+`Shift`+`5`	`Cmd`+`Shift`+`5`	`Ctrl`+`Shift`+`5`	Apply the Percentage format without decimal places
`Ctrl`+`Shift`+`6`	`Cmd`+`Shift`+`6`	`Ctrl`+`Shift`+`6`	Apply the Number format

Alignment

Windows	macOS	Linux	Action
`Alt`+`H, AL`	`Option`+`H, A, L`	`Alt`+`H, A, L`	Align Left
`Alt`+`H, AR`	`Option`+`H, A, R`	`Alt`+`H, A, R`	Align Right
`Alt`+`H, AC`	`Option`+`H, A, C`	`Alt`+`H, A, C`	Align Center
`Alt`+`H, AT`	`Option`+`H, A, T`	`Alt`+`H, A, T`	Align Top
`Alt`+`H, AM`	`Option`+`H, A, M`	`Alt`+`H, A, M`	Align Middle
`Alt`+`H, AB`	`Option`+`H, A, B`	`Alt`+`H, A, B`	Align Bottom

Formulas

Windows	macOS	Linux	Action
`Знак равно`	`Gleichheitszeichen`	`Знак равно`	Start a formula
`Alt`+`=`	`Option`+`=`	`Alt`+`=`	Insert AutoSum formula
`Ctrl`+`Shift`+`U`	`Cmd`+`Shift`+`U`	`Ctrl`+`Shift`+`U`	Expand / collapse the formula bar
`Shift`+`F3 с пустой ячейкой`	`Shift`+`F3 mit leerer Zelle`	`Shift`+`F3 с пустой ячейкой`	Expand Insert Function
`Shift`+`F3 с формулой`	`Shift`+`F3 mit Formel`	`Shift`+`F3 с формулой`	Edit formula arguments at the cursor position
`Ctrl`+`~`	`Cmd`+`~`	`Ctrl`+`~`	Show / hide all formulas
`Ctrl`+`'`	`Cmd`+`'`	`Ctrl`+`'`	Duplicate formula from the cell above
`F3`	`F3`	`F3`	Insert named range into formula
`Ctrl`+`]`	`Cmd`+`]`	`Ctrl`+`]`	Select direct dependents
`Ctrl`+`Shift`+`]`	`Cmd`+`Shift`+`]`	`Ctrl`+`Shift`+`]`	Select all dependents
`F9`	`F9`	`F9`	Calculate all worksheets in all open workbooks
`Shift`+`F9`	`Shift`+`F9`	`Shift`+`F9`	Calculate active sheet
`Ctrl`+`Alt`+`F9`	`Cmd`+`Alt`+`F9`	`Ctrl`+`Alt`+`F9`	Calculate all worksheets in all open workbooks

Print

Windows	macOS	Linux	Action
`Ctrl`+`P`	`Cmd`+`P`	`Ctrl`+`P`	Print
`Alt`+`F , P`	`Option`+`F , P`	`Alt`+`F , P`	Open file when printing
`V в меню печати`	`V im Druckmenü`	`V в меню печати`	Focus in Print Preview
`G в меню печати`	`G im Druckmenü`	`G в меню печати`	Page Setup

Sheet Tab Management

Windows	macOS	Linux	Action
`Ctrl`+`Page Down / Page Up`	`⌘`+`Page Down / Page Up`	`Ctrl`+`Page Down / Page Up`	Go to the next / previous sheet in the current workbook
`Alt`+`H, I, S`	`⌘`+`Shift`+`K`	`Alt`+`H, I, S`	Insert a sheet
`Alt`+`H, D, S`	`⌘`+`Shift`+`Delete`	`Alt`+`H, D, S`	Delete a sheet
`Alt`+`H, O, R`	`⌘`+`Shift`+`R`	`Alt`+`H, O, R`	Rename a sheet
`Alt`+`H, M`	`⌘`+`Shift`+`M`	`Alt`+`H, M`	Move a sheet

Selecting Multiple Cells

Windows	macOS	Linux	Action
`Tab / Shift`+`Tab`	`Tab / Shift`+`Tab`	`Tab / Shift`+`Tab`	Move the active cell right / left in selection
`Enter / Shift`+`Enter`	`Enter / Shift`+`Enter`	`Enter / Shift`+`Enter`	Move the active cell down / up in selection
`Shift`+`Backspace`	`Shift`+`Backspace`	`Shift`+`Backspace`	Select only the active cell when multiple cells are selected
`Ctrl`+`Backspace`	`Ctrl`+`Backspace`	`Ctrl`+`Backspace`	Show the active cell in selection
`Arrow Keys with active selection`	`Arrow Keys with active selection`	`Arrow Keys with active selection`	Cancel selection

Data Forms

Windows	macOS	Linux	Action
`Tab / Shift`+`Tab`	`Tab / Shift`+`Tab`	`Tab / Shift`+`Tab`	Go to the next / previous editable field
`Enter / Shift`+`Enter`	`Enter / Shift`+`Enter`	`Enter / Shift`+`Enter`	Go to the first field in the next / previous record
`Scroll Down / Scroll Up`	`Scroll Down / Scroll Up`	`Scroll Down / Scroll Up`	Move to the same field 10 records forward / backward
`Ctrl`+`Scroll Down`	`Ctrl`+`Scroll Down`	`Ctrl`+`Scroll Down`	Go to the last record
`Ctrl`+`Scroll Up`	`Ctrl`+`Scroll Up`	`Ctrl`+`Scroll Up`	Go to the first record
`Home / End`	`Home / End`	`Home / End`	Go to the beginning / end of the field

Shortcuts Microsoft Excel for Windows

Popular

Document Navigation

Selecting and Editing Cell Content

Selecting Columns and Rows

Editing Rows, Columns, and Cells

Cut, Copy, Paste

Number Formats

Alignment

Formulas

Print

Sheet Tab Management

Selecting Multiple Cells

Data Forms

Related Programs

Import Shortcuts from JSON

Проверка, доработка и перевод (AI)

Report an Error