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!
You can copy the content to new Excel file.
- I'm sorry, but what does copying the content to a new Excel file have to do with making sure that ALL the gridlines are not showing when locking the top row?
- Check this video: https://www.excelcampus.com/tips/new-window-gridlines-freeze-panes/
- You could always stop using freeze panes if you do not like seeing the visible cues that indicate such panes. If you use Tables, names of the columns then appears in place of the sheet column number (normally represented by a strange sequence of letters so there is much scope for improvement)
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.