Microsoft Excel 2013 (Windows)

Format Cells

Merge Cells - Unmerge

Alt + H , M U

All hotkeys for Microsoft Excel 2013 (Windows)

Navigate Worksheets
Move one cell up, down, left, or right in a worksheet

Arrow Keys

Navigate Worksheets
Move one screen down / one screen up in a worksheet

Page Down / Page Up

Navigate Worksheets
Move one screen to the right / to the left in a worksheet

Alt + Page Down / Alt + Page Up

Navigate Worksheets
Move one cell to the right / to the left in a worksheet

Tab / Shift + Tab

Navigate Worksheets
Move to the edge of next data region (cells that contains data)

Ctrl + Arrow Keys

Navigate Worksheets
Move to the beginning of a row in a worksheet

Home

Navigate Worksheets
Move to the beginning of a worksheet

Ctrl + Home

Navigate Worksheets
Move to the last cell with content on a worksheet

Ctrl + End

Navigate Worksheets
Display the Find and Replace dialog box (with Find selected)

Ctrl + F

Navigate Worksheets
Display the Find and Replace dialog box (with Replace selected)

Ctrl + H

Navigate Worksheets
Repeat last find

Shift + F4

Navigate Worksheets
Display the 'Go To' dialog box

Ctrl + G (or F5 )

Navigate Worksheets
Inside a cell: Move one word to the left / to the right

Ctrl + Arrow Left / Ctrl + Arrow Right

Navigate Worksheets
Inside a cell: Move to the beginning / to the end of a cell entry

Home / End

Navigate Worksheets
Display the AutoComplete list eg in cell with dropdowns or autofilter

Alt + Arrow Down

Navigate Worksheets
Turn 'End' mode on In End mode, press arrow keys to move to the next nonblank cell in the same column or row as the active cell From here use arrow keys to move by blocks of data, home to move to last cell, or enter to move to the last cell to the right

End

Basic and Advanced Cell Selections
Select the entire row

Shift + Space

Basic and Advanced Cell Selections
Select the entire column

Ctrl + Space

Basic and Advanced Cell Selections
Extend the selection by one cell

Shift + Arrow Keys

Basic and Advanced Cell Selections
Extend the selection down one screen /up one screen

Shift + Page Down / Shift + Page Up

Basic and Advanced Cell Selections
Extend the selection to the beginning of the row There is no Shift+End equivalent

Shift + Home

Basic and Advanced Cell Selections
Extend the selection to the last cell with content in row or column

Ctrl + Shift + Arrow Key

Basic and Advanced Cell Selections
Select the entire worksheet or the data-containing area Pressing ctrl+a a second time then selects entire worksheet

Ctrl + A (or ctrl + Shift + Spacebar , or Ctrl + Shift + * )

Basic and Advanced Cell Selections
Extend the selection to the first cell of the worksheet

Ctrl + Shift + Home

Basic and Advanced Cell Selections
Extend the selection to the last used cell on the worksheet (lower-right corner)

Ctrl + Shift + End

Basic and Advanced Cell Selections
F5, then eg type d:g selects columns D-G, or 1:5 selects rows 1-5 etc

F5 + column or row reference

Basic and Advanced Cell Selections
Edit Cell

F2

Basic and Advanced Cell Selections
Inside a cell: Select from the insertion point to the beginning / to the end of the cell

Shift + Home / End

Basic and Advanced Cell Selections
Inside a cell: Select or unselect one character to the left / to the right

Shift + Arrow Left / Arrow Right

Basic and Advanced Cell Selections
Inside a cell: Select or unselect one word to the left / to the right

Ctrl + Shift + Arrow Left / Arrow Right

Navigate Inside Selected Text Blocks
Move active cell right / left in a selection

Tab / Shift + Tab

Navigate Inside Selected Text Blocks
Lock Selection which allows to add another (adjacent or non-adjacent) range of cells to the selection Use arrow keys and shift+arrow keys to add to selection

Shift + F8

Navigate Inside Selected Text Blocks
Turn on extension of selection with arrow keys without having to keep pressing shift

F8

Navigate Inside Selected Text Blocks
Move active cell down / up in a selection

Enter / Shift + Enter

Navigate Inside Selected Text Blocks
Select only the active cell when multiple cells are selected

Shift + Backspace

Navigate Inside Selected Text Blocks
Show active cell within selection

Ctrl + Backspace

Navigate Inside Selected Text Blocks
Move clockwise to the next corner of the selection

Ctrl + . (period)

Navigate Inside Selected Text Blocks
Move to the right / to the left between non-adjacent selections (with multiple ranges selected)

Ctrl + Alt + Arrow Right / Ctrl + Alt + Arrow Left

Navigate Inside Selected Text Blocks
Cancel Selection

Esc

Edit Complete Cells
Fill Down Select cells with value in first row Ctrl+D fills the value of that first cell in selection to all cells in selection downwards

Ctrl + D

Edit Complete Cells
Fill Right: Select cell with value in first cell Ctrl+E fills value of that first cell in selection to all cells rightwards

Ctrl + R

Edit Complete Cells
Delete Cell/Row/Column Menu

Ctrl + -

Edit Complete Cells
Delete row / delete column

Ctrl + - with row / column selected

Edit Complete Cells
Insert Cell/Row/Column Menu

Ctrl + Shift + +

Edit Complete Cells
Insert row/ insert column

Ctrl + Shift + + with row / column selected

Edit Complete Cells
Insert / Edit a cell comment

Shift + F2

Edit Complete Cells
Delete comment

Shift + F10 , then M

Edit Complete Cells
Insert a HyperlinK (for complete cell only)

Ctrl + K

Edit Complete Cells
Hide the selected rows

Ctrl + 9

Edit Complete Cells
Unhide any hidden rows within the selection

Ctrl + Shift + 9

Edit Complete Cells
Hide the selected columns Since Excel 2010, there is no more shortcut to unhide columns

Ctrl + 0 (zero)

Edit Complete Cells
Alternate between displaying cell values and displaying cell formulas This is Accent Grave on top left of keyboard, not a quotation mark

Ctrl + ` (Accent Grave)

Edit Content of Cells
Edit the active cell with cursor at end of the line

F2

Edit Content of Cells
Start a new line in the same cell

Alt + Enter

Edit Content of Cells
Complete a cell entry and move down in the selection With multiple cells selected: fill cell range with current cell

Enter

Edit Content of Cells
Complete a cell entry and move up in the selection

Shift + Enter

Edit Content of Cells
Complete a cell entry and move to the right / to the left in the selection

Tab / Shift + Tab

Edit Content of Cells
Cancel a cell entry

Esc

Edit Content of Cells
Delete the character to the left of the insertion point, or delete the selection

Backspace

Edit Content of Cells
Delete the character to the right of the insertion point, or delete the selection

Delete

Edit Content of Cells
Delete text to the end of the line

Ctrl + Delete

Edit Content of Cells
Insert current date

Ctrl + ; (semicolon)

Edit Content of Cells
Insert current time

Ctrl + Shift + : (colon)

Edit Content of Cells
Duplicate value from Cell above into current Cell

Ctrl + '

Excel Basics
Display the shortcut menu for the selected command (simulates right mouse button)

Shift + F10

Excel Basics
Undo last action (multiple levels)

Ctrl + Z

Excel Basics
Redo last action (multiple levels)

Ctrl + Y

Excel Basics
Copy contents of selected cells

Ctrl + C

Excel Basics
Cut contents of selected cells

Ctrl + X

Excel Basics
Paste content from clipboard into selected cell

Ctrl + V

Excel Basics
If data exists in clipboard: Display the Paste Special dialog box

Ctrl + Alt + v

Format Cells
Open Format Cells dialog with last selection active

Ctrl + 1

Format Cells
Open Format Cells dialog with Font Tab active

Ctrl + Shift + F

Format Cells
Apply or remove bold formatting

Ctrl + B

Format Cells
Apply or remove italic formatting

Ctrl + I

Format Cells
Apply or remove an underline

Ctrl + U

Format Cells
Apply or remove strikethrough formatting

Ctrl + 5

Format Cells
Apply the General number format

Ctrl + Shift + ~

Format Cells
Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values

Ctrl + Shift + 1

Format Cells
Apply the Time format with the hour and minute, and indicate AM or PM

Ctrl + Shift + 2

Format Cells
Apply the Date format with the day, month, and year

Ctrl + Shift + 3

Format Cells
Apply the Currency format with two decimal places

Ctrl + Shift + 4

Format Cells
Apply the Percentage format with no decimal places

Ctrl + Shift + 5

Format Cells
Apply the Scientific number format with two decimal places

Ctrl + Shift + 6

Format Cells
Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell

F4

Format Cells
Align Left

Alt + H , A L

Format Cells
Align Right

Alt + H , A R

Format Cells
Align Cight

Alt + H - A C

Format Cells
Align Top

Alt + H , A T

Format Cells
Align Middle

Alt + H , A M

Format Cells
Align Bottom

Alt + H - A B

Format Cells
Wrap or unwrap text (Home - Wrap Text)

Alt + H , W

Format Cells
Highlight Cell (change cell backgroudn color)

Alt + H , H

Format Cells
Font Color

Alt + H , F C

Format Cells
Font Size

Alt + H , F S

Format Cells
Merge Cells - Merge

Alt + H , M M

Format Cells
Merge Cells - Unmerge

Alt + H , M U

Format Cells
Merge Cells - Merge and Center

Alt + H , M C

Format Cells
Merge Cells - Merge Across

Alt + H , M A

Apply Basic Borders to Cells
Apply outline border from cell or selection

Ctrl + Shift + 7

Apply Basic Borders to Cells
Remove outline borders from cell or selection

Ctrl + Shift + _ (underscore)

Apply Basic Borders to Cells
Bottom Border

Alt + H B , O

Apply Basic Borders to Cells
Top Border

Alt + H B , P

Apply Basic Borders to Cells
Right Border

Alt + H B , R

Apply Basic Borders to Cells
Left Border

Alt + H B , L

Apply Basic Borders to Cells
All Borders

Alt + H B , A

Apply Basic Borders to Cells
Outside Borders

Alt + H B , A

Apply Basic Borders to Cells
No Border

Alt + H B , N

Formulas
Start a formula

=

Formulas
Insert the AutoSum formula

Alt + =

Formulas
Display the Insert Function dialog box

Shift + F3

Formulas
Display Formula Window after typing formula name

Ctrl + A

Formulas
Insert Arguments in formula after typing formula name

Ctrl + Shift + A

Formulas
Insert a function into a formula

Shift + F3

Formulas
Enter a formula as an array formula

Ctrl + Shift + Enter

Formulas
After typing cell reference (eg =E4) makes reference absolute (=$E$4). Repeat if you want to toogle from absolute reference to parcial or complete removal ($E$4 -> E$4 -> $E4 -> returning to E4.

F4

Manage Multipe Worksheets
Move to the next / previous worksheet in current workbook

Ctrl + Page Down / Page Up

Manage Multipe Worksheets
Insert a new worksheet in current workbook

Shift + F11 / Alt + Shift + F1

Manage Multipe Worksheets
Select the current and previous sheet / and next sheet in a workbook

Ctrl + Shift + Page Up / Page Down

Manage Multipe Worksheets
Rename current worksheet (format, sheet, rename)

Alt + O then H R

Manage Multipe Worksheets
Delete current worksheet (Edit, delete)

Alt + E then L

Manage Multipe Worksheets
Move current worksheet (Edit, move)

Alt + E then M

Manage Multiple Workbooks
Move to the next pane / previous pane in a workbook that has been split

F6 / Shift + F6

Manage Multiple Workbooks
Close the selected workbook window

Ctrl + F4

Manage Multiple Workbooks
Create a new blank workbook (Excel File)

Ctrl + N

Manage Multiple Workbooks
Move to next / previous workbook window

Ctrl + Tab / Ctrl + Shift + Tab

Manage Multiple Workbooks
Display the Control menu for Main Excel window

Alt + Space

Manage Multiple Workbooks
Minimize current workbook window to an icon Also restores ('un-maximizes') all workbook windows

Ctrl + F9

Manage Multiple Workbooks
Maximize or restores the selected workbook window

Ctrl + F10

Manage Multiple Workbooks
Move Workbook Windows which are not maximized

Ctrl + F7

Manage Multiple Workbooks
Perform size command for workbook windows which are not maximzed

Ctrl + F8

Manage Multiple Workbooks
Close Excel

Alt + F4

Various Excel Features
Open File

Ctrl + O

Various Excel Features
Save the active file with its current file name, location, and file format

Ctrl + S

Various Excel Features
Display the Save As dialog box

F12

Various Excel Features
Turn key tips on or off

F10 (or alt )

Various Excel Features
Print File (Opens print menu)

Ctrl + P

Various Excel Features
Display the Excel Help task pane

F1

Various Excel Features
Display the Spelling dialog box

F7

Various Excel Features
Display the Thesaurus dialog box

Shift + F7

Various Excel Features
Display the Macro dialog box

Alt + F8

Various Excel Features
Open the Visual Basic Editor to create Macros

Alt + F11

Ribbon Shortcuts
Minimize or restore the Ribbons

Ctrl + F1

Ribbon Shortcuts
Activate the selected command or control in the Ribbon, Open the selected menu or gallery in the Ribbon

Space / Enter

Ribbon Shortcuts
Finish modifying a value in a control in the Ribbon, and move focus back to the document

Enter

Ribbon Shortcuts
Get help on the selected command or control in the Ribbon (If no Help topic is associated with the selected command, the Help table of contents for that program is shown instead)

F1

Pivot Tables
Navigate inside Pivot tables

Arrow Keys

Pivot Tables
Select the first / last visible item in the list

Home / End

Pivot Tables
Move the selected field into the Column area

Alt + C

Pivot Tables
Move the selected field into the Data area

Alt + D

Pivot Tables
Display the PivotTable Field dialog box

Alt + L

Pivot Tables
Move the selected field into the Page area

Alt + P

Pivot Tables
Move the selected field into the Row area

Alt + R

Pivot Tables
Select the entire PivotTable report

Ctrl + Shift + *

Pivot Tables
Display the selected item

Enter

Pivot Tables
Select or clear a check box in the list

Space

Pivot Tables
Select the PivotTable toolbar

Ctrl + Tab / Ctrl + Shift + Tab

Pivot Tables
On a field button: select the area you want to move the selected field to

Enter then Arrow Down / Arrow Up

Pivot Tables
Group selected PivotTable items

Alt + Shift + Arrow Right

Pivot Tables
Ungroup selected PivotTable items

Alt + Shift + Arrow Left

Dialog Boxes
Move between options in the active drop-down list box or between some options in a group of options

Arrow Keys

Dialog Boxes
Switch to the next/ previous tab in dialog box

Ctrl + Tab / Ctrl + Shift + Tab

Dialog Boxes
In a dialog box: perform the action for the selected button, or select/clear a check box

Space

Dialog Boxes
Move to the next / previous option

Tab / Shift + Tab

Dialog Boxes
Move to an option in a drop-down list box starting with the letter

A ... Z

Dialog Boxes
Select an option, or select or clear a check box

Alt + A ... Alt + Z

Dialog Boxes
Open the selected drop-down list box

Alt + Arrow Down

Dialog Boxes
Perform the action assigned to the default command button in the dialog box

Enter

Dialog Boxes
Cancel the command and close the dialog box

Esc

Auto Filter
On the field with column head, display the AutoFilter list for the current column

Alt + Arrow Down

Auto Filter
Select the next item / previous item in the AutoFilter list

Arrow Down / Arrow Up

Auto Filter
Close the AutoFilter list for the current column

Alt + Arrow Up

Auto Filter
Select the first item / last item in the AutoFilter list

Home / End

Auto Filter
Filter the list by using the selected item in the AutoFilter list

Enter

Auto Filter
Apply filter on selected column headings

Ctrl + Shift + L

Data Forms
Move to the next / previous field which can be edited

Tab / Shift + Tab

Data Forms
Move to the first field in the next / previous record

Enter / Shift + Enter

Data Forms
Move to the same field 10 records forward / back

Page Down / Page Up

Data Forms
Move to a new record

Ctrl + Page Down

Data Forms
Move to the first record

Ctrl + Page Up

Data Forms
Move to the beginning / end of a field

Home / End

Adjust Column Width and Row Height
Format - Autoheight Row

Alt + H O , A

Adjust Column Width and Row Height
Format - Autowidth Column

Alt + H O , I

Lesser Used Shortcuts
Select all cells with comments

Ctrl + Shift + O

Lesser Used Shortcuts
Group rows or columns

Alt + Shift + Arrow Right

Lesser Used Shortcuts
Ungroup rows or columns

Alt + Shift + Arrow Left

Lesser Used Shortcuts
Alternate between hiding and displaying objects

Ctrl + 6

Lesser Used Shortcuts
Display or hides the outline symbols

Ctrl + 8

Lesser Used Shortcuts
Alternate between hiding objects, displaying objects, and displaying placeholders for objects

Ctrl + 6

Lesser Used Shortcuts
Display the Style dialog box

Alt + ' (apostrophe / single quote)

Lesser Used Shortcuts
If data exists in clipboard: Display the Insert dialog box to insert blank cells

Ctrl + Shift + [ + ]

Lesser Used Shortcuts
Calculate all worksheets in all open workbooks

F9

Lesser Used Shortcuts
Calculate the active worksheet

Shift + F9

Lesser Used Shortcuts
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation

Ctrl + Alt + F9

Lesser Used Shortcuts
Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated

Ctrl + Alt + Shift + F9

Lesser Used Shortcuts
Toggle expand or collapse formula bar

Ctrl + Shift + U

Lesser Used Shortcuts
Define a name or dialog

Ctrl + F3

Lesser Used Shortcuts
Create names from row and column labels

Ctrl + Shift + F3

Lesser Used Shortcuts
Paste a defined name into a formula

F3

Lesser Used Shortcuts
Insert a table (display Create Table dialog box)

Ctrl + T

Lesser Used Shortcuts
Create and insert chart with data in current range as embedded Chart Object

Alt + F1

Lesser Used Shortcuts
Create and insert chart with data in current range in a separate Chart sheet

F11

Similar combinations for other applications