Prev: Calculating Time Spans
Next: Construct staff pay timesheet
From: sthakur on 23 Apr 2010 06:28

From: John on 23 Apr 2010 07:20
Hi
Select cell B2 then go to Window > Freeze Panes.
HTH
John
"sthakur" <sthakur(a)discussions.microsoft.com> wrote in message
news:40F78122-1E73-4347-85D6-1896A4D2A353(a)microsoft.com...
>

From: dshak on 5 May 2010 14:30
the only way i see in office 07 is to select view on the top ribbon and then
selct the freeze pane icon- this give you only 3 options- the top row, the
top column or unfreeze. thus, i can not select both- only one. How do i get
both the top column and far right row BOTH to freeze in 07?
"John" wrote:

> Hi
> Select cell B2 then go to Window > Freeze Panes.
> HTH
> John
> "sthakur" <sthakur(a)discussions.microsoft.com> wrote in message
> news:40F78122-1E73-4347-85D6-1896A4D2A353(a)microsoft.com...
> >
>
> .
>
From: Bob I on 5 May 2010 15:01
It shows UNfreeze because you have already frozen panes. So click
UNfreeze, then select B2 and then Freeze Panes.

dshak wrote:
> the only way i see in office 07 is to select view on the top ribbon and then
> selct the freeze pane icon- this give you only 3 options- the top row, the
> top column or unfreeze. thus, i can not select both- only one. How do i get
> both the top column and far right row BOTH to freeze in 07?
> "John" wrote:
>
>
>>Hi
>>Select cell B2 then go to Window > Freeze Panes.
>>HTH
>>John
>>"sthakur" <sthakur(a)discussions.microsoft.com> wrote in message
>>news:40F78122-1E73-4347-85D6-1896A4D2A353(a)microsoft.com...
>>
>>.
>>

From: Gord Dibben on 5 May 2010 19:25
To OP, not Bob

What is the "far right row" and "top column"?

Are you confused with rows and columns?

Rows above and columns left of selected cell will remain frozen.


Gord Dibben MS Excel MVP

On Wed, 05 May 2010 14:01:39 -0500, Bob I <birelan(a)yahoo.com> wrote:

>It shows UNfreeze because you have already frozen panes. So click
>UNfreeze, then select B2 and then Freeze Panes.
>
>dshak wrote:
>> the only way i see in office 07 is to select view on the top ribbon and then
>> selct the freeze pane icon- this give you only 3 options- the top row, the
>> top column or unfreeze. thus, i can not select both- only one. How do i get
>> both the top column and far right row BOTH to freeze in 07?
>> "John" wrote:
>>
>>
>>>Hi
>>>Select cell B2 then go to Window > Freeze Panes.
>>>HTH
>>>John
>>>"sthakur" <sthakur(a)discussions.microsoft.com> wrote in message
>>>news:40F78122-1E73-4347-85D6-1896A4D2A353(a)microsoft.com...
>>>
>>>.
>>>

 | 
Pages: 1
Prev: Calculating Time Spans
Next: Construct staff pay timesheet