Instructions for Using LibreOffice Calc

LibreOffice'i üldisi teemasid sisaldavatel abilehekülgedel on juhised, mis kehtivad kõikide moodulite kohta, näiteks akende ja menüüde kasutamine, LibreOffice'i kohandamine, andmeallikad, Galerii ja objektide lohistamine.

Kui vajad abi mõne teise mooduli kohta, siis vali vastav moodul navigatsiooniala ülaservas olevast rippmenüüst.

Formatting Tables and Cells

Freezing Rows or Columns as Headers

Highlighting Negative Numbers

Cells in Currency Format

Deactivating Automatic Changes

Formatting Spreadsheets

Applying Automatic Formatting to a Selected Cell Range

Selecting Themes for Sheets

Assigning Formats by Formula

Applying Conditional Formatting

Otsese vorminduse tühistamine dokumendis

Copying to Multiple Sheets

Selecting Multiple Cells

Lahtrite ühendamine ja tükeldamine

Formatting Numbers With Decimals

User-defined Number Formats

Formatting Numbers as Text

Teksti teisendamine arvudeks

Inserting and Editing Comments

Renaming Sheets

Changing Row Height or Column Width

Changing Table Views

Using Rounded Off Numbers

Only Copy Visible Cells

Vorminduse kopeerimine

Reapiiride lisamine lahtritesse

Rotating Text

Writing Multi-line Text

Text Superscript / Subscript

Inserting Special Characters

Changing the Color of Text

Switching Between Insert Mode and Overwrite Mode

Inserting Non-breaking Spaces, Hyphens and Soft Hyphens

Recording Changes

Entering Values and Formulas

Väärtuste sisestamine

Calculating With Formulas

Displaying Formulas or Values

Entering Formulas

Copying Formulas

Arvutamine arvutustabelites

Calculating With Dates and Times

Calculating Time Differences

Entering Fractions

Entering a Number with Leading Zeros

Applying Multiple Sheets

Navigating Through Sheet Tabs

Automatically Filling in Data Based on Adjacent Cells

Applying Sort Lists

Applying Filters

Applying AutoFilter

Filter: Applying Advanced Filters

Only Copy Visible Cells

Entering Matrix Formulas

Rotating Tables (Transposing)

User-Defined Functions

Entering References

Naming Cells

Nimede kasutamine aadressidena

Referencing Cells by Drag-and-Drop

Addresses and References, Absolute and Relative

Referencing URLs

Referencing Other Sheets

Entering Matrix Formulas

Inserting External Data in Table (WebQuery)

Database Ranges in Tables

Defining a Database Range

Filtering Cell Ranges

Sorting Data

Advanced Calculations

Pivot Table

Creating Pivot Tables

Editing Pivot Tables

Liigendtabelite filtreerimine

Updating Pivot Tables

Deleting Pivot Tables

Selecting Pivot Table Output Ranges

Consolidating Data

Applying Goal Seek

Applying Multiple Operations

Validity of Cell Contents

Using Scenarios

Printing and Print Preview

Trükialade määramine arvutustabelis

Printing Sheet Details

Defining Number of Pages for Printing

Printing Sheets in Landscape Format

Printing Rows or Columns on Every Page

Defining Graphics or Colors in the Background of Pages (Watermark)

Importing and Exporting Documents

CSV-tekstifailide avamine ja salvestamine

Importing and Exporting CSV Text Files with Formulas

dBASE-failide importimine ja eksportimine

Saving and Opening Sheets in HTML

Sending Documents as E-mail

Opening documents saved in other formats

Saving Documents in Other Formats


Shortcut Keys (LibreOffice Calc Accessibility)

Sisu asetamine erivormingus

Changing Your Working Directory

Protecting Cells from Changes

Unprotecting Cells

Freezing Rows or Columns as Headers

Inserting and Editing Comments

Rotating Tables (Transposing)

User-Defined Functions

Inserting External Data in Table (WebQuery)

19xx/20xx Years

Inserting, Editing, Saving Bitmaps

Applying Line Styles Using the Toolbar

Defining Line Ends

Defining Line Styles

Recording a Macro