EXCEL Opens with Line Above Line 1

%3CLINGO-SUB%20id%3D%22lingo-sub-2289212%22%20slang%3D%22en-US%22%3EEXCEL%20Opens%20with%20Line%20Above%20Line%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2289212%22%20slang%3D%22en-US%22%3E%3CP%3EHelp%20please.%20%26nbsp%3BI%20selected%20some%20EXCEL%20function%20which%20causes%20a%20blank%20workbook%20to%20open%20and%20show%20a%20line%20above%20Line%201.%20%26nbsp%3BI%20think%20the%20line%20is%20called%20Formula%20Builder.%20%26nbsp%3BI%20want%20to%20remove%20it%20and%20just%20have%20the%20workbook%20open%20with%20Line%201%20as%20the%20first%20line.%20%26nbsp%3BWhat%20drop%20down%20function%20do%20I%20use%20to%20change%20this.%20%26nbsp%3B(Even%20more%20strange%2C%20when%20I%20save%20the%20workbook%20and%20then%20reopen%20it%2C%20the%20numbers%20down%20the%20left%20column%20are%20upside%20down.%20%26nbsp%3BOnce%20I%20scroll%20up%20and%20down%20they%20appear%20normal%20again!)%20%26nbsp%3BThank%20you.%20%26nbsp%3BJoe%20Ranney%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2289212%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2290932%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20Opens%20with%20Line%20Above%20Line%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2290932%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1036411%22%20target%3D%22_blank%22%3E%40Winkie123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20mean%20the%20formula%20bar%3F%20Or%20the%20column%20headers%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0348.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F275534i661A20DDC4721914%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0348.png%22%20alt%3D%22S0348.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20hide%20the%20formula%20bar%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESelect%20File%20%26gt%3B%20Options%3C%2FLI%3E%0A%3CLI%3ESelect%20Advanced%3C%2FLI%3E%0A%3CLI%3EScroll%20down%20to%20the%20section%20Display%3C%2FLI%3E%0A%3CLI%3EClear%20the%20check%20box%20'Display%20formula%20bar'%3C%2FLI%3E%0A%3CLI%3EClick%20OK.%3C%2FLI%3E%0A%3CLI%3EThis%20is%20an%20application-wide%20setting%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EIf%20you%20want%20to%20hide%20the%20column%20headers%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESelect%20File%20%26gt%3B%20Options%3C%2FLI%3E%0A%3CLI%3ESelect%20Advanced%3C%2FLI%3E%0A%3CLI%3EScroll%20down%20to%20the%20section%20Display%20options%20for%20this%20worksheet'%3C%2FLI%3E%0A%3CLI%3EClear%20the%20check%20box%20'Show%20row%20and%20column%20headers'%3C%2FLI%3E%0A%3CLI%3EClick%20OK.%3C%2FLI%3E%0A%3CLI%3EThis%20setting%20applies%20to%20the%20selected%20worksheet%20only%3B%20it%20does%20not%20affect%20other%20worksheets%20and%20other%20workbooks%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

3 Replies

@Winkie123 

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

S0348.png

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

@Winkie123 

If you don't want to show formula bar when uncheck this setting

image.png

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/corrupte...]