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? |
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'! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
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 ... 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'! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
how to "freeze panes" for a vertical column?
Thanks, that worked. I had to unfreeze the horizontal rows first, then it
was ok. Glad to help! Yes, any time you want to change this you must first 'Unfreeze' any existing state then re-apply the 'Freeze' to your new selection. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
how to "freeze panes" for a vertical column?
2017
|
All times are GMT +1. The time now is 01:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com