Freeze Pane

[informer30]

Hi All,

I have working with ms excel 2007 and I have a top row which i want to freeze as well as a row on the left hand side. I cant manage both at the same time....Please can you advise...

Many Thanks

 

[mltoombs]

I don't know about 2007, but every version prior to this if you put your cursor in cell b2, column A and row 1 will frozen in place.

 

[informer30]

Hi,

I have tried this and this has not worked.....does not freeze both the column and top row just either.

Anyone any ideas?

Many Thanks

 

[GlennUK]

Yes, it does work, you are pressing the wrong buttons in the ribbon. When you click on the Freeze Panes icon, the first button in the drop-down does a simple "Freeze Panes" as mltoombs says ( i.e. have all your worksheet visible, then select cell B2 then do the command ).

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Gruuuu]

http://chandoo.org/wp/2009/06/12/excel-mouse-tricks/

You can double click on the little teeny bar above your vertical scrollbar and right of your horizontal scrollbar.

A couple keyboard shortcuts that I use EXTENSIVELY:
ALT+W,S (Window/Split)
ALT+W,F,F (Window/Freeze Options/Freeze Panes)

Just stick your cursor below and tot he right of the border you want split or frozen.

 

[informer30]

Hi All, I have tried this and this does not work....

my data starts from b1 all the way to z1 and row wise it starts from a2 through to a10...

Please can you advise

Many Thanks

 

[informer30]

Ok that now worked.....recreated the workbook....

Thanks