Shortcuts Microsoft Excel for Windows

Hot keys for Microsoft Excel for Windows allow you to work with a document faster, open or close sheets or files, perform frequently repeated operations on cells, perform calculations and much more. Users note that using combinations allows you to simplify work and increase productivity by 15%. Microsoft Excel is a rather complicated program, often used for data management or bookkeeping. Shortcuts in this case will not be distracted by routine actions, but focus on formulas and numbers. We offer a convenient table in which all shortcuts are divided into categories. Navigation for quick search is also available on the right.
Windows Description Edit Cancel Save & submit
Arrow Keys Navigate by one cell at a time in any direction
Page Down/Page Up Move one screen down/ up
Alt+Page Down/Page Up Move one screen right/ left
Tab/Shift+Tab Move one cell to the right/ to the left in a worksheet
Ctrl+Arrow Keys Move to the edge of next data region (cells that contains data)
Home Move to the beginning of row
Ctrl+Home Move to the beginning of worksheet
Ctrl+End Move to the last cell with content of worksheet
Ctrl+G Display the GoTo dialog box
Ctrl+G then type e.g. A50 Go to line 50, Column A
Ctrl+G then type e.g. G1 Go to column G, Line 1

Windows Description Edit Cancel Save & submit
Tab/Shift+Tab Move to the next/ previous field which can be edited
Enter/Shift+Enter Move to the first field in the next/ previous record
Page Down/Page Up Move to the same field 10 records forward/ back
Ctrl+Page Down Move to a new record
Ctrl+Page Up Move to the first record
Home/End Move to the beginning/ end of a field

Juggle Rows, Columns, and Cells

Windows Description Edit Cancel Save & submit
Shift+Space, then Ctrl+- Select single row; then delete
Shift+Space, Shift+Arrow Up/Arrow Down, then Ctrl+- Select multiple rows; then delete
Shift+Space, Ctrl+Shift++ Select single row; then insert one row above
Shift+Space, Shift+Arrow Up/Arrow Down, then Ctrl+Shift++ Select multiple rows; then insert the same number rows below
Shift+Space, then Ctrl+- Select single (or multiple) columns, then delete
Shift+Space, then Ctrl+Shift++ Select single row, then insert row below. Select multiple rows to insert multiple rows
Ctrl+Shift++ with row(s) in clipboard and a row selected Paste Insert - paste row(s) from clipboard and shift existing content downward
Ctrl+Shift++ with column(s) in clipboard and column selected Paste Insert - paste column(s) from clipboard and shift existing content to the right
Ctrl+Shift++ With cells that are not complete rows/columns - Open insert cell/ row/ column menu
Ctrl+- With cells that are not complete rows/columns - Open delete cell/ row/ column menu
Shift+Arrow Down, F2, then Ctrl+Enter Fill single cell content down to all cells selected with Shift+Arrow Down
Shift+Arrow Up, F2, then Ctrl+Enter Fill single cell content upto all cells selected with Shift+Arrow Down

Edit Cell Content

Windows Description Edit Cancel Save & submit
These assume you are inside a cell. F2
Edit cell. Press Escape to cancel Home/End
Jump to beginning/ end of cell Arrow Keys
Navigate by one character left/ right or one line up/ down Ctrl+Arrow Left/ Arrow Right
Navigate by one word left/ right Shift+Arrow Keys
Select one character to the left/ right (or one line up/down) Shift+ Home/End
Select from the insertion point to beginning/ end of cell Ctrl+Shift+Arrow Left/Arrow Right
Select or unselect one word to the left/ right Delete/Backspace
Delete one character to the right/ left of cursor Ctrl+Delete
Delete from cursor to end of cell Alt+Enter
Start a new line inside cell Enter/Shift+Enter
Complete cell entry and move one cell down/ up Tab/Shift+Tab
Complete cell entry and move one cell right/ left Ctrl+Enter
Complete cell entry and don't move selection Ctrl+'
Duplicate value from Cell above into current cell at cursor position Ctrl+;
Insert current date at cursor position Ctrl+Shift+;
Insert current time at cursor position

Duplicate Cells, Rows, and Columns

Windows Description Edit Cancel Save & submit
Ctrl+D Fill Down from cell(s) above into current cell(s)
Ctrl+D with a row selected Duplicate row via fill down - Fill current row with content from row above.
Ctrl+D with multiple empty cells selected Duplicate content of first cell(s) in first row to all cells in selection downward.
Ctrl+R Fill Rright from cell(s) on the left into current cell(s)
Ctrl+R with a column selected Duplicate column via fill right - Fill current column with content from column on the left.
Ctrl+D with multiple empty cells selected Duplicate content first cell(s) in first column to all cells in selection to the right.
Ctrl+' Duplicate formula from cell above

Undo, Redo, and Repeat Action

Windows Description Edit Cancel Save & submit
With Excel 2016 'redo' (undo an undo) and 'repeat' (repeat last action) became a bit confus. Ctrl+Y is a repeat if no undo is present. Ctrl+Z
Undo Ctrl+Y
Redo (after undo) or Repeat (e.g. when applying formats) Alt+2
Undo list (via quick access). Use Arrow Down to extend undo range. Alt+3
Redo list (via quick access). Use Arrow Down to extend redo range. Alt+Enter outside edit cell mode
Repeat last action. E.g. try to set a cell bold with Ctrl+B, then go to a different cell and press Alt+Enter; great to cascade formatting across multiple cells

Cut, Copy, Paste, and Paste Special

Windows Description Edit Cancel Save & submit
Ctrl+X Cut cell(s) to clipoard
Ctrl+C Copy cell(s) to clipboard
Ctrl+V Paste cell(s) from clipboard
Ctrl++ Insert Paste - Paste cell and push content downward or rightward. Works great for entire rows and columns.
Ctrl+Alt+V Open Paste Special Menu (requires a prior copy to Clipboard)
Ctrl+Alt+V, then V, Enter Paste Values
Ctrl+Alt+V, then T, Enter Paste Formats
Ctrl+Alt+V, then E, Enter Paste Transposed
Ctrl+Alt+V, then W, Enter Paste Column Width
Ctrl+Alt+V, then U, Enter Paste Values and Number Formats
F3 Paste a defined name into a formula

Find and Replace

Windows Description Edit Cancel Save & submit
Ctrl+F Display the Find and Replace dialog box (with find selected)
Ctrl+H Display the find and replace dialog box (with replace selected)
Escape Close the find and replace dialog Box (with focus on dialog box)
Shift+F4 Find bext (with search box closed)
Ctrl+Shift+F4 Find previous (with search box closed)
Alt+Tab, or Ctrl+F/H when losing focus Toggle focus between find/ replace dialog box and worksheet
Alt+F Find next with find dialog box active
Alt+I Find all with find dialog box active
* in search option Use as asterix for searching multiple characters
? in search options Use as wildcard for searching any single character, Use '~' before '?' when searching special characters. ~* searches for * ~~ searches for ~ ~? searches for ?

Manage Worksheet Tabs

Windows Description Edit Cancel Save & submit
Ctrl+Page Down/Page Up Move to the next/ previous worksheet in current workbook
Alt+H, IS Insert worksheet (Home - Insert Sheet)
Alt+H, DS Delete worksheet Home - Delete Sheet
Alt+H, OR Rename worksheet (Home - Format - Rename worksheet)
Alt+H, OM Move worksheet (Home - Format - Move worksheet)
Alt+H, OT Worksheet tab color, continue with mouse or arrow keys (Home - Format - Tab color)

Freeze, Split, and Hide

Windows Description Edit Cancel Save & submit
Alt+W+FF View - Freeze or unfreeze; unfreeze works for any Freeze Setting
Alt+W+R View - Freeze first visible Row on screen
Alt+W+C View - Freeze first Column on screen
Ctrl+9 Hide selected rows
Ctrl+Shift+9 Unhide hidden rows within the selection
Ctrl+0 Hide selected columns
Shift+F10, then U Unhide selected columns (Ctrl+Shift+0 not working in Excel 2010, 2013, or 2016)
Alt+W S Split or unsplit Worksheet at current position

Auto Filter

Windows Description Edit Cancel Save & submit
Ctrl+Shift+L Turn Autofilter on or off. Select table as necessary but many times Excel figures out what you want.
Alt+Arrow Down On the field with column head, display the AutoFilter list for the current column. Press Escape to cancel
Arrow Down/Arrow Up and Sace Select the next/ previous item in the AutoFilter list
Alt+Arrow Up Close the AutoFilter list for the current column
Home/End Select the first item/ last item in the AutoFilter list

Column Width and Row Height

Windows Description Edit Cancel Save & submit
It takes only a little bit patience to get used to set row-height and column-width using the pixels instead of the mouse; but only after a short while getting used to the keyboard shortcuts, you won't go back. It can't get any easier to exactly double or triple the row height by working with the values given. Alt+HO
Home - Format Worksheet H (in Format Worksheet Menu)
Set row Height A
Autofit row height W
Set column Width I
Autofit column width (Based on current cell; mark column if you want to autfit column based on widest cell) D
Set Default width (for all columns that haven't been changed yet)
Windows Description Edit Cancel Save & submit
All these shortcuts assume multipe cells have been selected. Try with at least 2-3 columns and rows. Tab/Shift+Tab
Move active cell right/ left in selection Enter/Shift+Enter
Move active cell down/ up in selection Shift+Backspace
Select only the active cell when multiple cells are selected Ctrl+Backspace
Show active cell within selection; helps with large selections when active cell is off screen Ctrl+.
Move clockwise between the four courners of a selection Ctrl+Alt+Arrow Right/ Arrow Left
Move to the right/ to the left between non-adjacent selections (with multiple ranges selected) Arrow Keys with active Selection
Cancel Selection
Windows Description Edit Cancel Save & submit
Ctrl+K Insert or edit hyperlinK (for complete cell only)
Shift+F10, then R Remove one or multiple hyperlink(s)
Shift+F10, then 2x O, then Enter Open hyperlink (In the Excel 2016 Contextmenu, 'O' is double-assigned which require the extra keys)
Shift+F2 Insert/ edit a cell comment
1x Escape when in Comment, then Arrow Keys Move comment
2x Escape when in Comment Escape comment editing and return to cell
Ctrl+Shift+O Select all cells with comments
Shift+F10, then M Delete single comment (or multipe with multiple comments selected)

Pivot Tables

Windows Description Edit Cancel Save & submit
Creating Pivot Tables with Shortcuts only seems to be nearly impossible; managing existing tables is doable. Alt+NV
Insert PivotTable after selecting data range. Follow up with Alt+E for existing worksheet if desired, Tab, and type the cell reference where it should go (e.g. C1) F10+R
Refresh PivotTable Ctrl+-
Hide selected item Alt+Arrow Down in header
Unhide item(s) by opening header drop-down and using Arrow Keys and Space to unhide item Type over any field with the value hidden
Unhide item(s) (assume you have two fields 'color', and 'size' and you hid 'color'. Go into 'size' field and type 'color' - this will unhide the 'color' field Type over any field with another field in same table
Flip current field value with the value typed Ctrl+Shift+*
Select the entire PivotTable report Alt+Shift+Arrow Right
Group selected PivotTable items Alt+Shift+Arrow Left
Ungroup selected PivotTable items when on group header ALT+JTX
Exand all fields ALT+JTP
Collapse all fields Ctrl+Shift++
Insert pivot formula/ calculated field Alt+F1
Create Pivot Chart in same Worksheet F1
Create Pivot Chart in new Worksheet

Group Rows and Columns

Windows Description Edit Cancel Save & submit
Alt+Shift+Arrow Right Group rows or columns
Alt+Shift+Arrow Left Ungroup rows or columns
Alt+AH Data Hide detail
Alt+AJ Data Show Detail (j is next to h on keyboard that’s probably why they picked 'J' isntead of somthing else)
Ctrl+8 Display or hides the outline symbols
Alt+ASCII Code Enter ASCII code, e.g. Alt+0169 inserts © Symbol

The Rest

Windows Description Edit Cancel Save & submit
Ctrl+F1 Minimize/ restore Excel ribbons
Ctrl after selecting at least 2 rows and 2 columns Display format, chart, totals, tables, and sparklines menus
Shift+F7 Display the thesaurus dialog box
F7 Display the spelling dialog box
Alt+F, IE
Alt+F4 Close Excel
F1 Help
Alt+' Style dialog box
Ctrl+F3 Define a name or dialog
Ctrl+Shift+F3 Create names from row and column labels
Alt+F1 Create and insert chart with data in current range as embedded Chart Object
F11 Create and insert chart with data in current range in a separate Chart Sheet
Alt+F11 Open VBA editor window
Ctrl+F6 Scroll between open workbooks
Alt+F8 Display macro dialog box
~~~ The end. Thank you for watching. Add page to bookmarks CTRL + D ~~~
Date of change: 18.02.2019
Page views: 238
*Some of the keys listed may not work in older versions of the program