Forum Discussion

Winkie123's avatar
Winkie123
Copper Contributor
Apr 25, 2021

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 workbook open with Line 1 as the first line.  What drop down function do I use to change this.  (Even more strange, when I save the workbook and then reopen it, the numbers down the left column are upside down.  Once I scroll up and down they appear normal again!)  Thank you.  Joe Ranney

excel

3 Replies

  • Zorro_OP123's avatar
    Zorro_OP123
    Copper Contributor
    Apr 26, 2021
    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]

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 26, 2021

    Winkie123 

    Do you mean the formula bar? Or the column headers?

    If you want to hide the formula bar:

    • Select File > Options
    • Select Advanced
    • Scroll down to the section Display
    • Clear the check box 'Display formula bar'
    • Click OK.
    • This is an application-wide setting

    If you want to hide the column headers:

    • Select File > Options
    • Select Advanced
    • Scroll down to the section Display options for this worksheet'
    • Clear the check box 'Show row and column headers'
    • Click OK.
    • This setting applies to the selected worksheet only; it does not affect other worksheets and other workbooks

Resources