Start a New Line within the Same Cell

Do you get stuck when it comes to writing multiple lines of data in a single cell?

You can use Alt + Enter to start a fresh new line within the same cell.

Easily Excel at writing multiple lines in the same cell! 

Find the Frequency of Text in the Sheet

Want to count how many times does a particular text appear in your sheet?

1)Select the cell where the text is located

2)Press Ctrl + C (Copy) and then leave C and press F (Find) and then leave F and press V (Paste) - Do all this while Ctrl is pressed

Select and Format the Blank Cells

How do you select all the blank cells in the selected range?

1) Select the range of cells and press F5

2) Click on 'Special', click 'Blanks' and click OK

Calculate Sum Automatically

1. Select the cell immediately below the column of values to be summed.
2. Press Alt + = (Alt and 'Equal to' sign)
3. Excel will automatically write the Sum function and select the numeric range
4. Hit Enter!

Understand how to format your Excel sheet in few easy steps: http://learnexceleasily.blogspot.in//2013/11/quick-formatting-and-beautification.html