Freeze Panes exceeds selected area

Whenener i tried to freeze pane of column and row, the excel sheets splits into 4. im unbale to freeze pane more than one column and row. Kindly assist further, tq.
Answer
Answer

Freeze panes freezes the columns to the left of the active cell and the rows above the active cell.

If you just want to freeze rows 1 to 4, put the cursor in A5 first
If you just want to freeze columns A to C, put the cursor in D1 first
If you want to freeze rows 1 to 4 and columns A to C, put the cursor in D5 first.

 


Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk
Microsoft Excel MVP, Oxford, England. www.manville.org.uk

328 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated November 5, 2024 Views 28,642 Applies to: