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 [...]

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 [...]

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.