ms excel shortcut keys

There are all basic shortcut and important shortcut.

MS EXCEL

SHORTCUT

Ctrl + A - To select all the worksheet in excel

Ctrl + B . - To bold the font of the word

Ctrl + C -  To copy the text , cell and

workspace

Ctrl + D - To duplicate and fill down the

cell. The fill down mean that if

Any word is type in cell then

the word copy the next

downward cell.

Ctrl + F -  To find the any word

,paragraph or content.

Ctrl + G   - To goto any specific cell

Ctrl + H  - To replace the word

Ctrl + I - To italic(Example = Italic) the

word

Ctrl + K. -  To joined any hyperlink to any

cell

Ctrl + L - To create a table above the

 cell

Ctrl + N.  - To create  the new workbook if

you full fill the current

workbook

Ctrl +  O - To open the worksheet

Ctrl + P -  To print the excel sheet where

work has done

Ctrl + R.  - To fill right side cell

Ctrl +S  - To save the worksheet

Ctrl + U   - To under line the word or

sentence like this (ms excel)

Crtl + v - To paste the copy text

Ctrl + w. - To close the workbook

Ctrl + X - To cut the sentence ir word and

paste

Ctrl + Y -  To Redo

Ctrl + Z   - To undo

Ctrl + F1 -  To show and hide the ribbon

Ctrl + F2 - To print the worksheet

Ctrl + F3. -  To open the excel name

manager  

Ctrl +  F4 - To close the program

Ctrl + F6. - To switch between one

workbook to another

Ctrl + F9  - To minimize thworkrk

Ctrl + Enter  - To fill the data

Alt  + (+) - To sum the numbers in above

the cell.

 Ctrl + 1 -  To Open the Format Cell
Window and work on it

Ctrl +  5. - To Strike through the cell

column or row
Ctrl+9. - the Selected Rows
Ctrl +  Shift( - To  Unhide any hidden Row
Shift+F11 -  To Insert New Workbook
Shift + F2 -  To Insert Comment on the

workbook
Shift+ F3  - To Open the Excel Formula

Window to use the formula
Shift+F5 -  To open the Search Box and

search anything in excel sheet
F1   - for help in any software  Help.

Ctrl + End - To Move to Last Cell With

Content on Worksheet and

work on it
Ctrl + ‘  - To Show The Formula which

you can use on time
Ctrl + '(apostrophe) - To  Insert the value of

above cell
Ctrl +  Enter - To insert the Current Date
Ctrl +  Shift+1 - To change the  Format

Number In comma(,) Format
Ctrl + shift+ ; -  To insert the Current Time in

cell
ctrl + Shift + L - To Filter all the column
Ctrl + 0( Zero) - To Hide the Selected Column
Ctrl + Shift + ) - To unhide the any hidden

Column

Ctrl + F4 - To Close the  current open

Program
Ctrl+F6 - To add Switch between one

workbook to another
Ctrl +  F9 - To Minimize Workbook and

open the another workbook
Ctrl + F10  - To Maximize Workbook to

work on it
Ctrl +  Arrow Key - To Move the  Next Section

of the text
Ctrl + Space - To  Select the entire Column
Shift + Space - To  Select the Entire Row
Ctrl + Page Up - To Move Between one sheet

to another
Ctrl +  Page Down - To  Move Between one

sheet to another

Ctrl + +(plus) - To  Insert New Column and

Row on sheet
Ctrl  + -(minus) - To Delete The Selected

Column and Row.
Ctrl+Home. - To Move to  the first Cell A1

F2   - To changes  the selected cell
F4 - To  Repeat last action which is

used last time
F5  - To Go to specific cell or text
F7 - To  Spell check selected text or

cell
F11 - To Create  The chart from

selected data or cells
F12 - To  Save As in any format and

change properties.

Esc button - To delete the write data on a

cell.

Alt + + - To auto sum between selected

cell

Alt + enter -  This is use To wrap text