Hello fellas here, I am focusing on Microsoft Excel Keyboard shortcuts- A complete list of hot keys. So please read this tutorial carefully so you may comprehend it in a better useful way.
Guide: Microsoft Excel Keyboard shortcuts- A complete list of hot keys
| Ctrl + PgDn | Switch between worksheet tabs, left to right. |
| Ctrl + Page Up | Switch between the tabs in the worksheet, from right to left. |
| Ctrl + Shift + & | Applies the outline border to the selected cells. |
| Ctrl + Shift_ | Removes the border from the outline of the selected cells. |
| Ctrl + Shift + ~ | Apply the general number format. |
| Ctrl + Shift + $ | Apply the Currency format with two decimal places (negative numbers in parentheses). |
| Ctrl + Shift +% | Apply the percentage format without decimals. |
| Ctrl + Shift + ^ | Apply the scientific number format to two decimal places. |
| Ctrl + Shift + # | Apply the date format with the day, month and year. |
| Ctrl + Shift + @ | Apply the time format with the hour and minutes, and AM or PM. |
| Ctrl + Shift +! | Applies the number format with two decimal places, thousands separator, and minus sign (-) for negative values. |
| Ctrl + Shift + * | Selects the current region around the active cell (the data area delimited by blank rows and columns). In a pivot table, select the entire pivot table report. |
| Ctrl + Shift +: | Enter the current time. |
| Ctrl + Shift + “ | Copies the value of the cell over the active cell in the cell or in the formula bar. |
| Ctrl + Shift + Plus (+) | Displays the Insert dialog box for inserting blank cells. |
| Ctrl + Minus (-) | Displays the Delete dialog box to delete the selected cells. |
| Ctrl +; | Enter the current date. |
| Ctrl + ` | Toggles between displaying cell values and displaying formulas in the worksheet. |
| Ctrl + ‘ | Copies a formula from the cell over the active cell in the cell or formula bar. |
| Ctrl + 1 | Displays the Format Cells dialog box. |
| Ctrl + 2 | Apply or remove the bold format. |
| Ctrl + 3 | Apply or remove the italic formatting. |
| Ctrl + 4 | Apply or remove the underline. |
| Ctrl + 5 | Apply or remove strikethrough. |
| Ctrl + 6 | Toggles between hiding and showing objects. |
| Ctrl + 8 | Show or hide outline symbols. |
| Ctrl + 9 | Hide the selected rows. |
| Ctrl + 0 | Hides the selected columns. |
| Ctrl + A | Select the entire worksheet. If the worksheet contains data, Ctrl + A selects the current region. Pressing Ctrl + A a second time selects the entire worksheet. When the insertion point is to the right of a function name in a formula, it displays the Function Arguments dialog box. Ctrl + Shift + A inserts the names of the arguments and parentheses when the insertion point is to the right of the name of a function in a formula. |
| Ctrl + B | Apply or remove the bold format. |
| Ctrl + C | Copy the selected cells. |
| Ctrl + D | Use the Fill Down command to copy the content and formatting of the top cell of a selected range into subsequent cells. |
| Ctrl + E | Add more values to the active column using data surrounding that column. |
| Ctrl + F | Displays the Find and Replace dialog box, with the Find tab selected. Shift + F5 also displays this tab, while Shift + F4 repeats the last Find action. Ctrl + Shift + F opens the Format Cells dialog with the Font tab selected. |
| Ctrl + G | Displays the Go To dialog box. F5 also displays this dialog box. |
| Ctrl + H | Displays the Find and Replace dialog box, with the Replace tab selected. |
| Ctrl + I | Apply or remove the italic formatting. |
| Ctrl + K | Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks. |
| Ctrl + L | Displays the Create Table dialog box. |
| Ctrl + N | Create a new blank book. |
| Ctrl + O | Displays the Open dialog to open or browse for a file. Ctrl + Shift + O selects all cells that contain comments. |
| Ctrl + P | Displays the Print tab in Microsoft Office Backstage view. Ctrl + Shift + P opens the Format Cells dialog with the Font tab selected. |
| Ctrl + Q | Displays the Quick Analysis options for your data when you have cells that contain that selected data. |
| Ctrl + R | Use the Fill Right command to copy the content and formatting of the leftmost cell in a selected range to the cells on the right. |
| Ctrl + S | Saves the active file with its current file name, location, and file format. |
| Ctrl + T | Displays the Create Table dialog box. |
| Ctrl + U | Apply or remove the underline. Ctrl + Shift + U toggles between expanding and collapsing the formula bar. |
| Ctrl + V | Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell content. Ctrl + Alt + V displays the Paste Special dialog. Available only after you have cut or copied an object, text, or cell content in a worksheet or another program. |
| Ctrl + W | Close the selected workbook window. |
| Ctrl + X | Cut selected cells. |
| Ctrl + Y | Repeat the last command or action, if possible. |
| Ctrl + Z | Use the Undo command to revert the last command or to delete the last entry you typed. |
Faq
Guide about Microsoft Excel Keyboard shortcuts- A complete list of hot keys
In this guide, we told you about the Microsoft Excel Keyboard shortcuts- A complete list of hot keys; please read all steps above so that you understand Microsoft Excel Keyboard shortcuts- A complete list of hot keys in case if you need any assistance from us, then contact us.
How this tutorial or guide assisting you?
So in this guide, we discuss the Microsoft Excel Keyboard shortcuts- A complete list of hot keys, which undoubtedly benefits you.
Final note
I hope you like the guide Microsoft Excel Keyboard shortcuts- A complete list of hot keys. In case if you have any queries regards this article/tutorial you may ask us. Also, please share your love by sharing this article with your friends and family. Follow us on Facebook and Twitter if you love our work.
For our visitors: If you have any questions regards the Microsoft Excel Keyboard shortcuts- A complete list of hot keys, then feel free to ask us through the comment section below or directly contact us.
Education: This guide or tutorial is just for educational purposes only.
Misinformation: If you want to correct any misinformation regarding this tutorial “Microsoft Excel Keyboard shortcuts- A complete list of hot keys”, then kindly contact us for the same.
Want to add an alternate method: If anyone wants to add more methods to the guide Microsoft Excel Keyboard shortcuts- A complete list of hot keys, then kindly contact us.
Microsoft Excel Keyboard shortcuts- A complete list of hot keys: advantages guide by trickbugs
- The Microsoft Excel Keyboard shortcuts- A complete list of hot keys tutorial is free for anyone.
- The price of the Microsoft Excel Keyboard shortcuts- A complete list of hot keys guide is free for all our visitors so they learn each tutorial carefully.
Rakesh Chadda 
