Programs

Shortcuts Microsoft Excel for Windows

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.

Navigate Worksheets

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)

Navigate Multi-Cell Selections

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

Comments and Hyperlinks

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: 1333

*Some of the keys listed may not work in older versions of the program