Hot links Excel 2016

A list of keyboard shortcuts for restoring laptop's factory settings | Character Codes for HTML

Paste	`⌘`+`V` or `Control`+`V`
Copy	`⌘`+`C` or `Control`+`C`
Clear	`Delete`
Save	`⌘`+`S` or `Control`+`S`
Undo	`⌘`+`Z` or `Control`+`Z`
Redo	`⌘`+`Y` `Control`+`Y` `⌘`+`Shift`+`Z`
Cut	`⌘`+`X` or `Control`+`X`
Bold	`⌘`+`B` or `Control`+`B`
Print	`⌘`+`P` or `Control`+`P`
Open Visual Basic	`Option`+`F11`
Fill Down	`⌘`+`D` or `Control`+`D`
Fill Right	`⌘`+`R` or `Control`+`R`
Insert cells	`Control`+`Shift`+`=`
Delete cells	`⌘`+`‐` or `Control`+`‐`
Calculate all open workbooks	`⌘`+`=` or `F9`
Close window	`⌘`+`W` or `Control`+`W`
Quit Excel	`⌘`+`Q`
Display the Go To dialog box	`Control`+`G` or `F5`
Display the Format Cells dialog box	`⌘`+`1` or `Control`+`1`
Display the Replace dialog box	`Control`+`H` or `⌘`+`Shift`+`H`
Paste Special	`⌘`+`Control`+`V` or `Control`+`Option`+`V` or `⌘`+`Option`+`V`
Underline	`⌘`+`U`
Italic	`⌘`+`I` or `Control`+`I`
New blank workbook	`⌘`+`N` or `Control`+`N`
New workbook from template	`⌘`+`Shift`+`P`
Display the Save As dialog box	`⌘`+`Shift`+`S` or `F12`
Display the Help window	`F1` or `⌘`+`/`
Select All	`⌘`+`A` or `⌘`+`Shift`+`Spacebar`
Add or remove a filter	`⌘`+`Shift`+`F` or `Control`+`Shift`+`L`
Minimize or maximize the ribbon tabs	`⌘`+`Option`+`R`
Display the Open dialog box	`⌘`+`O` or `Control`+`O`
Check spelling	`F7`
Open the thesaurus	`Shift`+`F7`
Display the Formula Builder	`Shift`+`F3`
Open the Define Name dialog box	`⌘`+`F3`
Open the Create names dialog box	`⌘`+`Shift`+`F3`
Insert a new sheet *	`Shift`+`F11`
Print	`⌘`+`P` or `Control`+`P`
Print preview	`⌘`+`P` or `Control`+`P`
Expand or minimize the ribbon	`⌘`+`Option`+`R`
Switch to full screen view	`⌘`+`Control`+`F`
Switch to the next application	`⌘`+`Tab`
Switch to the previous application	`⌘`+`Shift`+`Tab`
Close the active workbook window	`⌘`+`W`
Copy the image of the screen and save it to a Screen Shot file on your desktop.	`⌘`+`Shift`+`3`
Minimize the active window	`Control`+`F9`
Maximize or restore the active window	`Control`+`F10` or `⌘`+`F10`
Hide Excel.	`⌘`+`H`
Move to the next box, option, control, or command	`Tab`
Move to the previous box, option, control, or command	`Shift`+`Tab`
Exit a dialog or cancel an action	`Esc`
Perform the action assigned to the default command button (the button with the bold outline, often the OK button)	`Return`
Cancel the command and close	`Esc`
Move one cell up, down, left, or right	`←→↓↑`+`S`
Move to the edge of the current data region	`⌘`+`←→↓↑`
Move to the beginning of the row Left Arrow	`HOME` On a MacBook, press `FN`+
Move to the beginning of the sheet On a MacBook, press CONTROL + FN +	`Control`+`Home`
Move to the last cell in use on the sheet On a MacBook, press CONTROL + FN + RIGHT ARROW	`Control`+`End`
Move down one screen	`PageDown` On a MacBook, press `Fn`+`↓`
Move up one screen	`PageUp` On a MacBook, press `Fn`+`↑`
Move one screen to the right On a MacBook, press FN + OPTION + DOWN ARROW	`Option`+`PageDown`
Move one screen to the left On a MacBook, press FN + OPTION + UP ARROW	`Option`+`PageUp`
Move to the next sheet in the workbook	`Control`+`PageDown` or `Option`+`→`
Move to the previous sheet in the workbook Left Arrow	`Control`+`PageDown` or `Option`+`←`
Scroll to display the active cell	`Control`+`Delete`
Display the Go To dialog box	`Control`+`G`
Display the Find dialog box	`Control`+`F` or `Shift`+`F5`
Access search (when in a cell or when a cell is selected)	`⌘`+`F`
Move between unlocked cells on a protected sheet Enter data on a sheet	`Tab`
Edit the selected cell	`F2`
Complete a cell entry and move forward in the selection	`Return`
Start a new line in the same cell	`Control`+`Option`+`Return`
Fill the selected cell range with the text that you type	`⌘`+`Return` or `Control`+`Return`
Complete a cell entry and move up in the selection	`Shift`+`Return`
Complete a cell entry and move to the right in the selection	`Tab`
Complete a cell entry and move to the left in the selection	`Shift`+`Tab`
Cancel a cell entry	`Esc`
Delete the character to the left of the insertion point, or delete the selection	`Delete`
Delete text to the end of the line On a MacBook, press CONTROL + FN + DELETE	`Control`+`Delete`
Move one character up, down, left, or right	`←→↓↑`+`S`
Move to the beginning of the line	`Home` On a MacBook, press `Fn`+`←`
Insert a comment	`Shift`+`F2`
Open and edit a cell comment	`Shift`+`F2`
Fill down	`Control`+`D` or `⌘`+`D`
Fill to the right	`Control`+`R` or `⌘`+`R`
Define a name	`Control`+`L`
Edit the selected cell	`F2`
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents	`Delete`
Complete a cell entry	`Return`
Enter a formula as an array formula	`⌘`+`Shift`+`Return` or `Control`+`Shift`+`Return`
Cancel an entry in the cell or formula bar	`Esc`
Display the Formula Builder after you type a valid function name in a formula	`Control`+`A`
Insert a hyperlink	`⌘`+`K` or `Control`+`K`
Edit the active cell and position the insertion point at the end of the line	`Control`+`U`
Open the Formula Builder	`Shift`+`F3`
Calculate the active sheet	`Shift`+`F9`
Display a contextual menu	`Shift`+`F10`
Start a formula	`=`
Toggle the formula reference style between absolute, relative, and mixed	`⌘`+`T` or `F4`
Insert the AutoSum formula	`⌘`+`Shift`+`T`
Enter the date	`Control`+`;`
Enter the time	`⌘`+`;`
Copy the value from the cell above the active cell into the cell or the formula bar	`Control`+`Shift`+`"`
Alternate between displaying cell values and displaying cell formulas	`Control`+`
Copy a formula from the cell above the active cell into the cell or the formula bar	`Control`+`'`
Display the AutoComplete list	`Control`+`Option`+`↓`
Define a name	`Control`+`L`
Open the Smart Lookup pane	`Control`+`Option`+`⌘`+`L`
Edit the selected cell	`F2`
Create a table	`⌘`+`T` or `Control`+`T`
Insert a line break in a cell	`⌘`+`Option`+`Return` or `Control`+`Option`+`Return`
Insert special characters like symbols, including emoji	`Control`+`⌘`+`Spacebar`
Increase font size	`⌘`+`Shift`+`>`
Decrease font size	`⌘`+`Shift`+`<`
Align center	`⌘`+`E`
Align left	`⌘`+`L`
Display the Modify Cell Style dialog box	`⌘`+`Shift`+`L`
Display the Format Cells dialog box	`⌘`+`1`
Apply the general number format	`Control`+`Shift`+`~`
Apply the currency format with two decimal places (negative numbers appear in red with parentheses)	`Control`+`Shift`+`$`
Apply the percentage format with no decimal places	`Control`+`Shift`+`%`
Apply the exponential number format with two decimal places	`Control`+`Shift`+`^`
Apply the date format with the day, month, and year	`Control`+`Shift`+`#`
Apply the time format with the hour and minute, and indicate AM or PM	`Control`+`Shift`+`@`
Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values	`Control`+`Shift`+`!`
Apply the outline border around the selected cells	`⌘`+`Option`+`0`(zero)
Add an outline border to the right of the selection	`⌘`+`Option`+`→`
Add an outline border to the left of the selection Left Arrow	`⌘`+`Option`+`←`
Add an outline border to the top of the selection	`⌘`+`Option`+`↑`
Add an outline border to the bottom of the selection	`⌘`+`Option`+`↓`
Remove outline borders	`⌘`+`Option`+
Apply or remove bold formatting	`⌘`+`B`
Apply or remove italic formatting	`⌘`+`I`
Apply or remove underscoring	`⌘`+`U`
Apply or remove strikethrough formatting	`⌘`+`Shift`+`X`
Hide a column	`⌘`+`)` or `Control`+`)`
Unhide a column	`⌘`+`Shift`+`)` or `Control`+`Shift`+`)`
Hide a row	`⌘`+`(` or `Control`+`(`
Unhide a row	`⌘`+`Shift`+`(` or `Control`+`Shift`+`(`
Edit the active cell	`Control`+`U`
Cancel an entry in the cell or the formula bar	`Esc`
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents	`Delete`
Paste text into the active cell	`⌘`+`V`
Complete a cell entry	`Return`
Give selected cells the current cell's entry	`⌘`+`Return` or `Control`+`Return`
Enter a formula as an array formula	`⌘`+`Shift`+`Return` or `Control`+`Shift`+`Return`
Display the Formula Builder after you type a valid function name in a formula	`Control`+`A`
Extend the selection by one cell	`Shift`+`←→↓↑`
Extend the selection to the last nonblank cell in the same column or row as the active cell	`⌘`+`Shift`+`←→↓↑`
Extend the selection to the beginning of the row On a MacBook, press SHIFT + FN +	`Shift`+`Home`
Extend the selection to the beginning of the sheet On a MacBook, press CONTROL + SHIFT + FN +	`Control`+`Shift`+`Home`
Extend the selection to the last cell used on the sheet (lower-right corner) On a MacBook, press CONTROL + SHIFT + FN + →	`Control`+`Shift`+`End`
Select the entire column	`Control`+`Spacebar`
Select the entire row	`Shift`+`Spacebar`
Select the entire sheet	`⌘`+`A`
Select only visible cells	`⌘`+`Shift`+`*`
Select only the active cell when multiple cells are selected	`Shift`+`Delete`
Extend the selection down one screen On a MacBook, SHIFT + FN + DOWN ARROW	`Shift`+`PageDown`
Extend the selection up one screen On a MacBook, SHIFT + FN + UP ARROW	`Shift`+`PageUp`
Alternate between hiding objects, displaying objects, and displaying placeholders for objects	`Control`+`6`
Turn on the capability to extend a selection by using the arrow keys	`F8`
Add another range of cells to the selection	`Shift`+`F8`
Select the current array, which is the array that the active cell belongs to	`Control`+`/`
Select cells in a row that don't match the valuein the active cell in that row.You must select the row starting with the active cell	`Control`+`\`
Select only cells that are directly referred to by formulas in the selection	`Control`+`Shift`+`[`
Select all cells that are directly or indirectly referred to by formulas in the selection	`Control`+`Shift`+`{`
Select only cells with formulas that refer directly to the active cell	`Control`+`]`
Select all cells with formulas that refer directly or indirectly to the active cell	`Control`+`Shift`+`}`
Copy	`⌘`+`C` or `Control`+`V`
Paste	`⌘`+`V` or `Control`+`V`
Cut	`⌘`+`X` or `Control`+`X`
Clear	`Delete`
Delete the selection	`Control`+`‐`
Undo the last action	`⌘`+`Z`
Hide a column	`⌘`+`)` or `Control`+`)`
Unhide a column	`⌘`+`Shift`+`)` or `Control`+`Shift`+`)`
Hide a row	`⌘`+`(` or `Control`+`(`
Unhide a row	`⌘`+`Shift`+`(` or `Control`+`Shift`+`(`
Move from top to bottom within the selection (down) *	`Return`
Move from bottom to top within the selection (up) *	`Shift`+`Return`
Move from left to right within the selection, or move down one cell if only one column is selected	`Tab`
Move from right to left within the selection, or move up one cell if only one column is selected	`Shift`+`Tab`
Move clockwise to the next corner of the selection	`Control`+`PERIOD`
Group selected cells	`⌘`+`Shift`+`K`
Ungroup selected cells	`⌘`+`Shift`+`J`
Insert a new chart sheet.	`F11`
Cycle through chart object selection	`←→↓↑`+`S`
Open the Sort dialog box	`⌘`+`Shift`+`R`
Add or remove a filter	`⌘`+`Shift`+`F` or `Control`+`Shift`+`L`
Display the Filter list or PivotTable page field pop-up menu for the selected cell	`Option`+`↓`
Display or hide outline symbols	`Control`+`8`
Hide selected rows	`Control`+`9`
Unhide selected rows	`Control`+`Shift`+`(`
Hide selected columns	`Control`+`0`(zero)
Unhide selected columns	`Control`+`Shift`+`)`
Display the Help window	`F1`
Edit the selected cell	`F2`
Insert or edit a cell comment	`Shift`+`F2`
Open the Save dialog	`Option`+`F2`
Open the Formula Builder	`Shift`+`F3`
Open the Define Name dialog	`⌘`+`F3`
Close	`⌘`+`F4`
Display the Go To dialog	`F5`
Display the Find dialog	`Shift`+`F5`
Move to the Search Sheet dialog	`Control`+`F5`
Check spelling	`F7`
Open the thesaurus	`Shift`+`F7` or `Control`+`Option`+`⌘`+`R`
Extend the selection	`F8`
Add to the selection	`Shift`+`F8`
Display the Macro dialog	`Option`+`F8`
Calculate all open workbooks	`F9`
Calculate the active sheet	`Shift`+`F9`
Minimize the active window	`Control`+`F9`
Display a contextual menu, or "right click" menu	`Shift`+`F10`
Maximize or restore the active window	`Control`+`F10` or `⌘`+`F10`
Insert a new chart sheet*	`F11`
Insert a new sheet*	`Shift`+`F11`
Insert an Excel 4.0 macro sheet	`⌘`+`F11`
Open Visual Basic	`Option`+`F11`
Display the Save As dialog	`F12`
Display the Open dialog	`⌘`+`F12`

Search

Site section search

Website test

Hot links Excel 2016