Share this content

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.


Please login or register to join the discussion.

Dec 15th 2016 16:49

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

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

Thanks (1)
Share this content