Unusual appearance of spreadsheet

[Ragnar Midtskogen]

Hello,

Unusual to me at least.

I am writing a program to automatically break apart some Excel spreadsheet
files and I am looking at some samples.
They have some features I have not seen before in spreadsheets.

One feature is a kind of header section which stays put when you scroll
down. Neat feature, but I am wondering if it interferes with the functioning
of my program.

The other feature, which may be related is the appearance of vertical lines
in the left margin with plus or minus signs at the bottom which allows the
vertical compression or expansion of sections of rows.

Finally, the sections are overlaid with large transparent text "Page NN"
where NN is a page number.

I have searched Excel help files without any hits.

Any help would be appreciated

Ragnar

 

[Kieran]

It appears that you are experienceing the followign excel functions.

1. Freeze panes ( keeps ros/ columns static when scrolling data). Look
in the window menu for the option.
2. Group/outline data - look in the data menu
3. Page Break Preview (look in the view menu)

Hope it helps

 

[RWN]

Or, possibly(?)
1) Split screen
2) Subtotals

 

[Ragnar Midtskogen]

Thank you,

The unusual scrolling was due to Freeze Panes, the lines in the left margin
was due to group and outline.
Mystery solved and new knowledge about Excel gained.

Ragnar