More than one sheet by holding the Shift key and To delete the current sheet, select Edit › Sheet › Delete andĬonfirm with Delete Sheets. To rename a sheet, right-click a sheet in the sheet tab and select

Select the sheet names you want to import by holding theĬonfirm with OK to import the sheet names you Sheet names are now displayed in the list. Select the file name and confirm with OK.

If you want to import a sheet from another file, do the following If you want to create a new sheet, make sure the New A dialog opens.ĭecide whether the new sheet should be positioned before or after the Select Insert › Sheet from the main menu. Or at the sources listed in Section 8.10, “For More Information”.

More information and for complete instructions, look at the LibreOffice help This chapter can only introduce some very basic Calc functionality. Its interoperability is constantly ameliorated. PDF documents), and can also read and save files in Microsoft Excelįormat. It provides several exchange formats (including export to By using pivot tables, youĬan combine, analyze or compare larger amounts of data.Īs with the entire LibreOffice suite, Calc can be used across a variety of A formula can manipulate dataįrom other cells to generate a value for the cell in which it is inserted.Ĭalc also allows you to define ranges, filter and sort the data or createsĬharts from the data to present it graphically. SpreadsheetsĬonsist of several sheets, containing cells which can be filled withĮlements like text, numbers, or formulas. 10.1 Creating a New Document 10.2 Using Formatting and Styles in Calc 10.3 Working With Sheets 10.4 Conditional Formatting 10.5 Grouping and Ungrouping Cells 10.6 Freezing Rows or Columns as HeadersĬalc is the LibreOffice spreadsheet and data plotting module.

Libreoffice sheets