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.
All contents Copyright
1998-2008 by MrExcel Consulting.