Search Blog

HOW TO freeze top row in Microsoft Excel (freeze panes)

Most Microsoft excel sheets have column headings as their top rows. It is nice to be able to freeze the column heading row in an excel sheet so it stays visible even when you are scrolling down through the data. Here is how to freeze the top olumn heading row in various versions of Microsoft Excel:-

Excel - 2000/2003
Select the second row (the row below the top row containing column headings)
Click Window -> Freeze Panes. That's it!!

Excel - 2007
Click on 'View' tab, then 'Freeze Panes' and then 'Freeze Top Row'

No comments:

Post a Comment