Davidahill
Phil Gilbert Toyota
Blogger
Share this content
0
726

Freeze pane ghosted

How do I freeze panes when the Freeze Pane is ghosted

I have a 6 page spreadsheet - one page for each of 5 sales people and a totals page. I want to freeze the pane across the top so I can always see it, but the Freeze Pane tab is ghosted. I am using Excel 2016.

I can freeze panes on other worksheets, but not this one. I suspect it has something to do with the pages all being linked, but would love to knoiw a way around it.

Replies

Please login or register to join the discussion.

avatar
Dec 15th 2016 16:49

I wrote an article earlier this year that details several approaches you can try:

http://www.accountingweb.com/technology/excel/what-to-do-when-the-freeze...

Let me know if you still can't get it resolved, and I'll be glad to try to help you further.

Thanks (1)