Rekneark

Generell informasjon og bruk av grensesnittet

Velkommen til hjelp for %PRODUCTNAME Calc
%PRODUCTNAME Calc-funksjonar
Shortcut Keys (%PRODUCTNAME Calc Accessibility)
Shortcut Keys for Spreadsheets
Error Codes in %PRODUCTNAME Calc
Add-in for Programming in %PRODUCTNAME Calc
Instructions for Using %PRODUCTNAME Calc

Kommandoar og menyval

Menyar

Menyar
Fil
Rediger
Vis
Set inn
Format
Verktøy
Vindauge
Data

Verktøylinjer

Verktøylinjer
Formateringslinja
Linja \Eigenskapar for teikneobjekt\
Tekstformateringslinja
Formellinja
Statuslinja
Linja \Førehandsvis sida\
Biletlinja
Verktøylinja
Standardlinje
Tabelldatalinja
Navigasjonslinja for skjema
Verktøylinja for spørjingsutforming
Verktøylinja for skjemautforming

Funksjonstypar og operatorar

Funksjonsvegvisar
Functions by Category
Array Functions
Bit Operation Functions
Database Functions
Date & Time Functions
Financial Functions Part One
Financial Functions Part Two
Financial Functions Part Three
Information Functions
Logical Functions
Mathematical Functions
Statistics Functions
Statistical Functions Part One
Statistical Functions Part Two
Statistical Functions Part Three
Statistical Functions Part Four
Statistical Functions Part Five
Spreadsheet Functions
Text Functions
Add-in Functions
Add-in Functions, List of Analysis Functions Part One
Add-in Functions, List of Analysis Functions Part Two
Operators in %PRODUCTNAME Calc
User-Defined Functions

Opna, lagra, importera og eksportera

Inserting External Data in Table (WebQuery)
Saving and Opening Sheets in HTML
Importing and Exporting Text Files

Formatera

Rotera tekst
Writing Multi-line Text
Formatting Numbers as Text
Text Superscript / Subscript
Changing Row Height or Column Width
Applying Conditional Formatting
Highlighting Negative Numbers
Assigning Formats by Formula
Entering a Number with Leading Zeros
Formatting Spreadsheets
Formatting Numbers With Decimals
Naming Cells
Rotating Tables (Transposing)
Renaming Sheets
19xx/20xx Years
Using Rounded Off Numbers
Cells in Currency Format
Using AutoFormat for Tables
Inserting and Editing Comments
Selecting Themes for Sheets
Entering Fractions

Filtrera og sortera

Applying Filters
Filter: Applying Advanced Filters
Applying AutoFilter
Applying Sort Lists

Skriva ut

Printing Rows or Columns on Every Page
Printing Sheets in Landscape Format
Printing Sheet Details
Defining Number of Pages for Printing

Dataområde

Defining Database Ranges
Filtering Cell Ranges
Sorting Data

Pivot Table

Pivot Table
Creating Pivot Tables
Deleting Pivot Tables
Editing Pivot Tables
Filtering Pivot Tables
Selecting Pivot Table Output Ranges
Updating Pivot Tables

Scenario

Using Scenarios

Referansar

Addresses and References, Absolute and Relative
Referencing a Cell in Another Document
References to Other Sheets and Referencing URLs
Referencing Cells by Drag-and-Drop
Recognizing Names as Addressing

Visa, markera, kopiera

Changing Table Views
Displaying Formulas or Values
Freezing Rows or Columns as Headers
Navigating Through Sheets Tabs
Copying to Multiple Sheets
Only Copy Visible Cells
Selecting Multiple Cells

Formlar og utrekningar

Calculating With Formulas
Copying Formulas
Entering Formulas
Displaying Formulas or Values
Calculating in Spreadsheets
Calculating With Dates and Times
Automatically Calculating Series
Calculating Time Differences
Entering Matrix Formulas

Vern

Protecting Cells from Changes
Unprotecting Cells

Ymse

Deactivating Automatic Changes
Consolidating Data
Applying Goal Seek
Applying Multiple Operations
Applying Multiple Sheets
Validity of Cell Contents