Selected sheets will turn to white colour. Multiple sheets can also be selected by clicking the sheet and press the Ctrl button (Ctrl + Click). If you click on another sheet, it will become active and its colour will turn white. Active sheet tab will appear in white colour. When you open a new worksheet, sheet1 is the default active sheet. By default there are 3 sheets “Sheet1”, “Sheet2” and “Sheet3”, (Figure 9.8). Moreover, the contents of an active cell will be displayed in the formula bar.Īt the bottom of the grid of cells are the sheet tabs. Using this visual clue, one can easily identify an active cell. Active cell’s column name and row number will be highlighted. The address of the active cell is displayed in the Name box / Address box. 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. Every cell is thus identified by its unique cell address.Ĭell pointer is a rectangular box which can be moved around the worksheet. For example, the intersection of column B and row 4 makes a cell B4. Each cell has a unique address.Ĭell address is the combination of column heading and row number. Intersection of each row and column makes a box which is called as “Cell”. 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. OpenOffice Calc version 4.1.5 contains 1024 columns ands 10,48,576 rows. and the rows are numbered from 1, 2, 3 …. 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 …. Horizontal Scroll bar : It is used move the screen left and right. Vertical Scroll bar : It is used to move the screen up and down. 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. Input Line : This is used to show the contents of the current cell. Sum button : It is used to quickly insert sum function. 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). 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. Under the menu bar, there are three toolbars available by default. Help – menu lists in-built help features available with OpenOffice. Window – menu shows display options such as New Window, Close Windows, Split and Freeze. Tools – menu contains various tools and functions such as spell check, protect document, insert pictures, macros, etc.,ĭata – menu contains the commands to manipulate data in a spreadsheet such as sort, filter, subtotal, validity etc., Insert – menu contains commands for inserting various calc elements such as cells, columns, rows, functions, charts etc.,įormat – menu contains the commands of various text and cell formatting features. View - menu contains the commands which are used to modify the environment of calc. But, for Calc, some special editing options are available under this menu. Most of the menus are very similar to what you learnt in OpenOffice Writer.įile - menu contains the commands of all file management tasks like, Create a new file, Open an existing file, Close the current file, Save a file, Save a file in another name, print file, Export file etc.Įdit - menu contains the editing commands like, cut, copy, paste, Undo, Redo, Fill etc., Most of the menu items are similar to Writer Edit menu. In the right corner of title bar, (1) minimize, (2) maximize / restore and (3) close control buttons are available.īelow the title bar is the menu bar.

When you save the file, Untitled will change to the name in which you saved. In OpenOffice calc, the default name for the first unsaved worksheet is “Untitled1”. It is used to show the name of the file and name of the application. But, in calc, the grid of cells is the workspace.Īt the top of the window is the “Title Bar”. The workspace of writer is a big blank area. Appearance of the Calc window is very similar to that of the Writer window.

Openoffice ac