Multiple Panes in Excel 2003 Spreadsheet XML

Question

I want to generate an excel spreadsheet with three horizontal panes.

Report Header
Report Titles
Report Values

So that the Titles will scroll to the top of the document and then "freeze" while the Values scroll underneath the Titles.

I have been able to setup two panes with the following Worksheet Options:

<FreezePanes/>
<SplitHorizontal>11</SplitHorizontal>
<TopRowBottomPane>11</TopRowBottomPane>
<ActivePane>2</ActivePane>
<Panes>
  <Pane>
    <Number>3</Number>
  </Pane>
  <Pane>
    <Number>2</Number>
  </Pane>
</Panes>

I'm not that experienced with Excel, so I'm not sure if this is possible.

I cannot complain, at least I got a badge out of this. :) – Mr Griever Feb 02 '11 at 18:16 — Mr Griever, Feb 02 '11 at 18:16

score 0 · Accepted Answer · answered Mar 03 '11 at 22:13

0

Sorry to be the bearer of bad news on this one Matt, but no, you can't have 3 or more horizontal or vertical panes. 2 is the max for either - but you could have two horizontal and two vertical on the same sheet.

answered Mar 03 '11 at 22:13

Todd Main

28,951
11
82
146

Hm. Not sure what to make of that information but it's good to know. Thank you for the answer! – Mr Griever Mar 04 '11 at 15:32
@Matt H. - Yeah, I sometimes wish there were 3 panes too. Now what would it take for me to win the bounty? :) – Todd Main Mar 04 '11 at 17:15
Ah, I see. I thought it was automatic with the answer. My apologies, now awarded. – Mr Griever Mar 07 '11 at 16:12

Multiple Panes in Excel 2003 Spreadsheet XML

1 Answers1