Microsoft Excel Shortcut Keys | Advanced excel shortcuts key 2022

 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 | Advanced excel shortcuts key


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

Click Here⇒⇒⇒⇒⇒⇒

Microsoft Excel Shortcut Keys

Excel shortcuts cheat sheet

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.

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⇒⇒⇒⇒⇒⇒                    Microsoft Excel Shortcut Keys

Best excel keyboard key

Advanced excel shortcuts key 2022


The Blew given list of Microsoft excel keyboard shortcuts are working of the all Microsoft Office version such as Microsoft Excel 2013Microsoft 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

Click Here⇒⇒⇒⇒⇒⇒
Microsoft Excel Shortcut Keys
Share this post for the help of other people thanks
Tech For Earn - About Techforearn #techforearning #techforearn #tech and Computer




Post a Comment

2 Comments