Excel Shortcuts
Formatting Keys
| Alt + ‘ | Display the style dialog box | |
| Ctrl + Shift + ~ | General Num. Format | |
| Ctrl + Shift + $ | Currency format | |
| Ctrl + Shift + % | Percentage format | |
| Ctrl + Shift + ! | Comma format | |
| Ctrl + Shift + & | Outline border | |
| Ctrl + Shift + _ | Remove borders | |
| Ctrl + B | Bold | |
| Ctrl + I | Italic | |
| Ctrl + U | Underline | |
| Ctrl + 9 | Hide rows | |
| Ctrl + Shift + 9 | Unhide rows | |
| Ctrl + 0 | Hide columns | |
| Ctrl + Shift + 0 | Unhide columns | |
| Ctrl + 1 | Format Dialog Box | |
| Ctrl + 5 | Strike Through | |
| Shift + Space | Select the entire row | |
| Ctrl + Space | Select the entire column | |
| Ctrl + A | Select the entire worksheet | |
| Ctrl + X/C/V | Cut/copy/paste | |
| Ctrl + D/R | Fills cells down/right | |
| CTRL+SHIFT+* | Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns) | |
| SHIFT+ arrow key | Extend the selection by one cell | |
| CTRL+SHIFT+ arrow key | Extend the selection to the last nonblank cell in the same column or row as the active cell | |
| SHIFT+HOME | Extend the selection to the beginning of the row | |
| CTRL+SHIFT+HOME | Extend the selection to the beginning of the worksheet | |
| CTRL+SHIFT+END | Extend the selection to the last cell used on the worksheet (lower-right corner) |
Windows and Workbook Keys
| Ctrl + F4 | Closes workbook window |
| Alt + F4 | Closes Excel |
| Ctrl + F10 | Maximizes the workbook |
| Ctrl + F9 | Minimizes the workbook |
| Ctrl + F5 | Restore window size |
| F6 | Next pane |
| Shift + F6 | Previous pane |
| Ctrl + F6 | Next window |
| Ctrl + Tab | Next window |
| Shift + F11 | Inserts a new sheet |
| F11 | Create a Quick Chart Sheet |
| Ctrl + S | Saves the workbook |
| F12 | Saves As |
| Ctrl + O | Opens a workbook |
| Ctrl + N | Creates a new workbook |
| Alt + F8 | Macros Dialog Box |
| Alt + F11 | Visual Basic Editor |
| ALT + TAB | Switch between applications |
| CTRL + TAB | Switch between open Excel files |
| CTRL + Page Up/Page Down | Go to previous/next worksheet |
| CTRL + Home/End | Go to the first/last cell of the worksheet |
| CTRL + arrow key | Go to the next empty cell |
Auditing and Calculation Keys
| Ctrl + ‘ ( ~ ) | Toggle formula display |
| Ctrl + [ | Selects cells directly referred to by formulas (Precedent Cells) |
| Ctrl + Shift + { | Selects directly and indirectly referred to cells |
| Ctrl + ] | Selects only cells with formulas that refer directly to the active cell (Dependent Cells) |
| Ctrl + Shift + } | Selects all cells within formulas that directly or indirectly refer to the active cells |
| F9 | Calculate all worksheets |
| Shift + F9 | Calculate worksheet |
| F2 | Toggle cell edit mode |
| SHIFT+BACKSPACE | If multiple cells are selected, select only the active cell |
| SHIFT+PAGE DOWN | Extend the selection down one screen |
| SHIFT+PAGE UP | Extend the selection up one screen |
| CTRL+SHIFT+SPACEBAR | With an object selected, select all objects on a sheet |
| CTRL+6 | Alternate between hiding objects, displaying objects, and displaying placeholders for objects |
| CTRL+7 | Show or hide the Standard toolbar |
To Learn Advanced Excel Whatapp/Call 8422000829. Disount Code WEBSAB501
Home Excel Tutorials Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapter 9 Chapter 10
Keep Learning...