N/APosted on - 09/01/2016
I have a presentation due tomorrow but my teammate who is really good at excel is sick. He was handling our excel sheet which we need to present tomorrow. Please teach me how to display cell formulas in excel? What if I need to copy a formula?
Please Teach Me How To Display Cell Formulas In Excel?
It’s very easy to display formulas in excel and even copying it. The first step you should take is to do is click on the cell whose formula you need. Then, instead of looking at the cell, go to the white bar on top just below the file toolbar. There, you will find the formula, which might have numerical values, names of referred cells and some mathematical operators. Keep in mind all formulas start with an “=” sign, otherwise they will not be read as formulas.
Next, click on it and select the formula. Copy it using ctrl+c buttons on keyboard. Now paste it in whichever cell you want, but change the referred cell as required.