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