How to Keep Row and Column Labels in View When Scrolling a Worksheet
This is Part 1 in a series of Tutorials focused on the commands of the VIEW Tab of the Ribbon in Excel 2007 and Excel 2010. These same commands and tips will work for all versions of Excel.
I demonstrate how to use the Freeze Panes Commands to Freeze either the Top Row Labels, the First Column Labels or Both.
When you want to freeze more Rows or More Labels, use the Split Bar Commands. Using Split Bars give you addition, independent Navigational Scroll Bars so that you can focus on a specific part of your worksheet.
I invite you to visit my secure online shopping website - http://shop.thecompanyrocks.com - to view all of the resources that I offer.
Danny Rocks
The Company Rocks