All of you know about excel formulae. These are very useful. It performs different things. It can calculate, find your values...etc. I want to tell you that how can you replace the formula into its value (result). It will show it result without any formula. You can say this tips convert excel formula in value.
Here is the process :
Look at the picture. You want to sum these value. Of course, you will put a formula as shown in the picture. As you put the formula don't press enter or arrow key, Press F9 then press enter or arrow key. This command will replace your formula in its result without any formula.
Here is the process :
Look at the picture. You want to sum these value. Of course, you will put a formula as shown in the picture. As you put the formula don't press enter or arrow key, Press F9 then press enter or arrow key. This command will replace your formula in its result without any formula.
No comments:
Post a Comment