freezing panes

markbarr

New member
Joined
Aug 24, 2013
Messages
7
Reaction score
0
Points
0
Guys

I'm creating a dashboard but I want the top 2 rows frozen

It puts a solid line under the 2nd row to show the cells above are frozen

is there a way of turning this line off as it destroys the appearance of the dashboard

Mark
 

markbarr

New member
Joined
Aug 24, 2013
Messages
7
Reaction score
0
Points
0
NBVC

if its not possible to loose the line is it possible to change its color say to white?

I have worked round it by changing the background color of all cells to the grey color of the line but this is not ideal as its a horrible color

mark
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
I don't think that is possible either. I think it is meant to stand out so that users know, when scrolling down, etc, that they are not at the physical top of the page, and that the headers are "overlapping" row data....
 
Top