Under the menu bar, there are three toolbars available by default. Standard Toolbar – contains frequently used menu such as File, Edit, Data etc., commands as icons such as New Open Save, Send, Print, Print Preview, Cut, Copy, Paste, Sorting, Inserting chart etc.,įormatting Toolbar – contains frequently used text and cell formatting commands as such as changing font style, font size, font colour, alignments, cell formatting etc.,įormula bar – This is a very important element in a spreadsheet. Name box : It display the current cell addressįunction Wizard : It is used to insert function It contains Name box, Function Wizard, Sum button, Function button and Input line (Refer Figure 9.4). Sum button : It is used to quickly insert sum function. Input Line : This is used to show the contents of the current cell. Spreadsheet window also has two sets of scroll bars (1) Vertical Scrollbar and (2) Horizontal Scrollbar (Refer Figure 9.5) It always shows actually what you typed in a cell.

Vertical Scroll bar : It is used to move the screen up and down. 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. Active cell’s column name and row number will be highlighted.

Openoffice calc freeze column