Home

BASIC SHORTCUT KEYS
Alt + F File menu options in current program
Alt + E Edit options in current program
F1 Universal help (for all programs)
Ctrl + A Select all text
Ctrl + X Cut selected item
Shift + Del Cut selected item
Ctrl + C Copy selected item
Ctrl + Ins Copy selected item
Ctrl + V Paste
Shift + Ins [...]

Here is the list of all shortcut keys for microsoft excel.. works for MS excel 2003 and MS excel 2007

General

Description
Shortcut Key

New file

Ctrl + N

Open file

Ctrl + O

Save file

Ctrl + S

Move between open workbooks

Ctrl + F6

Close file

Ctrl + F4

Save as

F12

Display the print menu

Ctrl + P

Select whole spreadsheet

Ctrl + A

Select column

Ctrl + Space

Select row

Shift + Space

Undo [...]

Learn Excel ..
Identify Duplicate Cells in Excel using this formula
=IF(MAX(COUNTIF(A1:A10,A1:A10))>1,”Duplicates”,”No Duplicates”)
Just copy this formula on the cells if you have to find all the data’s in a long single column.