feeze panes on both sides?

[mart10]

Using Excel 2007
Is it possible to freeze left and right edges? what I want to do is show monthly figures scrolling accross with fixed column data on both side not just the left as traditional freezing does

 

[combo]

Not directly, but it's possible to simulate this with formulas. The idea, with separation of data from the report:
- arrange raw data in a table, name it,
- prepare report sheet,
- add vertical "forms" scrollbar to the report sheet, name linked cell and add it in scrollbar properties (right-click the scrollbar),
- use INDEX formula to pick the data from the data table with scrollbar's linked cell as a component of a row reference.

combo

 

[mart10]

I will have a go thanks, About time MS started doing the simple things with Excel that people need, I see need for this quite regularly!