File contains commands that apply to the entire document such as Open, Save, Wizards, Export as PDF, and Digital Signatures.

You can modify the Menu bar, as discussed in Setting up and Customizing Calc. When you choose one of the menus, a submenu appears with other options. When you save a new spreadsheet for the first time, you are prompted to enter a name of your choice. When the spreadsheet is newly created, its name is Untitled X, where X is a number. The Title bar, located at the top, shows the name of the current spreadsheet. It is not always necessary to display all the parts, as shown show or hide any of them, as desired. For example, View > Status Bar will toggle (show or hide) the Status Bar.

This is a handy option for keeping row and column labels visible in spreadsheets.If any part of the Calc window is not shown, you can display it using the View menu. You can also freeze rows and columns much the same with alternative spreadsheet packages such as Excel. That removes the horizontal/vertical freeze lines that were on the spreadsheet. Click Window > Freeze to remove the checkmark beside the option. Having frozen the rows and columns, you can also unfreeze them. All the rows above and columns to the left of those lines remain in view as you scroll across the spreadsheet. Select Window > Freeze and both a horizontal and vertical line will then appear on your spreadsheet as below. Click on a cell that is immediately below the row and just to the right of columns that you’re going to freeze. You can also freeze both rows and columns. All the rows above that line are frozen, and they will stay at the top of the spreadsheet when you scroll down the page. Click on Window and the Freeze option to add a dark line that runs across the spreadsheet as below. To freeze spreadsheet rows, click on the header of the row (its number) directly below where you intend to freeze it.

Now move the scroll bar to the right, and the frozen column remain stationary on the left of the spreadsheet. A dark line should appear on the spreadsheet, as in the shot below, which highlights where you placed the freeze. Then you should click Window and the Freeze option from the menu. Open a OpenOffice spreadsheet, and then click on a column header to the right of where you want to freeze. As such, with the freeze option you can lock a number of rows and columns on the top or left of a spreadsheet.

OpenOffice Calc has an option with which you can freeze selected columns and rows so that they always remain visible, even if you have scrolled some way down or across the spreadsheet. If you have opened a large OpenOffice spreadsheet document, it might be handy to keep some of its rows and columns stationary.

Openoffice calc freeze panes