Wednesday, March 18, 2009

Scrolling with row Headings Fixed - in Spreadsheet

Was quite happy to learn this tonight :)

Select cell in Excel sheet (OpenOffice calc) and Click on Window > Freeze,
this way you can make the rows below the selected cell scroll beneath it.

1. For Horizontal Freeze - Select only first cell

2. For Horizontal & Vertical Freeze - Select any other cell.

For Reference: http://www.learnopenoffice.org/CalcTutorial13.htm

This page is powered by Blogger. Isn't yours?