How to Freeze a Cell or Column in Excel
For Mac Excel 2011
Open excel Spread sheet, then Select the Layout tab from the toolbar at the top of the screen. Click on the Freeze Panes button and click on the Freeze Top Row option in the popup menu.
For PC office 2010
First off, head over to View tab, click Freeze Top Row to make the row labels appear, when you are scrolling.
Now if you want to freeze first column, Click Freeze First Column, to do the same with the columns.