Forum Discussion
EXCEL Opens with Line Above Line 1
Help please. I selected some EXCEL function which causes a blank workbook to open and show a line above Line 1. I think the line is called Formula Builder. I want to remove it and just have the wo...
Hi Joe,
You can use the Insert button at the left end of the Formulas tab. Otherwise, if entering directly into a cell, you can start typing the name of the function preceded by “ = “ to produce a list of function names.
Additionally, you can right-click in the edit field of the “ Formula Bar” or in a cell & click on “ Insert Function” from an alphabetical list of all functions without producing the Formula Builder.
Other possible causes are that you might be doing the following
• you're going to Insert> Function in order to create your formula, or
• you're clicking the disclosure triangle of the “AutoSum [𝚺]” button on the Standard Toolbar & selecting More Functions...
I hope this helps!
Other than this, if you face any kind of .xls or .xlsx file corruption in Excel you can check out this reference [https://social.technet.microsoft.com/Forums/Lync/en-US/e5692c4a-924d-44a5-985b-7878f3eb26de/corrupted-excel-file-repair?forum=excel]
You can use the Insert button at the left end of the Formulas tab. Otherwise, if entering directly into a cell, you can start typing the name of the function preceded by “ = “ to produce a list of function names.
Additionally, you can right-click in the edit field of the “ Formula Bar” or in a cell & click on “ Insert Function” from an alphabetical list of all functions without producing the Formula Builder.
Other possible causes are that you might be doing the following
• you're going to Insert> Function in order to create your formula, or
• you're clicking the disclosure triangle of the “AutoSum [𝚺]” button on the Standard Toolbar & selecting More Functions...
I hope this helps!
Other than this, if you face any kind of .xls or .xlsx file corruption in Excel you can check out this reference [https://social.technet.microsoft.com/Forums/Lync/en-US/e5692c4a-924d-44a5-985b-7878f3eb26de/corrupted-excel-file-repair?forum=excel]