Hotkeys and shortcuts for Microsoft Excel 2016 (Windows)

(Total 672)

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

Hotkeys and shortcuts for Microsoft Excel 2016 (Windows)

(Total 672)

Shift + Arrow Keys

Select Cells - Basic Selects

Extend selection by one cell

Shift + Page Down / Page Up

Select Cells - Basic Selects

Extend selection one screen down/ up

Ctrl + Shift + Arrow Keys

Select Cells - Basic Selects

Extend selection to next non-blank cell

Shift + Home

Select Cells - Basic Selects

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

Ctrl + A with no data nearby current cell

Select Cells - Basic Selects

Select all

Ctrl + A with data nearby current cell

Select Cells - Basic Selects

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

Ctrl + Shift + Home

Select Cells - Basic Selects

Extend selection to first cell of the worksheet

Ctrl + Shift + End

Select Cells - Basic Selects

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

Shift + F8

Select Cells - Basic Selects

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

Ctrl + G

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

Shift + Space

Select Cells - Column and Row Selection

Select current row

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

Select Cells - Column and Row Selection

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

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

Select Cells - Column and Row Selection

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

Ctrl + Space

Select Cells - Column and Row Selection

Select current column

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

Select Cells - Column and Row Selection

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

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

Select Cells - Column and Row Selection

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

Ctrl + Alt + V , then T and Enter

Select Cells - General Cell Format

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

Alt + Enter

Select Cells - General Cell Format

Repeat a previous cell format action on current cell

Ctrl + 1

Select Cells - General Cell Format

Open Format Cells dialog with last selection active

Ctrl + Shift + F

Select Cells - General Cell Format

Open Format Cells dialog with Font Tab active

Ctrl + B

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

Apply/ remove bold format

Ctrl + I

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

Apply/ remove italic format

Ctrl + U

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

Apply/ remove underline format

Ctrl + 5

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

Apply/ remove strikethrough formatting

Alt + H , FF

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 , FS

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

Home select Font Size; use Arrow Key, then Enter to change size

`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`

`Alt` + `T` (in border menu)

`Alt` + `B`