open a new worksheet, sheet1 is the default active sheet. Active sheet tab will appear in white colour. If you click on another sheet, it will become active and its colour will turn white. Multiple sheets can also be selected by clicking the sheet and press the Ctrl button (Ctrl + Click) .
Selected sheets will turn to white colour. On the left of the sheet tab, four navigation buttons are used to move between worksheets (Figure . ). Figure .
Calc Sheet tab and Navigation buttons ( ) Move to the First sheet ( ) Move to the previous sheet ( ) Move to Next sheet ( ) Move to the Last sheet Left corner of status bar shows the total count of sheets and the present active sheet number. For example, if the status bar shows sheet / ; refers to the serial number of the current sheet and refers to the total number of sheets available. Each sheet name can be renamed. To rename a sheet, just double-click on the sheet, which will show a small box as shown in Figure .
. Figure. . Rename Sheet dialog box It shows the current name; delete or overwrite the existing name and type a new name; click OK button.
New name will be displayed on the sheet. . . .
Status bar Below the sheet tabs and horizontal scrolling bar is the “Status Bar”. It shows the current status of the worksheet (Refer Figure . ). Sheets count: Displays current serial number of the sheet / total number of sheets available.
Page Style: Displays the page style of the current sheet. To make changes, just double-click on “Default” and it will show you the “Page Style” dialog box, which is used to change the margin, orientation, paper size, inserting header, footer, border style etc., Selection Mode: Displays the selection mode of the current sheet. There are three modes available to select the cells of a worksheet. They are, Standard (STD), Extend (EXT) and Add (ADD).
Unsaved Changes: An asterisk ( * ) symbol indicates that the changes are made in the worksheet but