Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 1st 17, 01:05 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2017
Posts: 5
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?



  #2   Report Post  
Old September 1st 17, 07:40 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,027
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'!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #3   Report Post  
Old September 1st 17, 08:46 AM posted to microsoft.public.excel.misc
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
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



  #4   Report Post  
Old September 1st 17, 10:07 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,027
Default 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
  #5   Report Post  
Old September 2nd 17, 01:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2017
Posts: 1
Default how to "freeze panes" for a vertical column?

2017


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing "Freeze Panes" sh2195 Excel Worksheet Functions 3 April 11th 12 10:31 PM
Multiple "Freeze Panes" one one worksheet Frustrated Word User[_5_] Setting up and Configuration of Excel 2 November 6th 09 02:34 PM
Print "freeze panes" on succeeding pages? kdhelm Excel Discussion (Misc queries) 8 October 10th 08 12:38 AM
I want to lock row 1 in Excel. Why is "Freeze Panes" grayed out? Fran Z Excel Discussion (Misc queries) 2 January 15th 08 05:46 PM
Excel loses "Freeze Panes" setting Eric Excel Discussion (Misc queries) 1 November 3rd 06 12:21 AM


All times are GMT +1. The time now is 05:40 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017