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
F2
Edit the cell
F4
Repeat the last command
F11
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
F5
Open the Go To dialog box
Ctrl + F3
Open the Name Manager dialog box
Ctrl + K
Open the Insert Hyperlink dialog box