Shortcuts Keys for Excel

MS EXCEL TUTORIAL URDU

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

Leave a comment

* - Required fields