Excel Freeze pane for select rows and columns

Back

About MrExcel

Consulting Services

Learn Excel Resources

Challenge of the Month

Past Tip of the Day

Roy asks "Can you freeze rows and columns at the same time. Say for instance you
have the following scenario:
Cell B1 Fname
Cell C1 Mname
Cell D1 Lname
Cell E1 Address
Cell A2 Paid
Cell A3 Paid By
Cell A4 Date

Can you freeze this heading going across and down at the same time where
only the data scrolls. Which ever direction I scroll I will lose one set
of the heading. They both will not stay on the screen all the time. NO
ONE ELSE CAN FIGURE IT OUT. "

Select B2, and go to Window, Freeze Panes... Row 1 and Column A should be frozen

By Juan Pablo Gonzalez on 15-Feb-2002

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Excel is a registered trademark of the Microsoft® Corporation.