Excel 2007 question

[MattR]

Is it possible to have more than one 'freeze pane' within a spreadsheet? By that I mean two seperate horizontal one's, not a vert/horiz.

[mathare]

Not frozen panes, as far as I am aware. But you can split a sheet multiple times - pretty sure of that

[TheOldhamWhisper]

I'm pretty sure the answer to this is No. It simply couldn't work as the sheet would be incapable of repeating rows below the second split which would also be below the first split.

Example: If you freeze/split at Row 5, rows 1 through 4 become static and you can scroll all the way to 65500. If, hypothetically, you try to freeze and split again at row 10, rows 6 through 10 would be static - but the original freeze/split conflicts with this. Any rows below this would also 'belong' to both splits - and that is something beyond any spredsheet.

There may be a 'workaround' but it might take a bit of Mat's wizardry - If you exactly dulicate all data in 2 seperate sheets, you could set up seperate freeze/split points on each sheet. As I don't know what you need the sheets to do, that's about all I can offer - hope it's of some use. :)

[lowe1]

Is it possible to have more than one 'freeze pane' within a spreadsheet? By that I mean two seperate horizontal one's, not a vert/horiz.

Matt

I have a PDF version of excel 2007 for dummies if you want a copy its a very good user guide

PM me your email and will forward on to you

and anyone else who wants a copy

[mathare]

If you split the sheet you get 4 separate scroll panes but Excel puts them in a 2x2 grid so you can have two separate scrollable sections arranged vertically and two horizontally but not 3 vertically, for example.

What are you trying to do Matt?

[MattR]

Matt

I have a PDF version of excel 2007 for dummies if you want a copy its a very good user guide

PM me your email and will forward on to you

and anyone else who wants a copy


Thanks, will do.


If you split the sheet you get 4 separate scroll panes but Excel puts them in a 2x2 grid so you can have two separate scrollable sections arranged vertically and two horizontally but not 3 vertically, for example.

What are you trying to do Matt?


It's mainly for my ease of use. I have four laying systems that are odds dependent and therefore recorded separately. I wanted to have all four on one page of one spreadsheet just to save flicking between sheets. It fits better and is easier to have them two across and then the other two underneath, but naturally as they fill up with selections then they will go further down the page and consequently the bottom two systems will be miles down the page. I could have all four across but this is a pain and also as some systems have more selections than others they will be at varying points down the page meaning it will be a pain to keep shuffling up and down the page. I'll probably have to just accept it needs to be on seperate pages to avoid that but I thought that a double freeze would have been ideal if it was possible.

[MattR]

Matt

I have a PDF version of excel 2007 for dummies if you want a copy its a very good user guide

PM me your email and will forward on to you

and anyone else who wants a copy

Tony, just realised I can't send a pm as I'm not a w2w member. I see you have an email address in your user cp, shall I email you there for it, or failing that maybe one of the mods can give you my email. Thanks

[lowe1]

Matt

use my yahoo one in my user cp ( ive just updated it)