Freeze Columns in Spreadsheet

How to freeze columns in OpenOffice Spreadsheet?


In OpenOffice Spreadsheet, we have an option to freeze the columns (make the columns static) while scrolling vertically. Use vertical scroll bar to navigate through other data in the spreadsheet.
To Freeze Columns:
Step 1: Select the required column that you want to freeze.
freeze columns openoffice spreadsheet
Step 2: Select Window Freeze or press Alt+W+F
freeze columns openoffice spreadsheet1
Step 3: Column A is freezed as shown below,
freeze columns openoffice spreadsheet2
As we have chosen first column, column A is freezed. If you select 5th column, then first four columns will remain static.

Related Topics