View Single Post
  #2   Report Post  
Old September 1st 17, 07:40 AM posted to microsoft.public.excel.misc
GS[_6_] GS[_6_] is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,109
Default how to "freeze panes" for a vertical column?

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 panes".

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!