Microsoft Excel shortcut keys, if you want to download Best excel keyboard key then you are at the right place. Here you will find Advanced excel shortcuts key 2022
Microsoft Excel Shortcut Keys
Microsoft Excel is a part of the Office Application
packed. When You can Install Microsoft
Office and installed automatically along with other app such as PowerPoint,
Excel, Word, Access etc.…
When you are using Advanced excel shortcuts key in Excel to increase your
Productivity and reduce your time.
So, find the list of Important and Useful Microsoft Excel shortcut keys as below.
Most useful Best excel keyboard Key
Click to Download Button to download Microsoft Excel shortcut keys Pdf download automatically
Keyboard Shortcut Key |
Action of Command Function |
CTRL + A |
Select All |
CTRL+ B |
Bold all Highlighted Area |
CTRL+ C |
Copy all cells in Highlighted Area |
CTRL+ D |
Fill content of upper cell in Selected cell |
CTRL+ F |
Find in Sheet |
CTRL+ G |
Open “Go TO” dialog box |
CTRL+ H |
Open Find and Replace dialog box |
CTRL+ I |
Italic all Highlighted Area |
CTRL+ K |
“Insert Hyperlink” dialog box |
CTRL+ L |
Insert Table (Office 365) |
CTRL+ N |
Open New worksheet |
CTRL+ O |
Open New file |
CTRL+ P |
Print Command |
CTRL+ S |
Save Open worksheet |
CTRL+ T |
Insert Table |
CTRL+ U |
Underline in cell |
CTRL+ V |
Paste the copy value |
CTRL+ W |
Closes current workbook |
CTRL+ X |
Cut the cell value |
CTRL+ Y |
Repeat Typing |
CTRL+ Z |
Undo last entry |
Excel shortcuts cheat sheet
The Blew given list of Microsoft excel keyboard shortcuts are working of the all Microsoft Office version such as Microsoft Excel 2013, Microsoft Excel 2019 and Office 365 Excel.
The next Microsoft excel keyboard shortcuts are the CTRL key of the Advanced excel shortcuts key 2022 So, you can easy read key by number serious method.
CTRL+ 1 |
Open format cell dialog box |
CTRL+ 2 |
Bolds all cells in the highlighted section |
CTRL+ 3 |
Puts italics all cells in the highlighted section |
CTRL+ 4 |
Underlines all cells in highlighted section. |
CTRL+ 5 |
Puts a strikethrough all cells in the selection. |
CTRL+ 6 |
Show or hides Objects. |
CTRL+ 7 |
Show or hides the Toolbar. |
CTRL+ 8 |
Toggles the outline symbols. |
CTRL+ 9 |
Hides rows. |
CTRL+ 0 |
Hides columns. |
CTRL+ SHIFT+: |
Enters the current time. |
CTRL+; |
Enter the current Date. |
CTRL+ ‘ |
Copies a formula from the above cell |
CTRL+ SHIFT+ “ |
Copies value from above cell |
CTRL+ - |
Deletes the Selected column or row |
CTRL+ SHIFT+ = |
Insert a new column or row |
CTRL+ SHIFT+ - |
Switches between showing Excel formulas or their
values in cells. |
CTRL+ SHIFT+ ! |
Applies comma formatting |
CTRL+ SHIFT+ @ |
Applies time formatting |
CTRL+ SHIFT+ # |
Applies date formatting |
CTRL+ SHIFT+ $ |
Applies currency formatting |
CTRL+ SHIFT+ % |
Applies percentage formatting |
CTRL+ SHIFT+ ^ |
Applies exponential formatting |
CTRL+ SHIFT+ & |
Places border around selected cells. (V. 365) |
CTRL+ SHIFT+ * |
Selects the current region around the active cell |
CTRL+ SHIFT+ ( |
Unhide rows |
CTRL+ SHIFT+ ) |
Unhide Columns |
CTRL+ SHIFT+ _ |
Removes a Border |
CTRL+ + |
Insert dialog box (Num paid Button) |
CTRL+ - |
Delete dialog box (Num paid Button) |
CTRL+ / |
Selects the array containing the active cell |
CTRL+ \ |
Selects the cells that have a static value |
CTRL+ [ |
Selects all cells referenced by formulas in
highlights section |
CTRL+ ] |
Selects all cells that contain formulas that
reference the active cell |
Click Here⇒⇒⇒⇒⇒⇒
Best excel keyboard key
The Blew given list of Microsoft excel keyboard shortcuts are working of the all Microsoft Office version such as Microsoft Excel 2013, Microsoft Excel 2019 and Office 365 Excel.
CTRL+ SHIFT+ | |
Selects cells with a Colum that don’t match |
CTRL+ ENTER |
Fill the selected cells with the current entry |
CTRL+ SPACEABAR |
Selects the entire column |
CTRL+ SHIFT +
SPACEBAR |
Selects the entire column |
CTRL+ Home |
Move to cell A1 |
CTRL+ TAB |
Move between two or more open Excel files |
CTRL+ SHIFT + TAB |
Activates the previous workbook |
CTRL+ SHIFT + A |
Insert argument names into a formula |
CTRL+ SHIFT + F |
Open the drop-down menu for fonts |
CTRL+ SHIFT + O |
Selects all the cells that contain comments |
CTRL+ SHIFT + P |
Open the drop-down menu for point size |
ALT + TAB |
Cycles through application |
ALT + SPACEBAR |
Open the system menu |
ALT + BACKSPACE |
Undo |
ALT + ENTER |
Move to the next line, allowing for multiple line of
text in one cell |
ALT + = |
Create a formatting on a dialog box |
ALT + ‘ |
Allows formatting on a dialog box |
F1 |
Open the help menu |
F2 |
Edits the selected cell |
F3 |
After a name has been created, F3 will paste names |
F4 |
Repeats last action |
F5 |
Goes to a specific cell |
F6 |
Move to the next pane |
F7 |
Spell check selected text or document |
F8 |
Enter Extend Mode |
F9 |
Replace the text |
1 Comments
Nice bro
ReplyDelete