Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 63 - 2505_CoreGPT(Podar)_Flipbook_C6
P. 63

    WORKING IN A SPREADSHEET

                     While working with a spreadsheet, you often need to adjust the structure of your worksheet to
                     suit your needs. In LibreOffice Calc, the operations of adding, deleting, hiding and unhiding
                     are key tasks that help to manage and organise your spreadsheet data efficiently.
                     Adding Sheet

                     By default, the LibreOffice Calc spreadsheet opens with one sheet. But, a user can add more
                     sheets if required. To add new sheets in the spreadsheet, follow the given steps:
                     Step 1  Right-click on the Sheet tab.

                     Step 2  Select the Insert Sheet option from the drop-down menu.
                              The Insert Sheet dialog box appears on the screen.

                     Step 3  Select the Position where the new sheet is to be added in the spreadsheet. In our case,
                              we have selected the option After current sheet.
                     Step 4  Enter the No. of sheets.
                     Step 5  Click on the OK button.

                     A new sheet will be added after the current sheet.

                     Deleting Sheet

                     The user can delete unwanted sheet from the spreadsheet. To do so, follow the given steps:
                     Step 1  Right-click on the Sheet tab.
                     Step 2  Select the Delete Sheet option from the context menu.

                              A dialog box appears asking Are you sure you want to delete the selected sheet(s)?
                     Step 3  Click on the Yes button to delete the Selected sheet.

                     The sheet tab gets deleted from the spreadsheet.

                                                                                                    LibreOffice Calc     61

| 58 59 60 61 62 63 64 65 66 67 68 |