View Single Post
  #3   Report Post  
Old September 1st 17, 08:46 AM posted to microsoft.public.excel.misc
jbclem[_3_] jbclem[_3_] is offline
external usenet poster
First recorded activity by ExcelBanter: Aug 2017
Posts: 5
Default how to "freeze panes" for a vertical column?

Thanks, that worked. I had to unfreeze the horizontal rows first, then it
was ok.

"GS" wrote in message news
I've been able to "freeze panes" for horizontal rows, so the column
headings stay in place as I scroll down. But when I also try to "freeze
panes" for vertical columns, so the row headings will stay in place,
after I select the column to freeze, the only choice I have is "unfreeze

Is this because you can't do both horizontal and vertical freezes on the
same spreadsheet. Or is there a different way to accomplish this?

You need to set both at once! So then, to freeze cols/rows at B2 so colA
and row1 do not scroll, select B2 and 'Freeze Panes'!


Free usenet access at
Classic VB Users Regroup!