View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson
 
Posts: n/a
Default how do I "freeze" the left hand title column

Select column D and window|freeze Panes.

You could even select D5 and have A:C frozen as well as rows 1:4.

Everything to the left of the selected cell and above that selected cell will be
frozen.



DDAANN wrote:

I want the three left hand columns of my excel worksheet to remain fixed
while I scroll across the remaining 22 columns. How can I do this?


--

Dave Peterson