Forum Discussion
Solved
Not Showing Gridlines
When using a spreadsheet and have set it to NOT display any gridlines, when locking the top row, there is a horizontal line that is still visible. How can I get the line to NOT show when locking the...
I think you are out of luck; if you need to freeze the first row, Excel will show the border. It is possible to use the ribbon as an alternative means of control, either with xml or by using an add-in such as
Otherwise you could always format the 'button bar' and pretend you actually wanted the feature!
Thanks for your reply as to what you think Microsoft are or are not willing to do. I would like to get an enhancement request submitted to them to actually follow their own features. In this example when Gridlines are unselected then ALL gridlines or any other lines should not be visible. As far as those who may be confused, we can't control or should speculate on how they may or may not react. It would be great if we as users could actually control what we do and do not see regarding lines.
You can submit your suggestion through File > Feedback > Send a Suggestion in Excel.