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...
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