We are going to learn about advance Excel shortcut keys in this article. These Excel shortcut keys will change your Excel experience.
First, I will talk about the most common Excel shortcut keys, and then you will see advanced Excel shortcut keys discussed in detail.
What are some of the most common Excel shortcuts?
Here are some of the most common Excel shortcuts:
- F2 – Edit cell
- Ctrl+A – Select all
- Ctrl+C – Copy
- Ctrl+V – Paste
- Ctrl+Z – Undo
- Ctrl+Y – Redo
- Home – Move to the beginning of the worksheet
- End – Move to the end of the worksheet
- PgDn – Scroll down one page
- PgUp – Scroll up one page
Microsoft Excel Keyboard shortcut keys
If you want to use Excel very quickly, then it is imperative for you to know the shortcut keys of Excel. Which will provide your personal and official work benefits.
| Shortcut keys | Uses of shortcut keys |
|---|---|
| Shift + F3 | With the help of these keys, you can open the MS Excel formula window |
| Shift + F5 | When you press these keys together it will open the search box |
| Shift + Space | Use these keys together to select the entire row |
| Alt + Shift + F1 | When you wanna insert a new worksheet use these keys together |
| Alt + = | With the help of these keys, you can initiate the formula to add all of the above cells |
| F2 | When you want to edit the selected cell using this key |
| F5 | With the help of this key, you can go to a specific cell |
| F7 | With the help of this key, you can check the spelling of selected text |
| F11 | The F11 key is used to create a chart in MS-Excel |
| Ctrl + Shift +; | With the help of these keys, you can enter the current time |
| Ctrl +; | Use these keys together to enter the current date |
| Ctrl + Space | Use these keys together to select the entire column |
| Ctrl + Tab | With the help of these keys, you can move between two or more open MS Excel files |
| Ctrl + (Right arrow) | With the help of these keys, you can jump on to the next section of text |
| Ctrl + | With the use of these keys together you can insert the value in the current cell from the above cell. |
| Ctrl + F9 | Use these keys to minimize a current window in MS-Excel |
| Ctrl + F10 | Use these keys to maximize the currently selected window in MS-Excel |
| Ctrl + B | When you press these keys together it will bold highlighted selection. |
| Ctrl + F | These keys are used to open find and replace options in MS-Excel |
| Ctrl + G | Use these keys together to open go-to options |
| Ctrl + H | Use these keys to open find and replace options |
| Ctrl + I | These commands are used to Italicize highlighted selections. |
| Ctrl + K | When you want to Insert a link, you can use these keys together |
| Ctrl + N | Use these keys together to open the document in MS-Excel |
| Ctrl + O | Use these keys to open options in MS-Excel |
| Ctrl + P | Use these keys together to open the print dialogue box in MS-Excel |
| Ctrl + U | With the help of these keys, you can underline highlighted text. |
| Ctrl + W | Use these keys together to close the document |
| Ctrl + Y | With the help of these keys, you can underline highlighted text. |
| Ctrl + Z | With the help of these keys, you can undo the last deleted action |
Advance Excel Shortcut Keys
Advance Excel Formulas Shortcut Keys
- Toggle absolute and relative references (in cell edit mode) – F4
- Paste name into formula – F3
- Evaluate part of a formula (in cell edit mode) – F9
- Calculate worksheets – F9
- Accept function with auto-complete – Tab
- Begin entering a formula – = OR +
- Autosum – Alt + =
- Open the Insert Function Dialog Box – Shift + F3
- Calculate active worksheet – Shift + F9
- Open Name Manager – Ctrl + F3
- Toggle displaying formulas on and off – Ctrl + `
- Display function arguments dialog box – Ctrl + A
- Insert function arguments – Ctrl + Shift + A
- Expand or collapse the formula bar – Ctrl + Shift + U
- Create name from values in row(s)/column(s) – Ctrl + Shift + F3
- Enter array formula – Ctrl + Shift + Enter
Advance Formatting Excel Shortcut Keys
If you want to know more details about Formatting shortcut keys in Excel, all the information is given separately.
| Shortcut keys | Formatting Excel Shortcut Keys |
|---|---|
| ( Excel Formatting ) | |
| Ctrl + 1 | Format cells |
| Ctrl + 5 | Apply or remove strikethrough |
| Ctrl + B | Apply or remove bold |
| Ctrl + I | Apply or remove italics |
| Ctrl + U | Apply or remove underscore |
| Ctrl + Shift + F | Display Format Cells with Font tab selected |
| Ctrl + Shift + $ | Apply currency format |
| Ctrl + Shift + % | Apply percentage format |
| Ctrl + Shift + # | Apply date format |
| Ctrl + Shift + @ | Apply time format Ctrl + Shift + @ |
| Ctrl + Shift + ! | Apply number format |
| Ctrl + Shift + ^ | Apply scientific format |
| Ctrl + Shift + ~ | Apply general format |
| Alt + H , 5 | Remove indent |
| Alt + H , 6 | Indent |
| Alt + H , A B | Align bottom |
| Alt + H , A C | Align center |
| Alt + H , F G | Increase font size one step |
| Alt + H , F K | Decrease font size one step |
| Alt + H , A L | Align left |
| Alt + H , A M | Align middle |
| Alt + H , A R | Align right |
| Alt + H , A T | Align top |
| Alt + H , W | Wrap text |
Advance Excel Selection Shortcut Keys
If you want to know more details about selection shortcut keys in Excel, all the information is given separately.
| Selection Shortcut keys | Advance Excel Shortcut Keys |
|---|---|
| Ctrl + A | Select current region if worksheet contains data. Press again to select current region and summary rows. Press again to select entire worksheet. |
| Ctrl + Space | Select entire column |
| Ctrl + Click | Add non-adjacent cells to selection |
| Ctrl + Alt + ← | Move left between non-adjacent selections |
| Esc | Exit ‘Add to Selection’ mode |
| Shift + F8 | Toggle ‘Add to Selection’ mode |
| Shift + Click | Expand selection |
| Shift + Space | Select entire row |
( Select Special ) | ( Shortcut keys ) |
| Ctrl + A | Select current region |
| Ctrl + [ | Select direct precedents |
| Ctrl + ] | Select direct dependents |
| Ctrl + G OR F5 | Display ‘Go To’ dialog box |
| Ctrl + Shift + { | Select all precedents |
| Ctrl + Shift + } | Select all dependents |
| Ctrl + Shift + * | Select current region around active cell |
| Ctrl + Shift + O | Select cells with comments |
| F8 | Toggle ‘Extend Selection’ mode |
| Esc | Cancel ‘Extend Selection’ mode |
| Ctrl + Shift + ← | Extend the selection to the last cell on the left that contains data, or to the next cell that contains data, or to the first column |
| Ctrl + Shift + → | Extend the selection to the last cell on the right that contains data, or to the next cell that contains data, or to the last column |
| Ctrl + Shift + ↑ | Extend the selection to the last cell up that contains data, or to the next cell that contains data, or to the |
| Ctrl + Shift + ↓ | Extend the selection to the last cell down that contains data, or to the next cell that contains data, or to the last row |
| Ctrl + Shift + End | Extend selection to last cell in worksheet |
| Ctrl + Shift + Home | Extend selection to first cell in worksheet |
| Alt + Shift + PgUp | Extend selection left one screen |
| Alt + Shift + PgDn | Extend selection right one screen |
| Shift + Home | Extend selection to start of row(s) |
| Shift + PgDn | Extend selection down one screen |
| Shift + PgUp | Extend selection up one screen |
| Shift + ↑ | Extend selection up |
| Shift + ↓ | Extend selection down |
| Shift + → | Extend selection right |
| Shift + ← | Extend selection left |
Navigation Shortcut Keys
| Navigation Shortcut Keys | Advance Excel Shortcut Keys |
| PgDn | Move one screen down |
| PgUp | Move one screen up PgUp |
| Home | Move to beginning of row |
| End | Turn End mode on |
| Ctrl + Home | Move to first cell in worksheet |
| Alt + PgDn | Move one screen right |
| Alt + PgUp | Move one screen left |
| ↓ | Move one cell down |
| ↑ | Move one cell up |
| ← | Move one cell left |
| → | Move one cell right |
| Ctrl + ↓ | Move to bottom edge of data region |
| Ctrl + ↑ | Move to top edge of data region |
| Ctrl + → | Move to right edge of data region |
| Ctrl + ← | Move to left edge of data region |
Rows and Columns Advance Excel Shortcut Keys
| Rows and Columns | Advance Excel Shortcut Keys |
|---|---|
| Delete contents of selected cells | Delete |
| Hide columns | Ctrl + 0 |
| Hide or show outline symbols | Ctrl + 8 |
| Hide rows | Ctrl + 9 |
| Display Delete dialog box | Ctrl + – |
| Delete selected number of columns | Ctrl + – |
| Delete selected number of rows | Ctrl + – |
| Insert selected number of rows | Ctrl + + |
| Insert selected number of columns | Ctrl + + |
| Display Insert Dialog box | Ctrl + + |
| Unhide rows | Ctrl + Shift + 9 |
| Open Ungroup Dialog Box | Alt + Shift + ← |
| Open Group Dialog Box (no rows/cols selected) | Alt + Shift + → |
| Ungroup rows or columns (with rows/columns selected) | Alt + Shift + ← |
| Group rows or columns (with rows/columns selected) | Alt + Shift + → |
Conclusion
So far, you know about Advance Excel Shortcut keys; if you want to know about All Computer Shortcut Keys then the article on that subject is available on our website.
FAQ:
Q: What is the shortcut key for advance paste?
Ans: Ctrl + Alt + V One can paste the copied content into another program as well.
Q: What is the Ctrl G in Excel?
Ans: Ctrl + G – This shortcut will open the Go To dialog box. This can be used to quickly find and select specific data in your worksheet. For example, if you know the cell address of the data that you want to find, you can use this shortcut to go directly to that cell.
Q: What does F9 do in Excel?
Ans: Calculate formulas in a specific cell or range of cells
