Tuesday 10 November 2009

Excel Formatting Tip 9 - Freeze Panes & Prevent Headers from Moving in the Spreadsheet in Excel

Title:
Excel Formatting Tip 9 - Freeze Panes and Prevent Headers from Moving in the Spreadsheet in Excel


Video:


Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to Freeze Panes in Excel. This allows you to keep a header row or column within the spreadsheet always visible when you are scrolling down or across the spreadsheet. This is a great feature of Excel to use when working with large data sets, databases, employee lists, product lists, etc. where you have to do a lot of scrolling but still need to know what every column and row means and contains. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
11/Nov/2009

No comments:

Post a Comment