Multiple freezes

PeterBrazel · May 10th, 2002, 07:41 PM

Trying to create a simple database within a sheet with a scroll box in the centre of the screen that views say five records of the database. Can freeze the top part of the sheet for all the headings etc but want to do the same below the displayed data and display some summary calculations there. Can this be done.

Juan Pablo González · May 11th, 2002, 08:59 AM

Mhmmm... how about creating two windows ? you can arrange them to "look" like the bottom is always visible..

PeterBrazel · May 11th, 2002, 03:37 PM

Yes...Thanks......but I was hoping that I could do this thing in the middle of the screen, mainly for visual presentation I suppose. Then I could dress up all sorts of calculations above and below and even on the sides.

Tom Schreiner · May 11th, 2002, 04:51 PM

You could always setup a separate sheet or a separate area on the same sheet to look as you wish by refering to the data you want to present.
Just use borders, formatting, ect...
Would not be difficult.
Tom

May 11th, 2002, 08:59 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Mhmmm... how about creating two windows ? you can arrange them to "look" like the bottom is always visible.. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 07:41 PM	#1
PeterBrazel New Member Join Date: May 2002 Location: Australia Posts: 32	Trying to create a simple database within a sheet with a scroll box in the centre of the screen that views say five records of the database. Can freeze the top part of the sheet for all the headings etc but want to do the same below the displayed data and display some summary calculations there. Can this be done.

May 11th, 2002, 03:37 PM	#3
PeterBrazel New Member Join Date: May 2002 Location: Australia Posts: 32	Yes...Thanks......but I was hoping that I could do this thing in the middle of the screen, mainly for visual presentation I suppose. Then I could dress up all sorts of calculations above and below and even on the sides.

May 11th, 2002, 04:51 PM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	You could always setup a separate sheet or a separate area on the same sheet to look as you wish by refering to the data you want to present. Just use borders, formatting, ect... Would not be difficult. Tom