In this short tutorial, you will learn an easy way to show formulas in Excel 2016, 2013, 2010 and older versions. Also, you will learn how to print formulas and why sometimes Excel shows a formula, not result, in a cell. Continue reading
by Svetlana Cheusheva, updated on
In this short tutorial, you will learn an easy way to show formulas in Excel 2016, 2013, 2010 and older versions. Also, you will learn how to print formulas and why sometimes Excel shows a formula, not result, in a cell. Continue reading
Table of contents
Comments page 2. Total comments: 52
Hello All,
I want to view the formula across the sheet within the same workbook in excel. Is there any ways to do that?
Hello,
Yes, there are 3 methods to show formulas in cells. Please see here how to display formulas in Excel.
Hope this is what you need.
Good and Helpful
Hello,
Is there anyway to get data from formulae. just like in the pivot table , if we select show details entire data we can view in separate sheet.
i want to compare count for more than 2 excel workbooks whether same count getting in two excel files , if not every time i need to check manually for what is the formula applied(largely on countif formulae).
Please help me out on this.
i have a formula that extract data from a different spreadsheet, so i want to be able to open that spreadsheet by clicking in that cell that has that formula without me having to locate the file in the PC, can anyone help me with that?
eg=Z:\1. Oct 2017\Old\[Total Opex ISP Model BU2018 - Forecast.xlsx]Opex'!O63
so i want to open this spreadsheet by clicking on the formula not going to the Z drive to open the spreadsheet
Hello, Carl,
Please try to press the “Edit Links” button under the Data tab in Excel, choose the necessary workbook in the dialog window and click on the “Open Source” button.
As an alternative, you can use our Find Broken Links tool to fulfill this task. The add-in is a part of our Ultimate Suite for Excel. You can download its fully functional 14-day trial version using this direct link.
Hope this information will be helpful for you.
I want to Print excel sheet with formula and calculated result, both in same time please help. short key if any.
Thanks
You can also use the Formulas bar and select "Show Formulas" button there.
Alternatively use the =FORMULATEXT() formula to show the formula for each field you want to see the formulas for.
To show formulas in all cells press CTRL+` (that little mark is the grave accent mark key). When the formulas are visible, print your worksheet as you normally would. To switch back to showing formula results in all cells, press CTRL+` again.
Hello,
I have a formula in a cell. I want to lock that cell so no one can enter anything else over the formula. However, I want the user to be able to see the formula that is being used for the calculation in that cell. Don't know if it matters, but this will also be a protected worksheet.
Any help would be great. Thanks
=IF(AND(D2>=50,E2>=500000),E2*50%,"No Any discount"),OR(IF(AND(d2<=40,e2<=400000),e2*40%,"No any Discount")
Hi
i have create Discount sheet use this formula,but error this formula
=IF(AND(D2<=40,E2=50,E2>=500000),D2*50%,"Discount Given")
hi
Please help this formula
Hi,
This formula doesn't work because you indicated that two conditions for E2 must be true at the same. I'm afraid it's not possible, since only one values can be true at a time. Try to delete one of them, so the formula would be as:
=IF(AND(D2<=40,E2>=500000),D2*50%,"Discount Given")
In Cell A1 - A5 a simple addition was written in
A6 (=sum(A1-A5) = 15 and on formular bar it show the formula. It was change to show the #15;
My question is how to change it back to show the formula?????
Don
Dear Sir,
main daily excel sheet pa jo data entry kro jo muj display pa show kuray ap ye data aj date main entry kya hai
Ap Excel mein Review bar se Track Changes wali option per click karein. Phir Highlight Changes select karein. Yahan per ap datewise, userwise aur col, row ya fieldwise changes track kar sektey hain
I have formulas in many cells. I print the sheet with row and col. headings displayed. If I have a formula, e.g. =K4/K3 in cell L5, I see the result in L5. I want to display the formula from cell L5 in cell M5 so that I know what the actual formula is when the sheet is printed. I can type the formula into cell L5 as text, but if I happen to add cols. or rows, the actual formula may change and I still have the old formula typed. Is there a way to dynamically display the formula in cell L5 in cell M5?
microsoft excel is something else but other packages are the best
Hi Luccio,
Did you find a solution? I'm going bananas here as well and tracing precedents isn't what I'm looking for either.
Hi,
I have a new version of Excel and pulling my hair as the old "F2" shortcut to visualize precedents on a formula doesn't work anymore. Anyone know what the new way to do this is?
thank you!
Hi Luccio,
To trace precedents, you can use the following shortcut: Alt+T U T
If you are looking for something different, please clarify.
Hi Svetlana,
I have a CSV file of an address book that has fields for Names, Business, & Telephone numbers - the complete number begins with a 0 (zero). When I import this file into Excel, the 0 is dropped. I can manually add the 0 in each cell, but I am sure there is an easier way. Can you assist?
Here is an example: I have the following record:
Name Company Telephone Number
Mahomed Aboo Private 0123014000
When this is imported into Excel it displays as follows:
Name Company Telephone Number
Mahomed Aboo Private 123014000
Thanks
Mahomed
I think if you import the data in a field formatted as text instead of number the 0 will not be dropped.
how can active everything