Forum Discussion
jguymon
Aug 05, 2021Copper Contributor
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...
- Aug 11, 2021
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!
PeterBartholomew1
Aug 11, 2021Silver Contributor
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!
jguymon
Aug 11, 2021Copper Contributor
I'll make that work and let this "beat to death" issue go away. 🙂
Thanks for the help!
Thanks for the help!