Microsoft Excel 2016 (Windows)

Freeze, Split, and Hide

View - Freeze first Column on screen

`Alt` + `W` + `C`

All hotkeys for Microsoft Excel 2016 (Windows)

Select Cells - Basic Selects Extend selection by one cell	`Shift` + `Arrow Keys`
Select Cells - Basic Selects Extend selection one screen down/ up	`Shift` + `Page Down` / `Page Up`
Select Cells - Basic Selects Extend selection to next non-blank cell	`Ctrl` + `Shift` + `Arrow Keys`
Select Cells - Basic Selects Extend selection to beginning of the row (unfortunately, there is no Shift+End equivalent)	`Shift` + `Home`
Select Cells - Basic Selects Select all	`Ctrl` + `A` with no data nearby current cell
Select Cells - Basic Selects Select all cells in data-containing area. Press twice to select everything	`Ctrl` + `A` with data nearby current cell
Select Cells - Basic Selects Extend selection to first cell of the worksheet	`Ctrl` + `Shift` + `Home`
Select Cells - Basic Selects Extend selection to last used cell on the worksheet (lower-right corner)	`Ctrl` + `Shift` + `End`
Select Cells - Basic Selects Lock Selection Extend Mode - Select Cell Range, press Shift+F8, move around, add to selection with Shift+Arrow Keys, etc	`Shift` + `F8`
Select Cells - Basic Selects Manual selection by row/ column via GoTo menu. A:B selects column A thru C, 1:3 selects row 1 thru 3 , A1:B3 select cells A1 thru B3, etc	`Ctrl` + `G`
Select Cells - Column and Row Selection Select current row	`Shift` + `Space`
Select Cells - Column and Row Selection Select current row, then expand selection by one row down/ up	`Shift` + `Space` , then `Shift` + `Arrow Down` / `Arrow Up`
Select Cells - Column and Row Selection Select current row, then expand selection by one page down/ up	`Shift` + `Space` , then `Shift` + `Page Down` / `Page Up`
Select Cells - Column and Row Selection Select current column	`Ctrl` + `Space`
Select Cells - Column and Row Selection Select current column, then expand selection by one column right/ left	`Shift` + `Space` , then `Shift` + `Arrow Right` / `Arrow Left`
Select Cells - Column and Row Selection Select current column, then expand selection by one screen right/ left	`Shift` + `Space` , then `Shift` + `Alt` + `Page Down` / `Page Up`
Select Cells - General Cell Format Copy a cell via Ctrl+C, then via Paste Spacieal, paste format of that cell to current cell	`Ctrl` + `Alt` + `V` , then `T` and `Enter`
Select Cells - General Cell Format Repeat a previous cell format action on current cell	`Alt` + `Enter`
Select Cells - General Cell Format Open Format Cells dialog with last selection active	`Ctrl` + `1`
Select Cells - General Cell Format Open Format Cells dialog with Font Tab active	`Ctrl` + `Shift` + `F`
Select Cells - Font Face, Font Decoration, and Cell Color Apply/ remove bold format	`Ctrl` + `B`
Select Cells - Font Face, Font Decoration, and Cell Color Apply/ remove italic format	`Ctrl` + `I`
Select Cells - Font Face, Font Decoration, and Cell Color Apply/ remove underline format	`Ctrl` + `U`
Select Cells - Font Face, Font Decoration, and Cell Color Apply/ remove strikethrough formatting	`Ctrl` + `5`
Select Cells - Font Face, Font Decoration, and Cell Color Home select Font Face; type font name supported by auto-complete, or use Arrow Down to select.	`Alt` + `H` , `FF`
Select Cells - Font Face, Font Decoration, and Cell Color Home select Font Size; use Arrow Key, then Enter to change size	`Alt` + `H` , `FS`
Select Cells - Font Face, Font Decoration, and Cell Color Assign current font color to selection via Home Font Color. While escaping the font-color drop-down, the focus stays on the icon; simply press Enter to assign the current color.	`Alt` + `H` , `FC` , `Escape` , `Enter`
Select Cells - Font Face, Font Decoration, and Cell Color Assign current fill color to selected cell color via Home Higlight Cell. While escaping the highlight drop-down, the focus stays on the icon; simply press Enter to assign the current color.	`Alt` + `HH` , `Escape` , `Enter`
Select Cells - Font Face, Font Decoration, and Cell Color Set to No fill color	`Alt` + `HH` , then `N`
Select Cells - Number Formats Apply the general number format (e.g. 1000)	`Ctrl` + `Shift` + `~`
Select Cells - Number Formats Apply the number format with two decimal places, thousands separator (e.g. 1,000.00)	`Ctrl` + `Shift` + `1`
Select Cells - Number Formats Apply the time format with the hour and minute, and indicate AM or PM	`Ctrl` + `Shift` + `2`
Select Cells - Number Formats Apply the date format with the day, month, and year	`Ctrl` + `Shift` + `3`
Select Cells - Number Formats Apply the currency format with two decimal places (e.g. $1,000.00)	`Ctrl` + `Shift` + `4`
Select Cells - Number Formats Apply the percentage format with no decimal places (e.g. 10%)	`Ctrl` + `Shift` + `5`
Select Cells - Number Formats Apply the scientific number format	`Ctrl` + `Shift` + `6`
Select Cells - Alignments Align Left	`Alt` + `H` , `AL`
Select Cells - Alignments Align Right	`Alt` + `H` , `AR`
Select Cells - Alignments Align Center	`Alt` + `H` , `AC`
Select Cells - Alignments Align Top	`Alt` + `H` , `AT`
Select Cells - Alignments Align Middle	`Alt` + `H` , `AM`
Select Cells - Alignments Align Bottom	`Alt` + `H` , `AB`
Select Cells - Wrap and Merge Wrap or unwrap text (Home - Wrap Text)	`Alt` + `H` , `W`
Select Cells - Wrap and Merge Merge cells - Merge	`Alt` + `H` , `MM`
Select Cells - Wrap and Merge Merge - Unmerge	`Alt` + `H` , `MU`
Select Cells - Wrap and Merge Merge and Center	`Alt` + `H` , `MC`
Select Cells - Wrap and Merge Merge Across (merge all columns, but not rows in selection)	`Alt` + `H` , `MA`
Select Cells - Border Shortcuts Home - Border - Menu; technically it says 'more'.	`Alt` + `H` , `BM`
Select Cells - Border Shortcuts Toggle Top border	`Alt` + `T` (in border menu)
Select Cells - Border Shortcuts Toggle Bottom border	`Alt` + `B`
Select Cells - Border Shortcuts Toggle Right border	`Alt` + `R`
Select Cells - Border Shortcuts Toggle Left border	`Alt` + `L`
Select Cells - Border Shortcuts Toggle Horizontal interior border	`Alt` + `H`
Select Cells - Border Shortcuts Toggle Vertical interior border	`Alt` + `V`
Select Cells - Border Shortcuts Toggle Upwards diagonal border	`Alt` + `U`
Select Cells - Border Shortcuts Toggle Downwards diagonal border	`Alt` + `D`
Select Cells - Border Shortcuts Add outline borders from cell or selection	`Ctrl` + `Shift` + `&`
Select Cells - Border Shortcuts Remove outline borders from cell or selection	`Ctrl` + `Shift` + `-`
Select Cells - Basics Start a formula	`=`
Select Cells - Basics Insert the AutoSum formula	`Alt` + `=`
Select Cells - Basics Edit formula in formula Bar	`Ctrl` + `A` with formula present
Select Cells - Basics Expand/ collapse formula bar	`Ctrl` + `Shift` + `U`
Select Cells - Basics 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`
Select Cells - Basics Display the 'insert function; dialog box	`Shift` + `F3` with empty cell
Select Cells - Basics Edit arguments of formula at cursor position	`Shift` + `F3` with formula present
Select Cells - Basics Select all Formulas (Home - Find - Formulas	`Alt` + `H` , `FD` , `U`
Select Cells - Basics Enter a formula as an array formula. Formula bar will show this as e.g. {=SUM(A1:A3B1:B3)} whichis the sum of A1B2+A2*B2+A3+B3. This is an easy and concise method. Remember that each time editing the formula will require the Ctrl+Shift+Enter. Some keyboards seem to distinguish between left and right Shift key	`Ctrl` + `Shift` + `Enter` with array formula
Select Cells - Basics Show/ hide all formulas. This will automatically extend all column widths which reverses when presed again	`Ctrl` + `~`
Select Cells - Basics Duplicate formula from cell above	`Ctr` + `'`
Select Cells - Basics Paste named range in formula	`F3`
Select Cells - Basics When navigated away while editing formula; jump back to active cell while keeping formula intact.	`Ctrl` + `Backspace`
Select Cells - Trace Dependents and Precedents Select direct precedents	`Ctrl` + `[`
Select Cells - Trace Dependents and Precedents Select all precedents	`Ctrl` + `Shift` + `[`
Select Cells - Trace Dependents and Precedents Select direct dependents	`Ctrl` + `]`
Select Cells - Trace Dependents and Precedents Select all dependents	`Ctrl` + `Shift` + `]`
Select Cells - Manual Calculation Calculate all worksheets in all open workbooks	`F9`
Select Cells - Manual Calculation Calculate the active worksheet	`Shift` + `F9`
Select Cells - Manual Calculation Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation	`Ctrl` + `Alt` + `F9`
Select Cells - Manual Calculation 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`
Select Cells - Open and Save Workbooks Open file via standard open dialog box	`Ctrl` + `O`
Select Cells - Open and Save Workbooks File Open via Excel file manager	`Alt` + `F` , `O`
Select Cells - Open and Save Workbooks Open recent file (1 thru 9)	`Alt` + `F` , `O` + `1` ... `9`
Select Cells - Open and Save Workbooks Open recent file (10 upwards)	`Alt` + `F` , `O` , `Y` `1` ... `Z`
Select Cells - Open and Save Workbooks File Open from OneDrive Link	`Alt` + `F` , `O` , `K`
Select Cells - Open and Save Workbooks Save File with current file name	`Ctrl` + `S`
Select Cells - Open and Save Workbooks Save file as via standard save dialog box	`F12`
Select Cells - Open and Save Workbooks File Save as via Excel file manager	`Alt` + `F` , `A`
Select Cells - Open and Save Workbooks File Save to OneDrive Link	`Alt` + `F` , `A` , `K`
Select Cells - Open and Save Workbooks Exit open/ save menu	`Escape`
Select Cells - Print Workbooks Print. This won't offer offer Key Tips/ Options. To continue with shortcuts, use the new Key Options below.	`Ctrl` + `P`
Select Cells - Print Workbooks Open File Print menu	`Alt` + `F` , `P`
Select Cells - Print Workbooks Select printer	`I` in Print Menu
Select Cells - Print Workbooks Return Print key tips/ options	`Alt` + `P` if Key Tips disappear
Select Cells - Print Workbooks Focus on View pane; use arrow keys to forward/ backward preview pages	`V` in Print Menu
Select Cells - Print Workbooks Page setup	`G` in Print Menu
Select Cells - Print Workbooks Set Number of copies	`N` in Print Menu
Select Cells - Auto Tables Create auto Table from selection	`Ctrl` + `T`
Select Cells - Auto Tables Select table column	`Ctrl` + `Space`
Select Cells - Auto Tables Select table row	`Shift` + `Space`
Select Cells - Data Forms Move to the next/ previous field which can be edited	`Tab` / `Shift` + `Tab`
Select Cells - Data Forms Move to the first field in the next/ previous record	`Enter` / `Shift` + `Enter`
Select Cells - Data Forms Move to the same field 10 records forward/ back	`Page Down` / `Page Up`
Select Cells - Data Forms Move to a new record	`Ctrl` + `Page Down`
Select Cells - Data Forms Move to the first record	`Ctrl` + `Page Up`
Select Cells - Data Forms Move to the beginning/ end of a field	`Home` / `End`
Format Cells - Basic Selects Extend selection by one cell	`Shift` + `Arrow Keys`
Format Cells - Basic Selects Extend selection one screen down/ up	`Shift` + `Page Down` / `Page Up`
Format Cells - Basic Selects Extend selection to next non-blank cell	`Ctrl` + `Shift` + `Arrow Keys`
Format Cells - Basic Selects Extend selection to beginning of the row (unfortunately, there is no Shift+End equivalent)	`Shift` + `Home`
Format Cells - Basic Selects Select all	`Ctrl` + `A` with no data nearby current cell
Format Cells - Basic Selects Select all cells in data-containing area. Press twice to select everything	`Ctrl` + `A` with data nearby current cell
Format Cells - Basic Selects Extend selection to first cell of the worksheet	`Ctrl` + `Shift` + `Home`
Format Cells - Basic Selects Extend selection to last used cell on the worksheet (lower-right corner)	`Ctrl` + `Shift` + `End`
Format Cells - Basic Selects Lock Selection Extend Mode - Select Cell Range, press Shift+F8, move around, add to selection with Shift+Arrow Keys, etc	`Shift` + `F8`
Format Cells - Basic Selects Manual selection by row/ column via GoTo menu. A:B selects column A thru C, 1:3 selects row 1 thru 3 , A1:B3 select cells A1 thru B3, etc	`Ctrl` + `G`
Format Cells - Column and Row Selection Select current row	`Shift` + `Space`
Format Cells - Column and Row Selection Select current row, then expand selection by one row down/ up	`Shift` + `Space` , then `Shift` + `Arrow Down` / `Arrow Up`
Format Cells - Column and Row Selection Select current row, then expand selection by one page down/ up	`Shift` + `Space` , then `Shift` + `Page Down` / `Page Up`
Format Cells - Column and Row Selection Select current column	`Ctrl` + `Space`
Format Cells - Column and Row Selection Select current column, then expand selection by one column right/ left	`Shift` + `Space` , then `Shift` + `Arrow Right` / `Arrow Left`
Format Cells - Column and Row Selection Select current column, then expand selection by one screen right/ left	`Shift` + `Space` , then `Shift` + `Alt` + `Page Down` / `Page Up`
Format Cells - General Cell Format Copy a cell via Ctrl+C, then via Paste Spacieal, paste format of that cell to current cell	`Ctrl` + `Alt` + `V` , then `T` and `Enter`
Format Cells - General Cell Format Repeat a previous cell format action on current cell	`Alt` + `Enter`
Format Cells - General Cell Format Open Format Cells dialog with last selection active	`Ctrl` + `1`
Format Cells - General Cell Format Open Format Cells dialog with Font Tab active	`Ctrl` + `Shift` + `F`
Format Cells - Font Face, Font Decoration, and Cell Color Apply/ remove bold format	`Ctrl` + `B`
Format Cells - Font Face, Font Decoration, and Cell Color Apply/ remove italic format	`Ctrl` + `I`
Format Cells - Font Face, Font Decoration, and Cell Color Apply/ remove underline format	`Ctrl` + `U`
Format Cells - Font Face, Font Decoration, and Cell Color Apply/ remove strikethrough formatting	`Ctrl` + `5`
Format Cells - Font Face, Font Decoration, and Cell Color Home select Font Face; type font name supported by auto-complete, or use Arrow Down to select.	`Alt` + `H` , `FF`
Format Cells - Font Face, Font Decoration, and Cell Color Home select Font Size; use Arrow Key, then Enter to change size	`Alt` + `H` , `FS`
Format Cells - Font Face, Font Decoration, and Cell Color Assign current font color to selection via Home Font Color. While escaping the font-color drop-down, the focus stays on the icon; simply press Enter to assign the current color.	`Alt` + `H` , `FC` , `Escape` , `Enter`
Format Cells - Font Face, Font Decoration, and Cell Color Assign current fill color to selected cell color via Home Higlight Cell. While escaping the highlight drop-down, the focus stays on the icon; simply press Enter to assign the current color.	`Alt` + `HH` , `Escape` , `Enter`
Format Cells - Font Face, Font Decoration, and Cell Color Set to No fill color	`Alt` + `HH` , then `N`
Format Cells - Number Formats Apply the general number format (e.g. 1000)	`Ctrl` + `Shift` + `~`
Format Cells - Number Formats Apply the number format with two decimal places, thousands separator (e.g. 1,000.00)	`Ctrl` + `Shift` + `1`
Format Cells - Number Formats Apply the time format with the hour and minute, and indicate AM or PM	`Ctrl` + `Shift` + `2`
Format Cells - Number Formats Apply the date format with the day, month, and year	`Ctrl` + `Shift` + `3`
Format Cells - Number Formats Apply the currency format with two decimal places (e.g. $1,000.00)	`Ctrl` + `Shift` + `4`
Format Cells - Number Formats Apply the percentage format with no decimal places (e.g. 10%)	`Ctrl` + `Shift` + `5`
Format Cells - Number Formats Apply the scientific number format	`Ctrl` + `Shift` + `6`
Format Cells - Alignments Align Left	`Alt` + `H` , `AL`
Format Cells - Alignments Align Right	`Alt` + `H` , `AR`
Format Cells - Alignments Align Center	`Alt` + `H` , `AC`
Format Cells - Alignments Align Top	`Alt` + `H` , `AT`
Format Cells - Alignments Align Middle	`Alt` + `H` , `AM`
Format Cells - Alignments Align Bottom	`Alt` + `H` , `AB`
Format Cells - Wrap and Merge Wrap or unwrap text (Home - Wrap Text)	`Alt` + `H` , `W`
Format Cells - Wrap and Merge Merge cells - Merge	`Alt` + `H` , `MM`
Format Cells - Wrap and Merge Merge - Unmerge	`Alt` + `H` , `MU`
Format Cells - Wrap and Merge Merge and Center	`Alt` + `H` , `MC`
Format Cells - Wrap and Merge Merge Across (merge all columns, but not rows in selection)	`Alt` + `H` , `MA`
Format Cells - Border Shortcuts Home - Border - Menu; technically it says 'more'.	`Alt` + `H` , `BM`
Format Cells - Border Shortcuts Toggle Top border	`Alt` + `T` (in border menu)
Format Cells - Border Shortcuts Toggle Bottom border	`Alt` + `B`
Format Cells - Border Shortcuts Toggle Right border	`Alt` + `R`
Format Cells - Border Shortcuts Toggle Left border	`Alt` + `L`
Format Cells - Border Shortcuts Toggle Horizontal interior border	`Alt` + `H`
Format Cells - Border Shortcuts Toggle Vertical interior border	`Alt` + `V`
Format Cells - Border Shortcuts Toggle Upwards diagonal border	`Alt` + `U`
Format Cells - Border Shortcuts Toggle Downwards diagonal border	`Alt` + `D`
Format Cells - Border Shortcuts Add outline borders from cell or selection	`Ctrl` + `Shift` + `&`
Format Cells - Border Shortcuts Remove outline borders from cell or selection	`Ctrl` + `Shift` + `-`
Format Cells - Basics Start a formula	`=`
Format Cells - Basics Insert the AutoSum formula	`Alt` + `=`
Format Cells - Basics Edit formula in formula Bar	`Ctrl` + `A` with formula present
Format Cells - Basics Expand/ collapse formula bar	`Ctrl` + `Shift` + `U`
Format Cells - Basics 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`
Format Cells - Basics Display the 'insert function; dialog box	`Shift` + `F3` with empty cell
Format Cells - Basics Edit arguments of formula at cursor position	`Shift` + `F3` with formula present
Format Cells - Basics Select all Formulas (Home - Find - Formulas	`Alt` + `H` , `FD` , `U`
Format Cells - Basics Enter a formula as an array formula. Formula bar will show this as e.g. {=SUM(A1:A3B1:B3)} whichis the sum of A1B2+A2*B2+A3+B3. This is an easy and concise method. Remember that each time editing the formula will require the Ctrl+Shift+Enter. Some keyboards seem to distinguish between left and right Shift key	`Ctrl` + `Shift` + `Enter` with array formula
Format Cells - Basics Show/ hide all formulas. This will automatically extend all column widths which reverses when presed again	`Ctrl` + `~`
Format Cells - Basics Duplicate formula from cell above	`Ctr` + `'`
Format Cells - Basics Paste named range in formula	`F3`
Format Cells - Basics When navigated away while editing formula; jump back to active cell while keeping formula intact.	`Ctrl` + `Backspace`
Format Cells - Trace Dependents and Precedents Select direct precedents	`Ctrl` + `[`
Format Cells - Trace Dependents and Precedents Select all precedents	`Ctrl` + `Shift` + `[`
Format Cells - Trace Dependents and Precedents Select direct dependents	`Ctrl` + `]`
Format Cells - Trace Dependents and Precedents Select all dependents	`Ctrl` + `Shift` + `]`
Format Cells - Manual Calculation Calculate all worksheets in all open workbooks	`F9`
Format Cells - Manual Calculation Calculate the active worksheet	`Shift` + `F9`
Format Cells - Manual Calculation Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation	`Ctrl` + `Alt` + `F9`
Format Cells - Manual Calculation 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`
Format Cells - Open and Save Workbooks Open file via standard open dialog box	`Ctrl` + `O`
Format Cells - Open and Save Workbooks File Open via Excel file manager	`Alt` + `F` , `O`
Format Cells - Open and Save Workbooks Open recent file (1 thru 9)	`Alt` + `F` , `O` + `1` ... `9`
Format Cells - Open and Save Workbooks Open recent file (10 upwards)	`Alt` + `F` , `O` , `Y` `1` ... `Z`
Format Cells - Open and Save Workbooks File Open from OneDrive Link	`Alt` + `F` , `O` , `K`
Format Cells - Open and Save Workbooks Save File with current file name	`Ctrl` + `S`
Format Cells - Open and Save Workbooks Save file as via standard save dialog box	`F12`
Format Cells - Open and Save Workbooks File Save as via Excel file manager	`Alt` + `F` , `A`
Format Cells - Open and Save Workbooks File Save to OneDrive Link	`Alt` + `F` , `A` , `K`
Format Cells - Open and Save Workbooks Exit open/ save menu	`Escape`
Format Cells - Print Workbooks Print. This won't offer offer Key Tips/ Options. To continue with shortcuts, use the new Key Options below.	`Ctrl` + `P`
Format Cells - Print Workbooks Open File Print menu	`Alt` + `F` , `P`
Format Cells - Print Workbooks Select printer	`I` in Print Menu
Format Cells - Print Workbooks Return Print key tips/ options	`Alt` + `P` if Key Tips disappear
Format Cells - Print Workbooks Focus on View pane; use arrow keys to forward/ backward preview pages	`V` in Print Menu
Format Cells - Print Workbooks Page setup	`G` in Print Menu
Format Cells - Print Workbooks Set Number of copies	`N` in Print Menu
Format Cells - Auto Tables Create auto Table from selection	`Ctrl` + `T`
Format Cells - Auto Tables Select table column	`Ctrl` + `Space`
Format Cells - Auto Tables Select table row	`Shift` + `Space`
Format Cells - Data Forms Move to the next/ previous field which can be edited	`Tab` / `Shift` + `Tab`
Format Cells - Data Forms Move to the first field in the next/ previous record	`Enter` / `Shift` + `Enter`
Format Cells - Data Forms Move to the same field 10 records forward/ back	`Page Down` / `Page Up`
Format Cells - Data Forms Move to a new record	`Ctrl` + `Page Down`
Format Cells - Data Forms Move to the first record	`Ctrl` + `Page Up`
Format Cells - Data Forms Move to the beginning/ end of a field	`Home` / `End`
Formulas - Basic Selects Extend selection by one cell	`Shift` + `Arrow Keys`
Formulas - Basic Selects Extend selection one screen down/ up	`Shift` + `Page Down` / `Page Up`
Formulas - Basic Selects Extend selection to next non-blank cell	`Ctrl` + `Shift` + `Arrow Keys`
Formulas - Basic Selects Extend selection to beginning of the row (unfortunately, there is no Shift+End equivalent)	`Shift` + `Home`
Formulas - Basic Selects Select all	`Ctrl` + `A` with no data nearby current cell
Formulas - Basic Selects Select all cells in data-containing area. Press twice to select everything	`Ctrl` + `A` with data nearby current cell
Formulas - Basic Selects Extend selection to first cell of the worksheet	`Ctrl` + `Shift` + `Home`
Formulas - Basic Selects Extend selection to last used cell on the worksheet (lower-right corner)	`Ctrl` + `Shift` + `End`
Formulas - Basic Selects Lock Selection Extend Mode - Select Cell Range, press Shift+F8, move around, add to selection with Shift+Arrow Keys, etc	`Shift` + `F8`
Formulas - Basic Selects Manual selection by row/ column via GoTo menu. A:B selects column A thru C, 1:3 selects row 1 thru 3 , A1:B3 select cells A1 thru B3, etc	`Ctrl` + `G`
Formulas - Column and Row Selection Select current row	`Shift` + `Space`
Formulas - Column and Row Selection Select current row, then expand selection by one row down/ up	`Shift` + `Space` , then `Shift` + `Arrow Down` / `Arrow Up`
Formulas - Column and Row Selection Select current row, then expand selection by one page down/ up	`Shift` + `Space` , then `Shift` + `Page Down` / `Page Up`
Formulas - Column and Row Selection Select current column	`Ctrl` + `Space`
Formulas - Column and Row Selection Select current column, then expand selection by one column right/ left	`Shift` + `Space` , then `Shift` + `Arrow Right` / `Arrow Left`
Formulas - Column and Row Selection Select current column, then expand selection by one screen right/ left	`Shift` + `Space` , then `Shift` + `Alt` + `Page Down` / `Page Up`
Formulas - General Cell Format Copy a cell via Ctrl+C, then via Paste Spacieal, paste format of that cell to current cell	`Ctrl` + `Alt` + `V` , then `T` and `Enter`
Formulas - General Cell Format Repeat a previous cell format action on current cell	`Alt` + `Enter`
Formulas - General Cell Format Open Format Cells dialog with last selection active	`Ctrl` + `1`
Formulas - General Cell Format Open Format Cells dialog with Font Tab active	`Ctrl` + `Shift` + `F`
Formulas - Font Face, Font Decoration, and Cell Color Apply/ remove bold format	`Ctrl` + `B`
Formulas - Font Face, Font Decoration, and Cell Color Apply/ remove italic format	`Ctrl` + `I`
Formulas - Font Face, Font Decoration, and Cell Color Apply/ remove underline format	`Ctrl` + `U`
Formulas - Font Face, Font Decoration, and Cell Color Apply/ remove strikethrough formatting	`Ctrl` + `5`
Formulas - Font Face, Font Decoration, and Cell Color Home select Font Face; type font name supported by auto-complete, or use Arrow Down to select.	`Alt` + `H` , `FF`
Formulas - Font Face, Font Decoration, and Cell Color Home select Font Size; use Arrow Key, then Enter to change size	`Alt` + `H` , `FS`
Formulas - Font Face, Font Decoration, and Cell Color Assign current font color to selection via Home Font Color. While escaping the font-color drop-down, the focus stays on the icon; simply press Enter to assign the current color.	`Alt` + `H` , `FC` , `Escape` , `Enter`
Formulas - Font Face, Font Decoration, and Cell Color Assign current fill color to selected cell color via Home Higlight Cell. While escaping the highlight drop-down, the focus stays on the icon; simply press Enter to assign the current color.	`Alt` + `HH` , `Escape` , `Enter`
Formulas - Font Face, Font Decoration, and Cell Color Set to No fill color	`Alt` + `HH` , then `N`
Formulas - Number Formats Apply the general number format (e.g. 1000)	`Ctrl` + `Shift` + `~`
Formulas - Number Formats Apply the number format with two decimal places, thousands separator (e.g. 1,000.00)	`Ctrl` + `Shift` + `1`
Formulas - Number Formats Apply the time format with the hour and minute, and indicate AM or PM	`Ctrl` + `Shift` + `2`
Formulas - Number Formats Apply the date format with the day, month, and year	`Ctrl` + `Shift` + `3`
Formulas - Number Formats Apply the currency format with two decimal places (e.g. $1,000.00)	`Ctrl` + `Shift` + `4`
Formulas - Number Formats Apply the percentage format with no decimal places (e.g. 10%)	`Ctrl` + `Shift` + `5`
Formulas - Number Formats Apply the scientific number format	`Ctrl` + `Shift` + `6`
Formulas - Alignments Align Left	`Alt` + `H` , `AL`
Formulas - Alignments Align Right	`Alt` + `H` , `AR`
Formulas - Alignments Align Center	`Alt` + `H` , `AC`
Formulas - Alignments Align Top	`Alt` + `H` , `AT`
Formulas - Alignments Align Middle	`Alt` + `H` , `AM`
Formulas - Alignments Align Bottom	`Alt` + `H` , `AB`
Formulas - Wrap and Merge Wrap or unwrap text (Home - Wrap Text)	`Alt` + `H` , `W`
Formulas - Wrap and Merge Merge cells - Merge	`Alt` + `H` , `MM`
Formulas - Wrap and Merge Merge - Unmerge	`Alt` + `H` , `MU`
Formulas - Wrap and Merge Merge and Center	`Alt` + `H` , `MC`
Formulas - Wrap and Merge Merge Across (merge all columns, but not rows in selection)	`Alt` + `H` , `MA`
Formulas - Border Shortcuts Home - Border - Menu; technically it says 'more'.	`Alt` + `H` , `BM`
Formulas - Border Shortcuts Toggle Top border	`Alt` + `T` (in border menu)
Formulas - Border Shortcuts Toggle Bottom border	`Alt` + `B`
Formulas - Border Shortcuts Toggle Right border	`Alt` + `R`
Formulas - Border Shortcuts Toggle Left border	`Alt` + `L`
Formulas - Border Shortcuts Toggle Horizontal interior border	`Alt` + `H`
Formulas - Border Shortcuts Toggle Vertical interior border	`Alt` + `V`
Formulas - Border Shortcuts Toggle Upwards diagonal border	`Alt` + `U`
Formulas - Border Shortcuts Toggle Downwards diagonal border	`Alt` + `D`
Formulas - Border Shortcuts Add outline borders from cell or selection	`Ctrl` + `Shift` + `&`
Formulas - Border Shortcuts Remove outline borders from cell or selection	`Ctrl` + `Shift` + `-`
Formulas - Basics Start a formula	`=`
Formulas - Basics Insert the AutoSum formula	`Alt` + `=`
Formulas - Basics Edit formula in formula Bar	`Ctrl` + `A` with formula present
Formulas - Basics Expand/ collapse formula bar	`Ctrl` + `Shift` + `U`
Formulas - Basics 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`
Formulas - Basics Display the 'insert function; dialog box	`Shift` + `F3` with empty cell
Formulas - Basics Edit arguments of formula at cursor position	`Shift` + `F3` with formula present
Formulas - Basics Select all Formulas (Home - Find - Formulas	`Alt` + `H` , `FD` , `U`
Formulas - Basics Enter a formula as an array formula. Formula bar will show this as e.g. {=SUM(A1:A3B1:B3)} whichis the sum of A1B2+A2*B2+A3+B3. This is an easy and concise method. Remember that each time editing the formula will require the Ctrl+Shift+Enter. Some keyboards seem to distinguish between left and right Shift key	`Ctrl` + `Shift` + `Enter` with array formula
Formulas - Basics Show/ hide all formulas. This will automatically extend all column widths which reverses when presed again	`Ctrl` + `~`
Formulas - Basics Duplicate formula from cell above	`Ctr` + `'`
Formulas - Basics Paste named range in formula	`F3`
Formulas - Basics When navigated away while editing formula; jump back to active cell while keeping formula intact.	`Ctrl` + `Backspace`
Formulas - Trace Dependents and Precedents Select direct precedents	`Ctrl` + `[`
Formulas - Trace Dependents and Precedents Select all precedents	`Ctrl` + `Shift` + `[`
Formulas - Trace Dependents and Precedents Select direct dependents	`Ctrl` + `]`
Formulas - Trace Dependents and Precedents Select all dependents	`Ctrl` + `Shift` + `]`
Formulas - Manual Calculation Calculate all worksheets in all open workbooks	`F9`
Formulas - Manual Calculation Calculate the active worksheet	`Shift` + `F9`
Formulas - Manual Calculation Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation	`Ctrl` + `Alt` + `F9`
Formulas - Manual Calculation 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`
Formulas - Open and Save Workbooks Open file via standard open dialog box	`Ctrl` + `O`
Formulas - Open and Save Workbooks File Open via Excel file manager	`Alt` + `F` , `O`
Formulas - Open and Save Workbooks Open recent file (1 thru 9)	`Alt` + `F` , `O` + `1` ... `9`
Formulas - Open and Save Workbooks Open recent file (10 upwards)	`Alt` + `F` , `O` , `Y` `1` ... `Z`
Formulas - Open and Save Workbooks File Open from OneDrive Link	`Alt` + `F` , `O` , `K`
Formulas - Open and Save Workbooks Save File with current file name	`Ctrl` + `S`
Formulas - Open and Save Workbooks Save file as via standard save dialog box	`F12`
Formulas - Open and Save Workbooks File Save as via Excel file manager	`Alt` + `F` , `A`
Formulas - Open and Save Workbooks File Save to OneDrive Link	`Alt` + `F` , `A` , `K`
Formulas - Open and Save Workbooks Exit open/ save menu	`Escape`
Formulas - Print Workbooks Print. This won't offer offer Key Tips/ Options. To continue with shortcuts, use the new Key Options below.	`Ctrl` + `P`
Formulas - Print Workbooks Open File Print menu	`Alt` + `F` , `P`
Formulas - Print Workbooks Select printer	`I` in Print Menu
Formulas - Print Workbooks Return Print key tips/ options	`Alt` + `P` if Key Tips disappear
Formulas - Print Workbooks Focus on View pane; use arrow keys to forward/ backward preview pages	`V` in Print Menu
Formulas - Print Workbooks Page setup	`G` in Print Menu
Formulas - Print Workbooks Set Number of copies	`N` in Print Menu
Formulas - Auto Tables Create auto Table from selection	`Ctrl` + `T`
Formulas - Auto Tables Select table column	`Ctrl` + `Space`
Formulas - Auto Tables Select table row	`Shift` + `Space`
Formulas - Data Forms Move to the next/ previous field which can be edited	`Tab` / `Shift` + `Tab`
Formulas - Data Forms Move to the first field in the next/ previous record	`Enter` / `Shift` + `Enter`
Formulas - Data Forms Move to the same field 10 records forward/ back	`Page Down` / `Page Up`
Formulas - Data Forms Move to a new record	`Ctrl` + `Page Down`
Formulas - Data Forms Move to the first record	`Ctrl` + `Page Up`
Formulas - Data Forms Move to the beginning/ end of a field	`Home` / `End`
Manage Workbooks - Basic Selects Extend selection by one cell	`Shift` + `Arrow Keys`
Manage Workbooks - Basic Selects Extend selection one screen down/ up	`Shift` + `Page Down` / `Page Up`
Manage Workbooks - Basic Selects Extend selection to next non-blank cell	`Ctrl` + `Shift` + `Arrow Keys`
Manage Workbooks - Basic Selects Extend selection to beginning of the row (unfortunately, there is no Shift+End equivalent)	`Shift` + `Home`
Manage Workbooks - Basic Selects Select all	`Ctrl` + `A` with no data nearby current cell
Manage Workbooks - Basic Selects Select all cells in data-containing area. Press twice to select everything	`Ctrl` + `A` with data nearby current cell
Manage Workbooks - Basic Selects Extend selection to first cell of the worksheet	`Ctrl` + `Shift` + `Home`
Manage Workbooks - Basic Selects Extend selection to last used cell on the worksheet (lower-right corner)	`Ctrl` + `Shift` + `End`
Manage Workbooks - Basic Selects Lock Selection Extend Mode - Select Cell Range, press Shift+F8, move around, add to selection with Shift+Arrow Keys, etc	`Shift` + `F8`
Manage Workbooks - Basic Selects Manual selection by row/ column via GoTo menu. A:B selects column A thru C, 1:3 selects row 1 thru 3 , A1:B3 select cells A1 thru B3, etc	`Ctrl` + `G`
Manage Workbooks - Column and Row Selection Select current row	`Shift` + `Space`
Manage Workbooks - Column and Row Selection Select current row, then expand selection by one row down/ up	`Shift` + `Space` , then `Shift` + `Arrow Down` / `Arrow Up`
Manage Workbooks - Column and Row Selection Select current row, then expand selection by one page down/ up	`Shift` + `Space` , then `Shift` + `Page Down` / `Page Up`
Manage Workbooks - Column and Row Selection Select current column	`Ctrl` + `Space`
Manage Workbooks - Column and Row Selection Select current column, then expand selection by one column right/ left	`Shift` + `Space` , then `Shift` + `Arrow Right` / `Arrow Left`
Manage Workbooks - Column and Row Selection Select current column, then expand selection by one screen right/ left	`Shift` + `Space` , then `Shift` + `Alt` + `Page Down` / `Page Up`
Manage Workbooks - General Cell Format Copy a cell via Ctrl+C, then via Paste Spacieal, paste format of that cell to current cell	`Ctrl` + `Alt` + `V` , then `T` and `Enter`
Manage Workbooks - General Cell Format Repeat a previous cell format action on current cell	`Alt` + `Enter`
Manage Workbooks - General Cell Format Open Format Cells dialog with last selection active	`Ctrl` + `1`
Manage Workbooks - General Cell Format Open Format Cells dialog with Font Tab active	`Ctrl` + `Shift` + `F`
Manage Workbooks - Font Face, Font Decoration, and Cell Color Apply/ remove bold format	`Ctrl` + `B`
Manage Workbooks - Font Face, Font Decoration, and Cell Color Apply/ remove italic format	`Ctrl` + `I`
Manage Workbooks - Font Face, Font Decoration, and Cell Color Apply/ remove underline format	`Ctrl` + `U`
Manage Workbooks - Font Face, Font Decoration, and Cell Color Apply/ remove strikethrough formatting	`Ctrl` + `5`
Manage Workbooks - Font Face, Font Decoration, and Cell Color Home select Font Face; type font name supported by auto-complete, or use Arrow Down to select.	`Alt` + `H` , `FF`
Manage Workbooks - Font Face, Font Decoration, and Cell Color Home select Font Size; use Arrow Key, then Enter to change size	`Alt` + `H` , `FS`
Manage Workbooks - Font Face, Font Decoration, and Cell Color Assign current font color to selection via Home Font Color. While escaping the font-color drop-down, the focus stays on the icon; simply press Enter to assign the current color.	`Alt` + `H` , `FC` , `Escape` , `Enter`
Manage Workbooks - Font Face, Font Decoration, and Cell Color Assign current fill color to selected cell color via Home Higlight Cell. While escaping the highlight drop-down, the focus stays on the icon; simply press Enter to assign the current color.	`Alt` + `HH` , `Escape` , `Enter`
Manage Workbooks - Font Face, Font Decoration, and Cell Color Set to No fill color	`Alt` + `HH` , then `N`
Manage Workbooks - Number Formats Apply the general number format (e.g. 1000)	`Ctrl` + `Shift` + `~`
Manage Workbooks - Number Formats Apply the number format with two decimal places, thousands separator (e.g. 1,000.00)	`Ctrl` + `Shift` + `1`
Manage Workbooks - Number Formats Apply the time format with the hour and minute, and indicate AM or PM	`Ctrl` + `Shift` + `2`
Manage Workbooks - Number Formats Apply the date format with the day, month, and year	`Ctrl` + `Shift` + `3`
Manage Workbooks - Number Formats Apply the currency format with two decimal places (e.g. $1,000.00)	`Ctrl` + `Shift` + `4`
Manage Workbooks - Number Formats Apply the percentage format with no decimal places (e.g. 10%)	`Ctrl` + `Shift` + `5`
Manage Workbooks - Number Formats Apply the scientific number format	`Ctrl` + `Shift` + `6`
Manage Workbooks - Alignments Align Left	`Alt` + `H` , `AL`
Manage Workbooks - Alignments Align Right	`Alt` + `H` , `AR`
Manage Workbooks - Alignments Align Center	`Alt` + `H` , `AC`
Manage Workbooks - Alignments Align Top	`Alt` + `H` , `AT`
Manage Workbooks - Alignments Align Middle	`Alt` + `H` , `AM`
Manage Workbooks - Alignments Align Bottom	`Alt` + `H` , `AB`
Manage Workbooks - Wrap and Merge Wrap or unwrap text (Home - Wrap Text)	`Alt` + `H` , `W`
Manage Workbooks - Wrap and Merge Merge cells - Merge	`Alt` + `H` , `MM`
Manage Workbooks - Wrap and Merge Merge - Unmerge	`Alt` + `H` , `MU`
Manage Workbooks - Wrap and Merge Merge and Center	`Alt` + `H` , `MC`
Manage Workbooks - Wrap and Merge Merge Across (merge all columns, but not rows in selection)	`Alt` + `H` , `MA`
Manage Workbooks - Border Shortcuts Home - Border - Menu; technically it says 'more'.	`Alt` + `H` , `BM`
Manage Workbooks - Border Shortcuts Toggle Top border	`Alt` + `T` (in border menu)
Manage Workbooks - Border Shortcuts Toggle Bottom border	`Alt` + `B`
Manage Workbooks - Border Shortcuts Toggle Right border	`Alt` + `R`
Manage Workbooks - Border Shortcuts Toggle Left border	`Alt` + `L`
Manage Workbooks - Border Shortcuts Toggle Horizontal interior border	`Alt` + `H`
Manage Workbooks - Border Shortcuts Toggle Vertical interior border	`Alt` + `V`
Manage Workbooks - Border Shortcuts Toggle Upwards diagonal border	`Alt` + `U`
Manage Workbooks - Border Shortcuts Toggle Downwards diagonal border	`Alt` + `D`
Manage Workbooks - Border Shortcuts Add outline borders from cell or selection	`Ctrl` + `Shift` + `&`
Manage Workbooks - Border Shortcuts Remove outline borders from cell or selection	`Ctrl` + `Shift` + `-`
Manage Workbooks - Basics Start a formula	`=`
Manage Workbooks - Basics Insert the AutoSum formula	`Alt` + `=`
Manage Workbooks - Basics Edit formula in formula Bar	`Ctrl` + `A` with formula present
Manage Workbooks - Basics Expand/ collapse formula bar	`Ctrl` + `Shift` + `U`
Manage Workbooks - Basics 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 Workbooks - Basics Display the 'insert function; dialog box	`Shift` + `F3` with empty cell
Manage Workbooks - Basics Edit arguments of formula at cursor position	`Shift` + `F3` with formula present
Manage Workbooks - Basics Select all Formulas (Home - Find - Formulas	`Alt` + `H` , `FD` , `U`
Manage Workbooks - Basics Enter a formula as an array formula. Formula bar will show this as e.g. {=SUM(A1:A3B1:B3)} whichis the sum of A1B2+A2*B2+A3+B3. This is an easy and concise method. Remember that each time editing the formula will require the Ctrl+Shift+Enter. Some keyboards seem to distinguish between left and right Shift key	`Ctrl` + `Shift` + `Enter` with array formula
Manage Workbooks - Basics Show/ hide all formulas. This will automatically extend all column widths which reverses when presed again	`Ctrl` + `~`
Manage Workbooks - Basics Duplicate formula from cell above	`Ctr` + `'`
Manage Workbooks - Basics Paste named range in formula	`F3`
Manage Workbooks - Basics When navigated away while editing formula; jump back to active cell while keeping formula intact.	`Ctrl` + `Backspace`
Manage Workbooks - Trace Dependents and Precedents Select direct precedents	`Ctrl` + `[`
Manage Workbooks - Trace Dependents and Precedents Select all precedents	`Ctrl` + `Shift` + `[`
Manage Workbooks - Trace Dependents and Precedents Select direct dependents	`Ctrl` + `]`
Manage Workbooks - Trace Dependents and Precedents Select all dependents	`Ctrl` + `Shift` + `]`
Manage Workbooks - Manual Calculation Calculate all worksheets in all open workbooks	`F9`
Manage Workbooks - Manual Calculation Calculate the active worksheet	`Shift` + `F9`
Manage Workbooks - Manual Calculation Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation	`Ctrl` + `Alt` + `F9`
Manage Workbooks - Manual Calculation 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`
Manage Workbooks - Open and Save Workbooks Open file via standard open dialog box	`Ctrl` + `O`
Manage Workbooks - Open and Save Workbooks File Open via Excel file manager	`Alt` + `F` , `O`
Manage Workbooks - Open and Save Workbooks Open recent file (1 thru 9)	`Alt` + `F` , `O` + `1` ... `9`
Manage Workbooks - Open and Save Workbooks Open recent file (10 upwards)	`Alt` + `F` , `O` , `Y` `1` ... `Z`
Manage Workbooks - Open and Save Workbooks File Open from OneDrive Link	`Alt` + `F` , `O` , `K`
Manage Workbooks - Open and Save Workbooks Save File with current file name	`Ctrl` + `S`
Manage Workbooks - Open and Save Workbooks Save file as via standard save dialog box	`F12`
Manage Workbooks - Open and Save Workbooks File Save as via Excel file manager	`Alt` + `F` , `A`
Manage Workbooks - Open and Save Workbooks File Save to OneDrive Link	`Alt` + `F` , `A` , `K`
Manage Workbooks - Open and Save Workbooks Exit open/ save menu	`Escape`
Manage Workbooks - Print Workbooks Print. This won't offer offer Key Tips/ Options. To continue with shortcuts, use the new Key Options below.	`Ctrl` + `P`
Manage Workbooks - Print Workbooks Open File Print menu	`Alt` + `F` , `P`
Manage Workbooks - Print Workbooks Select printer	`I` in Print Menu
Manage Workbooks - Print Workbooks Return Print key tips/ options	`Alt` + `P` if Key Tips disappear
Manage Workbooks - Print Workbooks Focus on View pane; use arrow keys to forward/ backward preview pages	`V` in Print Menu
Manage Workbooks - Print Workbooks Page setup	`G` in Print Menu
Manage Workbooks - Print Workbooks Set Number of copies	`N` in Print Menu
Manage Workbooks - Auto Tables Create auto Table from selection	`Ctrl` + `T`
Manage Workbooks - Auto Tables Select table column	`Ctrl` + `Space`
Manage Workbooks - Auto Tables Select table row	`Shift` + `Space`
Manage Workbooks - Data Forms Move to the next/ previous field which can be edited	`Tab` / `Shift` + `Tab`
Manage Workbooks - Data Forms Move to the first field in the next/ previous record	`Enter` / `Shift` + `Enter`
Manage Workbooks - Data Forms Move to the same field 10 records forward/ back	`Page Down` / `Page Up`
Manage Workbooks - Data Forms Move to a new record	`Ctrl` + `Page Down`
Manage Workbooks - Data Forms Move to the first record	`Ctrl` + `Page Up`
Manage Workbooks - Data Forms Move to the beginning/ end of a field	`Home` / `End`
Excel Auto Tables and Data Forms - Basic Selects Extend selection by one cell	`Shift` + `Arrow Keys`
Excel Auto Tables and Data Forms - Basic Selects Extend selection one screen down/ up	`Shift` + `Page Down` / `Page Up`
Excel Auto Tables and Data Forms - Basic Selects Extend selection to next non-blank cell	`Ctrl` + `Shift` + `Arrow Keys`
Excel Auto Tables and Data Forms - Basic Selects Extend selection to beginning of the row (unfortunately, there is no Shift+End equivalent)	`Shift` + `Home`
Excel Auto Tables and Data Forms - Basic Selects Select all	`Ctrl` + `A` with no data nearby current cell
Excel Auto Tables and Data Forms - Basic Selects Select all cells in data-containing area. Press twice to select everything	`Ctrl` + `A` with data nearby current cell
Excel Auto Tables and Data Forms - Basic Selects Extend selection to first cell of the worksheet	`Ctrl` + `Shift` + `Home`
Excel Auto Tables and Data Forms - Basic Selects Extend selection to last used cell on the worksheet (lower-right corner)	`Ctrl` + `Shift` + `End`
Excel Auto Tables and Data Forms - Basic Selects Lock Selection Extend Mode - Select Cell Range, press Shift+F8, move around, add to selection with Shift+Arrow Keys, etc	`Shift` + `F8`
Excel Auto Tables and Data Forms - Basic Selects Manual selection by row/ column via GoTo menu. A:B selects column A thru C, 1:3 selects row 1 thru 3 , A1:B3 select cells A1 thru B3, etc	`Ctrl` + `G`
Excel Auto Tables and Data Forms - Column and Row Selection Select current row	`Shift` + `Space`
Excel Auto Tables and Data Forms - Column and Row Selection Select current row, then expand selection by one row down/ up	`Shift` + `Space` , then `Shift` + `Arrow Down` / `Arrow Up`
Excel Auto Tables and Data Forms - Column and Row Selection Select current row, then expand selection by one page down/ up	`Shift` + `Space` , then `Shift` + `Page Down` / `Page Up`
Excel Auto Tables and Data Forms - Column and Row Selection Select current column	`Ctrl` + `Space`
Excel Auto Tables and Data Forms - Column and Row Selection Select current column, then expand selection by one column right/ left	`Shift` + `Space` , then `Shift` + `Arrow Right` / `Arrow Left`
Excel Auto Tables and Data Forms - Column and Row Selection Select current column, then expand selection by one screen right/ left	`Shift` + `Space` , then `Shift` + `Alt` + `Page Down` / `Page Up`
Excel Auto Tables and Data Forms - General Cell Format Copy a cell via Ctrl+C, then via Paste Spacieal, paste format of that cell to current cell	`Ctrl` + `Alt` + `V` , then `T` and `Enter`
Excel Auto Tables and Data Forms - General Cell Format Repeat a previous cell format action on current cell	`Alt` + `Enter`
Excel Auto Tables and Data Forms - General Cell Format Open Format Cells dialog with last selection active	`Ctrl` + `1`
Excel Auto Tables and Data Forms - General Cell Format Open Format Cells dialog with Font Tab active	`Ctrl` + `Shift` + `F`
Excel Auto Tables and Data Forms - Font Face, Font Decoration, and Cell Color Apply/ remove bold format	`Ctrl` + `B`
Excel Auto Tables and Data Forms - Font Face, Font Decoration, and Cell Color Apply/ remove italic format	`Ctrl` + `I`
Excel Auto Tables and Data Forms - Font Face, Font Decoration, and Cell Color Apply/ remove underline format	`Ctrl` + `U`
Excel Auto Tables and Data Forms - Font Face, Font Decoration, and Cell Color Apply/ remove strikethrough formatting	`Ctrl` + `5`
Excel Auto Tables and Data Forms - Font Face, Font Decoration, and Cell Color Home select Font Face; type font name supported by auto-complete, or use Arrow Down to select.	`Alt` + `H` , `FF`
Excel Auto Tables and Data Forms - Font Face, Font Decoration, and Cell Color Home select Font Size; use Arrow Key, then Enter to change size	`Alt` + `H` , `FS`
Excel Auto Tables and Data Forms - Font Face, Font Decoration, and Cell Color Assign current font color to selection via Home Font Color. While escaping the font-color drop-down, the focus stays on the icon; simply press Enter to assign the current color.	`Alt` + `H` , `FC` , `Escape` , `Enter`
Excel Auto Tables and Data Forms - Font Face, Font Decoration, and Cell Color Assign current fill color to selected cell color via Home Higlight Cell. While escaping the highlight drop-down, the focus stays on the icon; simply press Enter to assign the current color.	`Alt` + `HH` , `Escape` , `Enter`
Excel Auto Tables and Data Forms - Font Face, Font Decoration, and Cell Color Set to No fill color	`Alt` + `HH` , then `N`
Excel Auto Tables and Data Forms - Number Formats Apply the general number format (e.g. 1000)	`Ctrl` + `Shift` + `~`
Excel Auto Tables and Data Forms - Number Formats Apply the number format with two decimal places, thousands separator (e.g. 1,000.00)	`Ctrl` + `Shift` + `1`
Excel Auto Tables and Data Forms - Number Formats Apply the time format with the hour and minute, and indicate AM or PM	`Ctrl` + `Shift` + `2`
Excel Auto Tables and Data Forms - Number Formats Apply the date format with the day, month, and year	`Ctrl` + `Shift` + `3`
Excel Auto Tables and Data Forms - Number Formats Apply the currency format with two decimal places (e.g. $1,000.00)	`Ctrl` + `Shift` + `4`
Excel Auto Tables and Data Forms - Number Formats Apply the percentage format with no decimal places (e.g. 10%)	`Ctrl` + `Shift` + `5`
Excel Auto Tables and Data Forms - Number Formats Apply the scientific number format	`Ctrl` + `Shift` + `6`
Excel Auto Tables and Data Forms - Alignments Align Left	`Alt` + `H` , `AL`
Excel Auto Tables and Data Forms - Alignments Align Right	`Alt` + `H` , `AR`
Excel Auto Tables and Data Forms - Alignments Align Center	`Alt` + `H` , `AC`
Excel Auto Tables and Data Forms - Alignments Align Top	`Alt` + `H` , `AT`
Excel Auto Tables and Data Forms - Alignments Align Middle	`Alt` + `H` , `AM`
Excel Auto Tables and Data Forms - Alignments Align Bottom	`Alt` + `H` , `AB`
Excel Auto Tables and Data Forms - Wrap and Merge Wrap or unwrap text (Home - Wrap Text)	`Alt` + `H` , `W`
Excel Auto Tables and Data Forms - Wrap and Merge Merge cells - Merge	`Alt` + `H` , `MM`
Excel Auto Tables and Data Forms - Wrap and Merge Merge - Unmerge	`Alt` + `H` , `MU`
Excel Auto Tables and Data Forms - Wrap and Merge Merge and Center	`Alt` + `H` , `MC`
Excel Auto Tables and Data Forms - Wrap and Merge Merge Across (merge all columns, but not rows in selection)	`Alt` + `H` , `MA`
Excel Auto Tables and Data Forms - Border Shortcuts Home - Border - Menu; technically it says 'more'.	`Alt` + `H` , `BM`
Excel Auto Tables and Data Forms - Border Shortcuts Toggle Top border	`Alt` + `T` (in border menu)
Excel Auto Tables and Data Forms - Border Shortcuts Toggle Bottom border	`Alt` + `B`
Excel Auto Tables and Data Forms - Border Shortcuts Toggle Right border	`Alt` + `R`
Excel Auto Tables and Data Forms - Border Shortcuts Toggle Left border	`Alt` + `L`
Excel Auto Tables and Data Forms - Border Shortcuts Toggle Horizontal interior border	`Alt` + `H`
Excel Auto Tables and Data Forms - Border Shortcuts Toggle Vertical interior border	`Alt` + `V`
Excel Auto Tables and Data Forms - Border Shortcuts Toggle Upwards diagonal border	`Alt` + `U`
Excel Auto Tables and Data Forms - Border Shortcuts Toggle Downwards diagonal border	`Alt` + `D`
Excel Auto Tables and Data Forms - Border Shortcuts Add outline borders from cell or selection	`Ctrl` + `Shift` + `&`
Excel Auto Tables and Data Forms - Border Shortcuts Remove outline borders from cell or selection	`Ctrl` + `Shift` + `-`
Excel Auto Tables and Data Forms - Basics Start a formula	`=`
Excel Auto Tables and Data Forms - Basics Insert the AutoSum formula	`Alt` + `=`
Excel Auto Tables and Data Forms - Basics Edit formula in formula Bar	`Ctrl` + `A` with formula present
Excel Auto Tables and Data Forms - Basics Expand/ collapse formula bar	`Ctrl` + `Shift` + `U`
Excel Auto Tables and Data Forms - Basics 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`
Excel Auto Tables and Data Forms - Basics Display the 'insert function; dialog box	`Shift` + `F3` with empty cell
Excel Auto Tables and Data Forms - Basics Edit arguments of formula at cursor position	`Shift` + `F3` with formula present
Excel Auto Tables and Data Forms - Basics Select all Formulas (Home - Find - Formulas	`Alt` + `H` , `FD` , `U`
Excel Auto Tables and Data Forms - Basics Enter a formula as an array formula. Formula bar will show this as e.g. {=SUM(A1:A3B1:B3)} whichis the sum of A1B2+A2*B2+A3+B3. This is an easy and concise method. Remember that each time editing the formula will require the Ctrl+Shift+Enter. Some keyboards seem to distinguish between left and right Shift key	`Ctrl` + `Shift` + `Enter` with array formula
Excel Auto Tables and Data Forms - Basics Show/ hide all formulas. This will automatically extend all column widths which reverses when presed again	`Ctrl` + `~`
Excel Auto Tables and Data Forms - Basics Duplicate formula from cell above	`Ctr` + `'`
Excel Auto Tables and Data Forms - Basics Paste named range in formula	`F3`
Excel Auto Tables and Data Forms - Basics When navigated away while editing formula; jump back to active cell while keeping formula intact.	`Ctrl` + `Backspace`
Excel Auto Tables and Data Forms - Trace Dependents and Precedents Select direct precedents	`Ctrl` + `[`
Excel Auto Tables and Data Forms - Trace Dependents and Precedents Select all precedents	`Ctrl` + `Shift` + `[`
Excel Auto Tables and Data Forms - Trace Dependents and Precedents Select direct dependents	`Ctrl` + `]`
Excel Auto Tables and Data Forms - Trace Dependents and Precedents Select all dependents	`Ctrl` + `Shift` + `]`
Excel Auto Tables and Data Forms - Manual Calculation Calculate all worksheets in all open workbooks	`F9`
Excel Auto Tables and Data Forms - Manual Calculation Calculate the active worksheet	`Shift` + `F9`
Excel Auto Tables and Data Forms - Manual Calculation Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation	`Ctrl` + `Alt` + `F9`
Excel Auto Tables and Data Forms - Manual Calculation 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`
Excel Auto Tables and Data Forms - Open and Save Workbooks Open file via standard open dialog box	`Ctrl` + `O`
Excel Auto Tables and Data Forms - Open and Save Workbooks File Open via Excel file manager	`Alt` + `F` , `O`
Excel Auto Tables and Data Forms - Open and Save Workbooks Open recent file (1 thru 9)	`Alt` + `F` , `O` + `1` ... `9`
Excel Auto Tables and Data Forms - Open and Save Workbooks Open recent file (10 upwards)	`Alt` + `F` , `O` , `Y` `1` ... `Z`
Excel Auto Tables and Data Forms - Open and Save Workbooks File Open from OneDrive Link	`Alt` + `F` , `O` , `K`
Excel Auto Tables and Data Forms - Open and Save Workbooks Save File with current file name	`Ctrl` + `S`
Excel Auto Tables and Data Forms - Open and Save Workbooks Save file as via standard save dialog box	`F12`
Excel Auto Tables and Data Forms - Open and Save Workbooks File Save as via Excel file manager	`Alt` + `F` , `A`
Excel Auto Tables and Data Forms - Open and Save Workbooks File Save to OneDrive Link	`Alt` + `F` , `A` , `K`
Excel Auto Tables and Data Forms - Open and Save Workbooks Exit open/ save menu	`Escape`
Excel Auto Tables and Data Forms - Print Workbooks Print. This won't offer offer Key Tips/ Options. To continue with shortcuts, use the new Key Options below.	`Ctrl` + `P`
Excel Auto Tables and Data Forms - Print Workbooks Open File Print menu	`Alt` + `F` , `P`
Excel Auto Tables and Data Forms - Print Workbooks Select printer	`I` in Print Menu
Excel Auto Tables and Data Forms - Print Workbooks Return Print key tips/ options	`Alt` + `P` if Key Tips disappear
Excel Auto Tables and Data Forms - Print Workbooks Focus on View pane; use arrow keys to forward/ backward preview pages	`V` in Print Menu
Excel Auto Tables and Data Forms - Print Workbooks Page setup	`G` in Print Menu
Excel Auto Tables and Data Forms - Print Workbooks Set Number of copies	`N` in Print Menu
Excel Auto Tables and Data Forms - Auto Tables Create auto Table from selection	`Ctrl` + `T`
Excel Auto Tables and Data Forms - Auto Tables Select table column	`Ctrl` + `Space`
Excel Auto Tables and Data Forms - Auto Tables Select table row	`Shift` + `Space`
Excel Auto Tables and Data Forms - Data Forms Move to the next/ previous field which can be edited	`Tab` / `Shift` + `Tab`
Excel Auto Tables and Data Forms - Data Forms Move to the first field in the next/ previous record	`Enter` / `Shift` + `Enter`
Excel Auto Tables and Data Forms - Data Forms Move to the same field 10 records forward/ back	`Page Down` / `Page Up`
Excel Auto Tables and Data Forms - Data Forms Move to a new record	`Ctrl` + `Page Down`
Excel Auto Tables and Data Forms - Data Forms Move to the first record	`Ctrl` + `Page Up`
Excel Auto Tables and Data Forms - Data Forms Move to the beginning/ end of a field	`Home` / `End`
Navigate Worksheets Navigate by one cell at a time in any direction	`Arrow Keys`
Navigate Worksheets Move one screen down/ up	`Page Down` / `Page Up`
Navigate Worksheets Move one screen right/ left	`Alt` + `Page Down` / `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 row	`Home`
Navigate Worksheets Move to the beginning of worksheet	`Ctrl` + `Home`
Navigate Worksheets Move to the last cell with content of worksheet	`Ctrl` + `End`
Navigate Worksheets Display the GoTo dialog box	`Ctrl` + `G`
Navigate Worksheets Go to line 50, Column A	`Ctrl` + `G` then type e.g. A50
Navigate Worksheets Go to column G, Line 1	`Ctrl` + `G` then type e.g. G1
Juggle Rows, Columns, and Cells Select single row; then delete	`Shift` + `Space` , then `Ctrl` + `-`
Juggle Rows, Columns, and Cells Select multiple rows; then delete	`Shift` + `Space` , `Shift` + `Arrow Up` / `Arrow Down` , then `Ctrl` + `-`
Juggle Rows, Columns, and Cells Select single row; then insert one row above	`Shift` + `Space` , `Ctrl` + `Shift` + `+`
Juggle Rows, Columns, and Cells Select multiple rows; then insert the same number rows below	`Shift` + `Space` , `Shift` + `Arrow Up` / `Arrow Down` , then `Ctrl` + `Shift` + `+`
Juggle Rows, Columns, and Cells Select single (or multiple) columns, then delete	`Shift` + `Space` , then `Ctrl` + `-`
Juggle Rows, Columns, and Cells Select single row, then insert row below. Select multiple rows to insert multiple rows	`Shift` + `Space` , then `Ctrl` + `Shift` + `+`
Juggle Rows, Columns, and Cells Paste Insert - paste row(s) from clipboard and shift existing content downward	`Ctrl` + `Shift` + `+` with row(s) in clipboard and a row selected
Juggle Rows, Columns, and Cells Paste Insert - paste column(s) from clipboard and shift existing content to the right	`Ctrl` + `Shift` + `+` with column(s) in clipboard and column selected
Juggle Rows, Columns, and Cells With cells that are not complete rows/columns - Open insert cell/ row/ column menu	`Ctrl` + `Shift` + `+`
Juggle Rows, Columns, and Cells With cells that are not complete rows/columns - Open delete cell/ row/ column menu	`Ctrl` + `-`
Juggle Rows, Columns, and Cells Fill single cell content down to all cells selected with Shift+Arrow Down	`Shift` + `Arrow Down` , `F2` , then `Ctrl` + `Enter`
Juggle Rows, Columns, and Cells Fill single cell content upto all cells selected with Shift+Arrow Down	`Shift` + `Arrow Up` , `F2` , then `Ctrl` + `Enter`
Edit Cell Content Edit cell. Press Escape to cancel	`F2`
Edit Cell Content Jump to beginning/ end of cell	`Home` / `End`
Edit Cell Content Navigate by one character left/ right or one line up/ down	`Arrow Keys`
Edit Cell Content Navigate by one word left/ right	`Ctrl` + `Arrow Left` / `Arrow Right`
Edit Cell Content Select one character to the left/ right (or one line up/down)	`Shift` + `Arrow Keys`
Edit Cell Content Select from the insertion point to beginning/ end of cell	`Shift` + `Home` / `End`
Edit Cell Content Select or unselect one word to the left/ right	`Ctrl` + `Shift` + `Arrow Left` / `Arrow Right`
Edit Cell Content Delete one character to the right/ left of cursor	`Delete` / `Backspace`
Edit Cell Content Delete from cursor to end of cell	`Ctrl` + `Delete`
Edit Cell Content Start a new line inside cell	`Alt` + `Enter`
Edit Cell Content Complete cell entry and move one cell down/ up	`Enter` / `Shift` + `Enter`
Edit Cell Content Complete cell entry and move one cell right/ left	`Tab` / `Shift` + `Tab`
Edit Cell Content Complete cell entry and don't move selection	`Ctrl` + `Enter`
Edit Cell Content Duplicate value from Cell above into current cell at cursor position	`Ctrl` + `'`
Edit Cell Content Insert current date at cursor position	`Ctrl` + `;`
Edit Cell Content Insert current time at cursor position	`Ctrl` + `Shift` + `;`
Duplicate Cells, Rows, and Columns Fill Down from cell(s) above into current cell(s)	`Ctrl` + `D`
Duplicate Cells, Rows, and Columns Duplicate row via fill down - Fill current row with content from row above.	`Ctrl` + `D` with a row selected
Duplicate Cells, Rows, and Columns Duplicate content of first cell(s) in first row to all cells in selection downward.	`Ctrl` + `D` with multiple empty cells selected
Duplicate Cells, Rows, and Columns Fill Rright from cell(s) on the left into current cell(s)	`Ctrl` + `R`
Duplicate Cells, Rows, and Columns Duplicate column via fill right - Fill current column with content from column on the left.	`Ctrl` + `R` with a column selected
Duplicate Cells, Rows, and Columns Duplicate content first cell(s) in first column to all cells in selection to the right.	`Ctrl` + `D` with multiple empty cells selected
Duplicate Cells, Rows, and Columns Duplicate formula from cell above	`Ctrl` + `'`
Undo, Redo, and Repeat Action Undo	`Ctrl` + `Z`
Undo, Redo, and Repeat Action Redo (after undo) or Repeat (e.g. when applying formats)	`Ctrl` + `Y`
Undo, Redo, and Repeat Action Undo list (via quick access). Use Arrow Down to extend undo range.	`Alt` + `2`
Undo, Redo, and Repeat Action Redo list (via quick access). Use Arrow Down to extend redo range.	`Alt` + `3`
Undo, Redo, and Repeat Action 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	`Alt` + `Enter` outside edit cell mode
Cut, Copy, Paste, and Paste Special Cut cell(s) to clipoard	`Ctrl` + `X`
Cut, Copy, Paste, and Paste Special Copy cell(s) to clipboard	`Ctrl` + `C`
Cut, Copy, Paste, and Paste Special Paste cell(s) from clipboard	`Ctrl` + `V`
Cut, Copy, Paste, and Paste Special Insert Paste - Paste cell and push content downward or rightward. Works great for entire rows and columns.	`Ctrl` + `+`
Cut, Copy, Paste, and Paste Special Open Paste Special Menu (requires a prior copy to Clipboard)	`Ctrl` + `Alt` + `V`
Cut, Copy, Paste, and Paste Special Paste Values	`Ctrl` + `Alt` + `V` , then `V` , `Enter`
Cut, Copy, Paste, and Paste Special Paste Formats	`Ctrl` + `Alt` + `V` , then `T` , `Enter`
Cut, Copy, Paste, and Paste Special Paste Transposed	`Ctrl` + `Alt` + `V` , then `E` , `Enter`
Cut, Copy, Paste, and Paste Special Paste Column Width	`Ctrl` + `Alt` + `V` , then `W` , `Enter`
Cut, Copy, Paste, and Paste Special Paste Values and Number Formats	`Ctrl` + `Alt` + `V` , then `U` , `Enter`
Cut, Copy, Paste, and Paste Special Paste a defined name into a formula	`F3`
Find and Replace Display the Find and Replace dialog box (with find selected)	`Ctrl` + `F`
Find and Replace Display the find and replace dialog box (with replace selected)	`Ctrl` + `H`
Find and Replace Close the find and replace dialog Box (with focus on dialog box)	`Escape`
Find and Replace Find next (with search box closed)	`Shift` + `F4`
Find and Replace Find previous (with search box closed)	`Ctrl` + `Shift` + `F4`
Find and Replace Toggle focus between find/ replace dialog box and worksheet	`Alt` + `Tab` , or `Ctrl` + `F` / `H` when losing focus
Find and Replace Find next with find dialog box active	`Alt` + `F`
Find and Replace Find all with find dialog box active	`Alt` + `I`
Find and Replace Use as asterix for searching multiple characters	* in search option
Find and Replace *Use as wildcard for searching any single character, Use '~' before '?' when searching special characters. ~ searches for * ~~ searches for ~ ~? searches for ?**	? in search options
Manage Worksheet Tabs Move to the next/ previous worksheet in current workbook	`Ctrl` + `Page Down` / `Page Up`
Manage Worksheet Tabs Insert worksheet (Home - Insert Sheet)	`Alt` + `H` , `IS`
Manage Worksheet Tabs Delete worksheet Home - Delete Sheet	`Alt` + `H` , `DS`
Manage Worksheet Tabs Rename worksheet (Home - Format - Rename worksheet)	`Alt` + `H` , `OR`
Manage Worksheet Tabs Move worksheet (Home - Format - Move worksheet)	`Alt` + `H` , `OM`
Manage Worksheet Tabs Worksheet tab color, continue with mouse or arrow keys (Home - Format - Tab color)	`Alt` + `H` , `OT`
Freeze, Split, and Hide View - Freeze or unfreeze; unfreeze works for any Freeze Setting	`Alt` + `W` + `FF`
Freeze, Split, and Hide View - Freeze first visible Row on screen	`Alt` + `W` + `R`
Freeze, Split, and Hide View - Freeze first Column on screen	`Alt` + `W` + `C`
Freeze, Split, and Hide Hide selected rows	`Ctrl` + `9`
Freeze, Split, and Hide Unhide hidden rows within the selection	`Ctrl` + `Shift` + `9`
Freeze, Split, and Hide Hide selected columns	`Ctrl` + `0`
Freeze, Split, and Hide Unhide selected columns (Ctrl+Shift+0 not working in Excel 2010, 2013, or 2016)	`Shift` + `F10` , then `U`
Freeze, Split, and Hide Split or unsplit Worksheet at current position	`Alt` + `W` `S`
Auto Filter Turn Autofilter on or off. Select table as necessary but many times Excel figures out what you want.	`Ctrl` + `Shift` + `L`
Auto Filter On the field with column head, display the AutoFilter list for the current column. Press Escape to cancel	`Alt` + `Arrow Down`
Auto Filter Select the next/ previous item in the AutoFilter list	`Arrow Down` / `Arrow Up` and `S` ace
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`
Column Width and Row Height Home - Format Worksheet	`Alt` + `H` `O`
Column Width and Row Height Set row Height	`H` (in Format Worksheet Menu)
Column Width and Row Height Autofit row height	`A`
Column Width and Row Height Set column Width	`W`
Column Width and Row Height Autofit column width (Based on current cell; mark column if you want to autfit column based on widest cell)	`I`
Column Width and Row Height Set Default width (for all columns that haven't been changed yet)	`D`
Navigate Multi-Cell Selections Move active cell right/ left in selection	`Tab` / `Shift` + `Tab`
Navigate Multi-Cell Selections Move active cell down/ up in selection	`Enter` / `Shift` + `Enter`
Navigate Multi-Cell Selections Select only the active cell when multiple cells are selected	`Shift` + `Backspace`
Navigate Multi-Cell Selections Show active cell within selection; helps with large selections when active cell is off screen	`Ctrl` + `Backspace`
Navigate Multi-Cell Selections Move clockwise between the four courners of a selection	`Ctrl` + `.`
Navigate Multi-Cell Selections Move to the right/ to the left between non-adjacent selections (with multiple ranges selected)	`Ctrl` + `Alt` + `Arrow Right` / `Arrow Left`
Navigate Multi-Cell Selections Cancel Selection	`Arrow Keys` with active Selection
Comments and Hyperlinks Insert or edit hyperlinK (for complete cell only)	`Ctrl` + `K`
Comments and Hyperlinks Remove one or multiple hyperlink(s)	`Shift` + `F10` , then `R`
Comments and Hyperlinks Open hyperlink (In the Excel 2016 Contextmenu, 'O' is double-assigned which require the extra keys)	`Shift` + `F10` , then 2x `O` , then `Enter`
Comments and Hyperlinks Insert/ edit a cell comment	`Shift` + `F2`
Comments and Hyperlinks Move comment	1x `Escape` when in Comment, then `Arrow Keys`
Comments and Hyperlinks Escape comment editing and return to cell	2x `Escape` when in Comment
Comments and Hyperlinks Select all cells with comments	`Ctrl` + `Shift` + `O`
Comments and Hyperlinks Delete single comment (or multipe with multiple comments selected)	`Shift` + `F10` , then `M`
Pivot Tables 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)	`Alt` + `N` `V`
Pivot Tables Refresh PivotTable	`F10` + `R`
Pivot Tables Hide selected item	`Ctrl` + `-`
Pivot Tables Unhide item(s) by opening header drop-down and using Arrow Keys and Space to unhide item	`Alt` + `Arrow Down` in header
Pivot Tables 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 the value hidden
Pivot Tables Flip current field value with the value typed	Type over any field with another field in same table
Pivot Tables Select the entire PivotTable report	`Ctrl` + `Shift` + `*`
Pivot Tables Group selected PivotTable items	`Alt` + `Shift` + `Arrow Right`
Pivot Tables Ungroup selected PivotTable items when on group header	`Alt` + `Shift` + `Arrow Left`
Pivot Tables Expand all fields	`ALT` + `JT` `X`
Pivot Tables Collapse all fields	`ALT` + `JT` `P`
Pivot Tables Insert pivot formula/ calculated field	`Ctrl` + `Shift` + `+`
Pivot Tables Create Pivot Chart in same Worksheet	`Alt` + `F1`
Pivot Tables Create Pivot Chart in new Worksheet	`F1`
Group Rows and Columns Group rows or columns	`Alt` + `Shift` + `Arrow Right`
Group Rows and Columns Ungroup rows or columns	`Alt` + `Shift` + `Arrow Left`
Group Rows and Columns Data Hide detail	`Alt` + `AH`
Group Rows and Columns Data Show Detail (j is next to h on keyboard that’s probably why they picked 'J' isntead of somthing else)	`Alt` + `AJ`
Group Rows and Columns Display or hides the outline symbols	`Ctrl` + `8`
Group Rows and Columns Enter ASCII code, e.g. Alt+0169 inserts © Symbol	`Alt` +ASCII Code
The Rest Minimize/ restore Excel ribbons	`Ctrl` + `F1`
The Rest Display format, chart, totals, tables, and sparklines menus	`Ctrl` after selecting at least 2 rows and 2 columns
The Rest Display the thesaurus dialog box	`Shift` + `F7`
The Rest Display the spelling dialog box	`F7`
The Rest Enable Editing for protected view (File Info Enable Editing)	`Alt` + `F` , `IE`
The Rest Close Excel	`Alt` + `F4`
The Rest Help	`F1`
The Rest Style dialog box	`Alt` + `'`
The Rest Define a name or dialog	`Ctrl` + `F3`
The Rest Create names from row and column labels	`Ctrl` + `Shift` + `F3`
The Rest Create and insert chart with data in current range as embedded Chart Object	`Alt` + `F1`
The Rest Create and insert chart with data in current range in a separate Chart Sheet	`F11`
The Rest Open VBA editor window	`Alt` + `F11`
The Rest Scroll between open workbooks	`Ctrl` + `F6`
The Rest Display macro dialog box	`Alt` + `F8`

Microsoft Excel 2016 (Windows)

Freeze, Split, and Hide

View - Freeze first Column on screen

Alt + W + C

All hotkeys for Microsoft Excel 2016 (Windows)

Select Cells - Basic Selects

Extend selection by one cell

Shift + Arrow Keys

Select Cells - Basic Selects

Extend selection one screen down/ up

Shift + Page Down / Page Up

Select Cells - Basic Selects

Extend selection to next non-blank cell

Ctrl + Shift + Arrow Keys

Select Cells - Basic Selects

Extend selection to beginning of the row (unfortunately, there is no Shift+End equivalent)

Shift + Home

Select Cells - Basic Selects

Select all

Ctrl + A with no data nearby current cell

Select Cells - Basic Selects

Select all cells in data-containing area. Press twice to select everything

Ctrl + A with data nearby current cell

Select Cells - Basic Selects

Extend selection to first cell of the worksheet

Ctrl + Shift + Home

Select Cells - Basic Selects

Extend selection to last used cell on the worksheet (lower-right corner)

Ctrl + Shift + End

Select Cells - Basic Selects

Lock Selection Extend Mode - Select Cell Range, press Shift+F8, move around, add to selection with Shift+Arrow Keys, etc

Shift + F8

Select Cells - Basic Selects

Manual selection by row/ column via GoTo menu. A:B selects column A thru C, 1:3 selects row 1 thru 3 , A1:B3 select cells A1 thru B3, etc

Ctrl + G

Select Cells - Column and Row Selection

Select current row

Shift + Space

Select Cells - Column and Row Selection

Select current row, then expand selection by one row down/ up

Shift + Space , then Shift + Arrow Down / Arrow Up

Select Cells - Column and Row Selection

Select current row, then expand selection by one page down/ up

Shift + Space , then Shift + Page Down / Page Up

Select Cells - Column and Row Selection

Select current column

Ctrl + Space

Select Cells - Column and Row Selection

Select current column, then expand selection by one column right/ left

Shift + Space , then Shift + Arrow Right / Arrow Left

Select Cells - Column and Row Selection

Select current column, then expand selection by one screen right/ left

Shift + Space , then Shift + Alt + Page Down / Page Up

Select Cells - General Cell Format

Copy a cell via Ctrl+C, then via Paste Spacieal, paste format of that cell to current cell

Ctrl + Alt + V , then T and Enter

Select Cells - General Cell Format

Repeat a previous cell format action on current cell

Alt + Enter

Select Cells - General Cell Format

Open Format Cells dialog with last selection active

Ctrl + 1

Select Cells - General Cell Format

Open Format Cells dialog with Font Tab active

Ctrl + Shift + F

Select Cells - Font Face, Font Decoration, and Cell Color

Apply/ remove bold format

Ctrl + B

Select Cells - Font Face, Font Decoration, and Cell Color

Apply/ remove italic format

Ctrl + I

Select Cells - Font Face, Font Decoration, and Cell Color

Apply/ remove underline format

Ctrl + U

Select Cells - Font Face, Font Decoration, and Cell Color

Apply/ remove strikethrough formatting

Ctrl + 5

Select Cells - Font Face, Font Decoration, and Cell Color

Home select Font Face; type font name supported by auto-complete, or use Arrow Down to select.

Alt + H , FF

`Alt` + `W` + `C`

`Shift` + `Arrow Keys`

`Shift` + `Page Down` / `Page Up`

`Ctrl` + `Shift` + `Arrow Keys`

`Shift` + `Home`

`Ctrl` + `A` with no data nearby current cell

`Ctrl` + `A` with data nearby current cell

`Ctrl` + `Shift` + `Home`

`Ctrl` + `Shift` + `End`

`Shift` + `F8`

`Ctrl` + `G`

`Shift` + `Space`

`Shift` + `Space` , then
`Shift` + `Arrow Down` / `Arrow Up`

`Shift` + `Space` , then
`Shift` + `Page Down` / `Page Up`

`Ctrl` + `Space`

`Shift` + `Space` , then
`Shift` + `Arrow Right` / `Arrow Left`

`Shift` + `Space` , then
`Shift` + `Alt` + `Page Down` / `Page Up`

`Ctrl` + `Alt` + `V` , then `T` and `Enter`

`Alt` + `Enter`

`Ctrl` + `1`

`Ctrl` + `Shift` + `F`

`Ctrl` + `B`

`Ctrl` + `I`

`Ctrl` + `U`

`Ctrl` + `5`

`Alt` + `H` , `FF`

`Alt` + `H` , `FS`

`Alt` + `H` , `FC` , `Escape` , `Enter`

`Alt` + `HH` , `Escape` , `Enter`

`Alt` + `HH` , then `N`

`Ctrl` + `Shift` + `~`

`Ctrl` + `Shift` + `1`

`Ctrl` + `Shift` + `2`

`Ctrl` + `Shift` + `3`

`Ctrl` + `Shift` + `4`

`Ctrl` + `Shift` + `5`

`Ctrl` + `Shift` + `6`

`Alt` + `H` , `AL`

`Alt` + `H` , `AR`

`Alt` + `H` , `AC`

`Alt` + `H` , `AT`

`Alt` + `H` , `AM`

`Alt` + `H` , `AB`

`Alt` + `H` , `W`

`Alt` + `H` , `MM`

`Alt` + `H` , `MU`

`Alt` + `H` , `MC`

`Alt` + `H` , `MA`

`Alt` + `H` , `BM`