Wednesday, March 6, 2013

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 :)

No comments: