Forum Discussion
Not Showing Gridlines
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!
I need the top row to be fixed. I keep all my macro buttons on the top row and do not want ANY lines shown unless I activate them myself. If I can't hide the line, how can I change the line color? Regarding the macro buttons, I set the button to "Don't move or size with cells", but when I scroll the page the button moves.
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!
- I'll make that work and let this "beat to death" issue go away. 🙂
Thanks for the help!