View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default freeze column and row on same spread sheet

Select B2 and Freeze Panes.

Column A and Row 1 will remain frozen.


Gord Dibben MS Excel MVP

On Tue, 16 Feb 2010 10:20:01 -0800, linda <linda @discussions.microsoft.com
wrote:

freeze column and row on same spread sheet - will only freeze one or the other