Horizontal Scroll bar : It is used move the screen left and right. Scroll buttons : used to move the screen to the relative distance.īelow the formula bar contains the worksheet of work area which consit of grid cells The worksheet has number of rows and columns, where each column is labelled as A, B, C, D …. and the rows are numbered from 1, 2, 3 ….

OpenOffice Calc version 4.1.5 contains 1024 columns ands 10,48,576 rows. Column heading starts from A and end with AMJ. In the case of Microsoft Excel 2016, there are 16,384 columns ( A to XFD) and 10,48,576 rows. Intersection of each row and column makes a box which is called as “Cell”. Each cell has a unique address.Ĭell address is the combination of column heading and row number. For example, the intersection of column B and row 4 makes a cell B4. Every cell is thus identified by its unique cell address.Ĭell pointer is a rectangular box which can be moved around the worksheet. The cell in which the cell pointer is currently located is known as “Active cell”. When you type anycontent, it will appear in the active cell. The address of the active cell is displayed in the Name box / Address box. To print one or more header rows on each page when printing, see Printing rows or columns on every page and Using print ranges.Active cell’s column name and row number will be highlighted.

The checkmark by Freeze will vanish.įreezing cells changes the way that the cells are displayed on the screen. To unfreeze rows or columns, select Window > Freeze. Now as you scroll around the screen everything above and to the left of these lines will remain in view. You will see two lines appear on the screen, a horizontal line above this cell and a vertical line to the left of this cell. Click into the cell that is immediately below the row you want frozen and immediately to the right of the column you want frozen.Click on the header for the row below where you want the freeze or for the column to the right of where you want the freeze.Ī dark line will appear to indicate where the freeze is put.

You can set the freeze point at one row, one column, or both a row and a column as in Figure 10.

Openoffice calc freeze column