Forum Discussion
Winkie123
Apr 25, 2021Copper Contributor
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...
HansVogelaar
Apr 26, 2021MVP
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