By-Pass Password (0)
Use vba for worksheet and software for encrypted file[link]fb:https://m.facebook.com/groups/500526343449980?view=permalink&id=599718343530779&refid=18

A-z without dragging (0)
A-z without dragging =CHAR(64+COLUMN(A1)) or use this one =CHAR(65+ROW(A1)+COLUMN()-2)

Rank for passing (0)
Rank for passing =If(minimum (a2:c2)35,''-'',average (a2:c2)

Get only first digit integer (0)
Get only first digit integer =1+MOD(A1-1,9)

For Bank & IFSC code: India (0)

Get Characters & no's in diff cells (0)
Get uae and no's in diff cells UAE1111111111 =RIGHT(A1,LEN(A1)-FIND(''UAE'',A1)-2)

Keyboard Shortcuts (0)
shift+f3 for case Ctrl+K Insert Hyperlink Ctrl +1 Format dialog box Ctrl +2 bold Ctrl +3 Italic Ctrl +4 Underline Ct