This is driving me crazy! Freezing columns.....

slyde

New Member
Joined
Aug 27, 2006
Messages
20
Hi guys,

I have a spreadsheet with 3 sheets. For each of these sheets, i want to have the first row (a header row) frozen so when a user scrolls down, row 1 stays visible.

for sheet 1, i highlight row 1 and click Window, then Freeze pane. Everything works out perfectly.

When i do the EXACT SAME THING for sheets 2 and 3, what i get is that the first 9-10 rows all become frozen, not just row 1.

This just makes no sense, but there is nothing i try that can make these rows on sheet 2 and 3 work properly.

Any ideas?
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
Select cell A2 and THEN do freeze panes. Not the entire row. Freeze panes freezes the area(s) above/left of the current selection.
 

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
To show just row one make sure that is visible, select cell A2 and then Window...Freeze Panes

If you select row 1 it will split your page into quarters or something like I think.

Hope it helps.
 

slyde

New Member
Joined
Aug 27, 2006
Messages
20
yup

yup, that did the trick. Thanks i never knew that.

I guess thats how i had gotten sheet 1 to work long ago, but i must have forgotten that rule at some point.

Thanks again.. i was pulling my hair out.... :)
 

Forum statistics

Threads
1,136,926
Messages
5,678,618
Members
419,776
Latest member
mikelowski

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top