Split windowsĪnother useful tool to help you view a sheet is the Split Window tool. To revert a row or column back to normal state and remove freezing simply click on the Freeze button. When a row or column in a spreadsheet is frozen the Freeze button is highlighted. To freeze a row and a column at the same time select the cell that is on the bottom row and on the right column and click the Freeze button.
The frozen column will be indicated by a black line on the right. To freeze a column select the column on the right and click the Freeze Button. The frozen row will be indicated by a black line on the bottom. To freeze a row select the row below the one you want to freeze and click the Freeze Button. The example below shows a spreadsheet with the top row frozen.Īnd an example with the first column frozen. When freezing a row or column, it has a fixed position in the window when we scroll horizontally or vertically. Fortunately Calc includes two useful tools to help us view the contents of a spreadsheet with large amount of data that exceed the window width or height. You do not need to select any cells to disable the freeze option.When working with large data it can be difficult to view the information in a spreadsheet. Instead, unfreeze the cells and use the appropriate selection from the first step before attempting to freeze cells again.Ĭlick "Windows" and select the checked "Freeze" option to unfreeze cells. You cannot add rows or columns to an already frozen area. If the "Freeze" option has a check mark next to it, cells are already frozen. As another example, click cell "B4" to freeze the first three rows and the first column.Ĭlick "Windows," then "Freeze" to prevent the rows from scrolling. To freeze both columns and rows, click the cell located just below the rows and to the right of the columns. Alternatively, click the column letter to the right of the columns you want frozen. As an example, to freeze the first three rows, click "4" to highlight the full row. Instead, frozen cells remain static and viewable as you scroll.Ĭlick the row number just below the last row you want frozen. Freezing columns and/or rows prevents these cells from scrolling along with the rest of the sheet. This default behavior makes identifying data more difficult, and it can be easy to make mistakes. When scrolling long spreadsheets in Apache OpenOffice Calc, the column or row headers quickly disappear as you move further down or across the spreadsheet. John Foxx/Stockbyte/Getty Images Related Articles
0 kommentar(er)
