View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default spreadsheet question

Greg

Follow this simple rule when freezing panes.

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

i.e. select B2 to freeze row 1 and column A


Gord Dibben MS Excel MVP

On 2 Sep 2006 09:07:23 -0700, wrote:

i spoke too soon - by clicking on B1 and 'freeze' i get the left column
(A) to freeze, but now the upper/left-to-right column (1) i cannot get
to freeze as well. in other words, i'd like for both to be frozen at
the same time.

any advice?