Welcome to the %PRODUCTNAME Calc Help %PRODUCTNAME Calc Features 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 Menus File Edit View Insert Format Sheet Data Tools Window Help Toolbars Formatting Bar Drawing Object Properties Bar Text Formatting Bar Formula Bar Status Bar Print Preview Bar Image Bar Tools Bar Standard Bar Table Data Bar Form Navigation Bar Query Design Bar Form Design Toolbar Function Wizard 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 Inserting External Data in Table (WebQuery) Saving and Opening Sheets in HTML Importing and Exporting Text Files Redacting a Spreadsheet Automatic Redaction Rotating Text 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 Applying Filters Applying Advanced Filters Applying AutoFilter Applying Sort Lists Removing Duplicate Values Printing Rows or Columns on Every Page Printing Sheets in Landscape Format Printing Sheet Details Defining Number of Pages for Printing Defining Database Ranges Filtering Cell Ranges Sorting Data Pivot Table Creating Pivot Tables Deleting Pivot Tables Editing Pivot Tables Filtering Pivot Tables Selecting Pivot Table Output Ranges Updating Pivot Tables Pivot Chart Creating Pivot Charts Editing Pivot Charts Filtering Pivot Charts Updating Pivot Charts Deleting Pivot Charts Using Scenarios Using Subtotals Tool 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 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 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 Using Wildcards in Formulas Protecting Cells from Changes Unprotecting Cells Reading and Writing values to Ranges Formatting Borders in Calc with Macros Deactivating Automatic Changes Consolidating Data Applying Goal Seek Using Linear and Non-Linear Solvers Applying Multiple Operations Applying Multiple Sheets Validity of Cell Contents