View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
[email protected] infodex@mindspring.com is offline
external usenet poster
 
Posts: 30
Default Unable to freeze panes

On Sun, 24 Feb 2013 20:29:25 +0100, Claus Busch
wrote:

Hi,

Am Sun, 24 Feb 2013 14:21:14 -0500 schrieb :

I'm missing that freezing requires two steps: One to freeze the top
row, one to freeze the columns.


I was mistaken on this.


to freeze rows and columns is only one step:
Select a single cell and freeze pane - the columns to the left of the
selected cell and the rows above the selected cell will be frozen.
E.g. you select C3: Columns(A:B) and Rows(1:2) will be frozen.



How do you freeze them? The Freeze Pane button has Freeze Row or
Freeze Column but not both.