-------- Original Message -------- From: Margaret To: users@openoffice.apache.org Date: Tue, 23 Jun 2015 14:04:41 +0930
> I have searched everywhere but cant find the instructions on how to > 'freeze ' frames. For example at the beginning of my spreadsheet I > want the first three columns to stay in place while the rest of the > spreadsheet moves so I can go to the next dates without losing my > instructions for that line. Can anyone help me please? regards M > Wing Start Calc and from the main menu select the "Help -> OpenOffice Help" option, or press the keyboard function key F1. This opens the "Help" window. Type: "Freezing Rows or Columns" (without quotes) and press the keyboard Enter key. This will display: "Freezing Rows or Columns as Headers If you have long rows or columns of data that extend beyond the viewable area of the sheet, you can freeze some rows or columns, which allows you to see the frozen columns or rows as you scroll through the rest of the data. 1. Select the row below, or the column to the right of the row or column that you want to be in the frozen region. All rows above, or all columns to the left of the selection are frozen. To freeze both horizontally and vertically, select the cell that is below the row and to the right of the column that you want to freeze. 2. Choose Window - Freeze. To deactivate, choose Window - Freeze again. If the area defined is to be scrollable, apply the Window - Split command." The following web search will return several hundred accurate answers: https://www.google.com/search?q=openoffice%20freeze%20rows&sourceid=groowe&ie=utf-8&oe=utf-8 Dave --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
