Freeze top and bottom panes? (1 Viewer)

O

option

Registered User.

Local time

Today, 11:03

Joined

Jul 3, 2008

Messages

143

• Feb 16, 2009

• #1

Hey guys,

Is it possible to freeze panes at the top and bottom of a sheet? Example: my workbook has its header in cells A1:F1 and that's locked. My data is entered below, and the totals are displayed in B256:F256. Is there a way to keep my header AND my totals frozen so the only thing you scroll through is where you enter data?

 

Brianwarnock

Retired

Local time

Today, 16:03

Joined

Jun 2, 2003

Messages

12,701

• Feb 16, 2009

• #2

That would require 3 panes.

Can you mod the design to repeat the headings over the totals?

Brian

 

qafself

Registered User.

Local time

Today, 16:03

Joined

Nov 9, 2005

Messages

119

• Feb 17, 2009

• #3

As Brian says, put your totals at the top. You can't freeze panes other than at the top.

 

Brianwarnock

Retired

Local time

Today, 16:03

Joined

Jun 2, 2003

Messages

12,701

• Feb 17, 2009

• #4

Thanks for correcting me Ed I said it the wrong way round.

Brian

 

O

option

Registered User.

Local time

Today, 11:03

Joined

Jul 3, 2008

Messages

143

• Feb 18, 2009

• #5

Thanks guys, I took your advice....which lead to a massive overhaul of the design (for the better!) and i love it!

 

qafself

Registered User.

Local time

Today, 16:03

Joined

Nov 9, 2005

Messages

119

• Feb 18, 2009

• #6

Thanks for the feedback - feel free to post again if you have any problems.

 

chergh

blah

Local time

Today, 16:03

Joined

Jun 15, 2004

Messages

1,414

• Feb 18, 2009

• #7

you could have acheived a similar look to what you originally wanted by creating a second workbook and tiling them horizontally on the screen and copying the totals over programatically.

The advice from Brian and Ed to change the design is better, as you have found yourself, but tiling two workbooks would be another option.