Freeze Top Row in MS Excel 2010 and OpenOffice

Doing some data analysis and I felt there is a need to create a top row and "freeze" it using excel 2010. I provided the screenshot above.

To do so:

Select the top row to be "freeze". Go to View --> Freeze Top Row and it works!

What about for openoffice users?

I'm using OpenOffice 3.4.1 and to do so, there is a slight difference:

Select the row below the one you want to freeze (in this case, the second row), then go to Window --> Freeze.

- wong chee tat :)

Why do the column headers show numbers instead of letters? How do I change my column headings so they are back to letters instead of numbers? Excel 2007

I got a call from user asking me why the column in Excel 2007 displayed numbers instead of letters and how to change back?

 A quick googling led me to this:

 

Why do the column headers show numbers instead of letters? How do I change my column headings so they are back to letters instead of numbers?

Change column headings to letters in Excel 2007

1. Click the Office button, and click Excel Options.
2. Click the Formulas category
3. Remove the check mark from 'R1C1 reference style'
   

Change column headings to letters in Excel 2003 and earlier versions

1. Choose Tools > Options and select the General tab.
2. Remove the check mark from 'R1C1 reference style'
   

- wong chee tat :)