Shortcuts Keys for Excel


Excel contains many shortcuts that make it easier for you to work, we will learn in this lesson on the most important shortcuts Excel

Ctrl + Home
Go to cell A1

Edit the cell

Repeat the last command

Make a graph of the specific data

Ctrl +;
Include current history

Ctrl + Shift +;
Include current time

Alt + Shift + F1
Insert a new worksheet

Alt + Enter
Go down to a new line in the same cell

Ctrl + A
Select each worksheet

Ctrl + B
Make the text thick

Ctrl + I
Make text italic

Ctrl + U
Make the text underlined

Ctrl + 5
Strike through text

Ctrl + S
save the file

Ctrl + Z
Undo the last operation

Ctrl + Y
Restore the last undo operation

Ctrl + F9
Minimize the window

Ctrl + F10
Maximize the window

Ctrl + Page Down
Move to the next worksheet

Ctrl + Page Up
Move to the previous worksheet

Alt + =
Insert an equation with the SUM function to add all the cells above the current cell

Ctrl + Shift + 1
Format the number as a thousands separator

Ctrl + Shift + 2
Format the number as a time

Ctrl + Shift + 3
Format the number as a date

Ctrl + Shift + 4
Format the number as a currency

Ctrl + Shift + 5
Format the number as a percentage

Ctrl + Shift + 6
Format the number on the scientific form

Ctrl + Space
Select the entire column

Shift + Space
Select the entire row

Shift + F3
Open the Insert Function dialog box

Shift + F5
Open the Find and Replace dialog box

Ctrl + 1
The Format Cells dialog box opens

Ctrl + P
Open the Print dialog box

Open the Go To dialog box

Ctrl + F3
Open the Name Manager dialog box

Ctrl + K
Open the Insert Hyperlink dialog box