View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default How do I freeze panes horizontally and vertically at same time



rrusson wrote:
"Sloth" wrote:


when you freeze panes the rows above, and the columns left of the selected
cell are frozen. So to freeze columns A-B and rows 1-3 select C4 and then
select window-freeze panes.



Thanks. I struggled for a half-hour trying to freeze multiple columns and
rows --and I'm a software developer! MS really screwed up on this feature,
IMHO. You should be able to ctrl-click on multiple rows/columns and then
freeze. That would be much more intuitive. A lot of things seemed easier
before "The Ribbon."



try this, press F1, enter the word FREEZE, press enter, click
appropriate link.