control+A-select all

control+B-bold

control+C-copy

control+D-copy downwards

control+F- find

control+G-goto in particular cell

control+H-find and replace

control+I-italic

control+k-hyperlink

control+l-create list

control+U-underline

control+N-new workbook

control+W-close entire workbook

control+X-cut

control+V-paste

control+Y-redone

control+Z-undo

 

insert comment in cell- Shift+F2

data validation-  alt+D+L

current time-   ctrl+shift+  ;

insert todays date-    ctrl +  ;

conditional formatting-   alt+O+D

current time and date-    =today( ) and other =now( )

Sort the data-  alt+D+S

Filter data-   alt+D+F+F

Subtotal –   alt+D+B

Pivot table-   alt+D+P

Find the no of letters in above word-   =len(text)

find left two letters in above word-    =left(text,2)

find the right two letters-   =right(text,2)

find average-   =avg( )

find the count –   =count( )

protect and hide cell from editing-  alt+T+P+P

Protect sheet names from renaming-  alt+T+P+W

Creating chart-  alt+I+H

Mohammed Azeemulla M S

The mastermind behind ShareDelete is Mohammed Azeemulla M S. A professional blogger from India Bangalore. Who have also developed some of the simple and easy android applications in the play store which you can go ahead and download by searching my name in the play store. You can contact me directly through azeem@sharedelete.com

More Posts - Website

Follow Me:
TwitterFacebook