Prev: Dynamically reference a cell based on cell content
Next: how do I tabulate data in excel 2003
From: Amber on 13 May 2010 13:41
Can you freeze in two direction in excel, along rows and colums?
From: trip_to_tokyo on 13 May 2010 13:49
EXCEL 2007

Yes, try this.

Click in cell B2 then View / Window group / Freeze Panes / Freeze Panes

Now scroll around and you should find that column A is always present as is
row 1.

If my comments have helped please hit Yes.



"Amber" wrote:

> Can you freeze in two direction in excel, along rows and colums?
From: Luke M on 13 May 2010 13:51
sure. select the cell to the right and below of where you want to freeze,
then pick "freeze pane"

--
Best Regards,

Luke M
"Amber" <Amber(a)discussions.microsoft.com> wrote in message
news:493734FA-30DE-407D-B7E5-4B5F2DA659D5(a)microsoft.com...
> Can you freeze in two direction in excel, along rows and colums?


From: "David Biddulph" groups [at] on 13 May 2010 13:54
Yes. It will freeze everything above or to the left of the selected cell.
If you click in B3, for example, it will freeze rows 1 & 2, and column A.
--
David Biddulph


"Amber" <Amber(a)discussions.microsoft.com> wrote in message
news:493734FA-30DE-407D-B7E5-4B5F2DA659D5(a)microsoft.com...
> Can you freeze in two direction in excel, along rows and colums?


 | 
Pages: 1
Prev: Dynamically reference a cell based on cell content
Next: how do I tabulate data in excel 2003