in

ExcelExcel

250+ Excel Keyboards Shortcuts List for New Excel Users!

Essential Excel Keyboard Shortcuts List for New Users!!

Essential Excel Shortcut

Excel Shortcuts: Microsoft Excel is one of the best Mathematical applications. Using keyboard shortcuts will help you to use Excel more effectively. Here we shared the huge list of 250+ Excel Keyboard Shortcuts for you.

Jump To:

Dialog Box Excel Shortcuts:

Alt

+

F8
Macro Dialog box
Alt

+

To open format style box
Ctrl

+

1
Format cells dialog box
Shift

+

Ctrl

+

F,F
Open the font tab in the format cells dialog box
Ctrl

+

Alt
Displays the paste special dialog box
Ctrl

+

T
Displays the create table dialog box
Shift

+

Ctrl

+

F
Open the format cells dialog box
Esc
Cancel and close the dialog box

Entering Data Excel Shortcuts:

Ctrl

+

Fill the above formula in down
Ctrl

+

Shift

+

:
Insert the current time
Ctrl

+

:
Insert current time
Ctrl

+

;
Insert Current Date
Ctrl

+

R
Fill the Right
Ctrl

+

Y
Redo the last action
Ctrl

+

Del
Deletes the end of the word

File Command Excel Shortcuts:

Shift

+

F11
To Insert a new worksheet
Shift

+

F12
To save the file
Ctrl

+

F12
To open a file
Ctrl

+

Shift

+

F12
To give the Print
Alt

+

Shift

+

F2
To save the File
Ctrl

+

P
To print the file
Ctrl

+

S
To save the file
Ctrl

+

W
To close the file
F12
To save as the file
Ctrl

+

F2
To print the file
PGUP
To page up
PGDN
To page down
Go to up
Go to down
Go to left
Go to right
Tab
Indent
Enter
Go to a new line

Format Excel Shortcuts:

Ctrl

+

X
To cut the value
Ctrl

+

Shift

+

~
To convert into general format
Ctrl

+

Shift

+

#
To convert into date format
Ctrl

+

Shift

+

$
To convert into currency format
Ctrl

+

Shift

+

%
To convert into percent format
Ctrl

+

Shift

+

^
To convert into exponential format
Ctrl

+

Shift

+

F
To open font tab in thr format cells dialog box
Ctrl

+

Shift

+

P
To open font tab in thr format cells dialog box
Ctrl

+

+
To insert the row
Ctrl

+

To delete the row
Ctrl

+

2
To make the font bold
Ctrl

+

3
To make the font itlaic
Ctrl

+

4
To underline the font
Ctrl

+

6
To show and hide objects the view
Alt

+

Enter
To start a new line in the same cell
Ctrl

+

B
To make the font bold
Ctrl

+

U
To underline the font
Ctrl

+

V
To paste the font
Ctrl

+

I
To make the font italic
Ctrl

+

F2
To edit the cell comment
Ctrl

+

Shift

+

!
To comma format
Ctrl

+

Shift

+

1
To format number in comma format
Ctrl

+

Shift

+

4
To format number in currency format
Ctrl

+

Shift

+

3
To format number in date format
Ctrl

+

Shift

+

5
To format number in percent format
Ctrl

+

Shift

+

6
To format number in scientific format
Ctrl

+

Shift

+

2
To format number in time format

Formula Excel Shortcuts:

Shift

+

F3
To Paste the function into the formulae
Ctrl

+

Alt

+

F9
To calculate the worksheet in all open workbook
Alt

+

Shift

+

Shift
To recheck dependent formulae
Ctrl

+

Shift

+

F3
To create the names in the rows and columns
Ctrl

+

Shift

+

A
To insert the argument into the formulae
Ctrl

+

Shift

+

F2
To goto the last position
Ctrl

+

Shift

+

F8
To step out
Ctrl

+

Shift

+

F9
To clear all breakpoints
Ctrl

+

Shift

+

Enter
To enter the formula as the Array formulae
Ctrl

+

Shift

+

U
Toggle/Collapse formulae bar
Alt

+

=
To do sum function
Ctrl

+

`
To display the formulae
Shift

+

F3
To paste the function into the formulae
F3
To repeat the last section
F9
To paste the name into the formulae
F4
To evaluate the past of the formulae
Ctrl

+

To copy the formulae from the above cell

General Excel Shortcuts:

Alt

+

To display auto complete list
Ctrl

+

8
To toggle outline symbols
Ctrl

+

K
To add the hyperlink
Ctrl

+

Z
To undo the last section
Shift

+

F4
To find next
Shift

+

F5
To find the value
Alt

+

F1
To insert chart
Shift

+

F7
To view the object
Shift

+

F8
To add section
Shift

+

F9
Quick Watch
Ctrl

+

F4
To close the window
Ctrl

+

F10
To show right click menu
Alt

+

F4
To close the VBA
Alt

+

F6
To switch between last 2 windows
Alt

+

F11
To close the VBE
Alt

+

Spacebar
Goto system menu
Alt

+

Backspace
To undo the last section
Ctrl

+

E
To export module
Ctrl

+

G
To display Go to dialog box
Ctrl

+

H
To replace the value
Ctrl

+

J
To list properties
Ctrl

+

L
To show call stacks
Ctrl

+

Tab
Goto cycle windows
Ctrl

+

F1
To show/hide the ribbons
Ctrl

+

Shift

+

I
To edit perimeter info
Ctrl

+

Shift

+

J
To edit list constants
Ctrl

+

Shift

+

L
To add/remove the filter
Ctrl

+

Shift

+

J
To edit list constants
Ctrl

+

Shift

+

To group rows or columns
Ctrl

+

Shift

+

To ungroup rows or columns
Alt
To Activate Menu bar
F11
To create a chart
Shift
Hold down shift to display more options
F1
To open Excel Help
F5
To open “Go To” dialog box
F7
To open spell checker box
F10
To Activate Menu bar

Navigation Excel Shortcuts:

Ctrl

+

F7
To move window
Ctrl

+

5
To apply/remove strike through format
Shift

+

F6
To move previous pane
Shift

+

Extend selection left side
Shift

+

Extend selection right side
Shift

+

Extend selection up side
Shift

+

Extend selection down side
Shift

+

Tab
Outdent
Alt

+

Tab
Move to cycle applications
Ctrl

+

Home
Top of the module
Ctrl

+

End
End of the module
Ctrl

+

PGUP
Go to the top procedure in another sheet
Ctrl

+

PGDN
Go to the down procedure in another sheet
Ctrl

+

Go to down till the blank cell
Ctrl

+

Go to up till the blank cell
Ctrl

+

Move one word to left
Ctrl

+

Move one word to right
Shift

+

Enter
Enter to move up

Window Excel Shortcuts:

To start the menu

+

R
Run dialog box

+

M
To minimize all

+

F1
To help

+

E
To open window explorer

+

F
To find files and folder

+

D
To minimize all windows and desktop

+

Del
Cycle through taskbar buttons

+

L
To logoff windows

+

P
To start print manager

+

C
To open control panel

+

V
To start clipboard

+

R
To open Keyboard properties dialog box

+

I
To open mouse propeeties dialog box

+

A
To start accessbility options
Ctrl

+

F

+

F
To find computer
Ctrl

+

F

+

Tab
To quick launch toolbar
Shift

+

+

M
Undo minimize all

Workbook Excel Shortcuts:

Ctrl

+

F5
Restore Window Size
Ctrl

+

F6
Next workbook window
Ctrl

+

F9
To minimize workbook
Ctrl

+

F11
To open VBE
Ctrl

+

O
To open workbook
Ctrl

+

N
To create new workbook
Ctrl

+

Shift

+

F6
Previous Workbook Window
Ctrl

+

Shift

+

F1
To open new worksheet
Ctrl

+

Shift

+

Tab
To activate Previous Workbook

Verdict:

That’s it. We almost covered all essential Excel shotcuts in the article. If we misses any shortcuts or mentioned wrong and then feel free to comment us below.

Article Review
  • Article Explanation
  • Shortcuts Listed
  • Usage of Shortcuts
4.8

Summary

Kindly visit our HomePage for more articles.

Leave a Reply

Your email address will not be published. Required fields are marked *

Loading…

0

Comments

0 comments