About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store


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

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

By Juan Pablo Gonzalez on 15-Feb-2002 Consulting can be hired to implement this concept, or many other cool applications, with your data. 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.

All contents Copyright 1998-2008 by MrExcel Consulting.