Here is a quick tip which might help a lot of you.
So you written a formula and you need to copy it.
You can just select the cell containing the formula, hit Ctrl+C (Copy) then select the cell wher you want to Paste the formula.
Then you need to go to Paste special and select formula only.
This way you only going to copy the formula, but not the cell formatting.
Similarly you can only copy the values of a cell (not the formula that makes that value.) Or the formatting only.
Do you want to know the secret of writing formulas like a pro? Check out this post.
Did you know that we started a facebook page?
Check out ExcelAngel on facebook!