Excel help please (page break thing i think)

Soogs · 10 Apr 2006 at 17:47

hey peeps, just a quick one.
is there a way to split a worksheet into two so that i can have my output info at the top or side of the sheet and my inputs listed down elsewhere.

somthing like this

-----------------------------------------------------------------

top of sheet heading information

-----------------------------------------------------------------

centre of sheet
input data here

this is the space i want to be able to scroll thru

-----------------------------------------------------------------
end of sheet Totalls here

-----------------------------------------------------------------

sorry for the bad example.

i know it can be done but have not idea what the method is called or how to do it... i have had a look thru excel but nothing seems to do it

anyone out there know how to do this?

thanks

Haircut · 10 Apr 2006 at 17:55

Window -> Freeze Panes allows you to mark a section that stays where it us.
Don't think you can mark two separate sections using this though?

Soogs · 10 Apr 2006 at 17:59

Haircut said:
Window -> Freeze Panes allows you to mark a section that stays where it us.
Don't think you can mark two separate sections using this though?

cheers i will give it a shot and post back

Soogs · 10 Apr 2006 at 18:05

nice one

works only as you said but thats perfect.

thanks a million

philip41 · 10 Apr 2006 at 21:45

Just what i was after, Cheers.