Page 241 - TP_IT_V1.0_C10_flipbpookl
P. 241
The SortAscMacro macro will be executed and the sorts the numbers in the ascending order.
LINKING DATA AND SHEET
Linking the sheets is done to access data present in the different sheets of the same spreadsheet or in different
spreadsheets. This data is needed for calculation and data analysis. LibreOffice Calc gives you the facility of using data
from multiple sheets at the same time.
Setting up Multiple Sheets
When you open a new spreadsheet, it has a single sheet named as Sheet1, by default. LibreOffice Calc allows you to
add and remove sheet in the spreadsheet according to the requirement. These sheets are managed in the Sheet tab
located at the bottom of the spreadsheet.
Inserting a New Sheet
There are several ways by which you can add a new sheet in the spreadsheet. To insert a sheet, perform the following steps:
Step 1: Select a sheet where you want the sheet to be inserted after it or before it.
Step 2: Click on Sheet Menu and select Insert Sheet option from the Menu bar.
OR
Right-click on the empty area in the Sheet tab and select Insert Sheet option from the context menu.
OR
Click the Add new sheet button in the Sheet tab.
When you add a new sheet by clicking the Add new sheet button in the Sheet tab, then
the new sheet will be inserted at the end of the existing sheets in the Sheet tab.
Electronic Spreadsheet (Advanced) using LibreOffice Calc 239

