LibreOffice Writer & Calc – Advanced Formatting, Collaboration and Data-Analysis

Styles in LibreOffice Writer

LibreOffice Writer lets you package formatting instructions into reusable entities known as styles, vastly accelerating document layout and enforcing consistency. They are central to professional document creation and efficient workflow.

Concept and Rationale

A style is a predefined collection of formatting attributes (e.g., font type, size, colour, line spacing, paragraph indents, borders, shading, language, tab stops). Applying a style means applying this entire group of settings in one single step, rather than manually applying each attribute individually. This provides numerous advantages:

• Speed: Drastically reduces the time spent on formatting.

• Accuracy & Consistency: Ensures a uniform look and feel throughout the document, maintaining brand identity or academic standards.

• Effortless Global Editing: Changes to a style propagate automatically to all text formatted with that style, allowing for document-wide revisions in seconds.

• Automatic Updating of Derived Elements: Essential for generating automatic elements like a Table of Contents or an indexing bibliography, which rely on defined paragraph styles to identify headings and entries.

Style Categories

LibreOffice Writer organizes styles into several distinct categories, each controlling a specific aspect of document formatting:

1. Paragraph Styles

   • Control the complete appearance of a paragraph, including alignment (left, right, center, justified), indents, tab stops, line spacing, text flow (e.g., keeping lines together), borders, shading, font settings, and even the next paragraph's style (useful for headings followed by body text).

   • Examples: Heading 1, Body Text, List 1, Footnote.

2. Character Styles

   • Applied to selected runs of text (words or phrases) within a paragraph, overriding specific attributes of the paragraph style without changing the entire paragraph.

   • Examples: Bold, Emphasis, Source Text (for code snippets), Hyperlink.

3. Frame Styles

   • Govern the layout and appearance of text frames and graphic frames, controlling attributes like text-wrap (how text flows around the frame), borders, backgrounds, columns within the frame, and position.

   • Useful for sidebars, image captions, or pull quotes.

4. Page Styles

   • Determine the design of an entire page, including page size (e.g., A4, Letter), margins, header and footer content, background colour or image, page borders, and numbering format.

   • A document can use multiple page styles (e.g., different styles for front matter, main content, and appendices).

5. List Styles

   • Control the appearance and position of numbering or bullets for lists.

   • Define indentation levels, fonts, and the actual bullet character or numbering scheme.

6. Table Styles

   • Coordinate the formatting of borders, background patterns, and text alignments within tables, ensuring consistency across all tables in a document.

The Styles Pane

The Styles Pane is your primary interface for managing styles. You can open it via Sidebar ▷ Styles icon, by navigating through the menu Styles ▷ Manage Styles, using the toolbar drop-down, or by pressing the shortcut key $F11$.

• It can be docked to the side of the Writer window or floated as a separate window.

• It offers preview thumbnails (which can be toggled via Show Preview) to visualize the style's appearance.

• Icons across the top of the pane allow you to switch easily among the different style families (Paragraph, Character, Frame, Page, List, Table).

Applying a Style (Styles Pane)

To apply a style using the Styles Pane:

1. Select the text you wish to format (a paragraph for Paragraph Styles, a word for Character Styles, etc. If no text is selected, Paragraph Styles apply to the current paragraph).

2. In the Styles Pane, choose the appropriate style family (e.g., Paragraph Styles for a heading).

3. Double-click the desired style (e.g., Title) from the list – the formatting is applied instantly to your selection.

Applying a Style (Fill-Format Mode)

Fill-Format Mode is highly efficient for applying the same style to multiple, non-contiguous selections:

1. Double-click a style in the Styles Pane.

2. The Paint-Roller (Fill Format Mode) icon activates, and your cursor transforms into a paint bucket icon.

3. Click or drag across disparate portions of text to "paint" the selected style repeatedly onto them.

4. Exit the Fill-Format mode by pressing the Esc key or by clicking the Paint-Roller icon again. A right-click within the document while the mode is active will revert only the last fill action you performed.

Creating Custom Styles

Custom styles allow you to define and save unique formatting combinations.

From Selection

This method is convenient for capturing existing manual formatting:

1. Format a sample text or paragraph manually to achieve the desired look.

2. With the formatted text selected, open the Styles Pane.

3. Click the New Style from Selection button (often a small icon with a plus sign) and then choose New Style from the pop-up menu.

4. In the dialog box, give your new style a descriptive name (e.g., Custom Quote, My Code Block); choose the correct category (e.g., Paragraph, Character); and click OK.

Drag-and-Drop

A quick way to create a Paragraph Style:

1. Format a paragraph exactly as you want the new style to appear.

2. Drag the formatted block (select the paragraph and drag its text) into the Styles pane.

3. The cursor shape will change to indicate that dropping is allowed. Release the mouse button.

4. A dialog will appear for you to name your new style.

(Note: The drag-and-drop method cannot be used to create Page or Table styles.)

Modifying Styles

Modifying an existing style is powerful because changes automatically propagate throughout the entire document, updating all instances where that style is applied.

• To modify: Right-click on a style name in the Styles Pane and select Modify.

• This opens a multi-tab dialog box (e.g., Font, Alignment, Indents & Spacing, Borders, Area, etc.) where you can adjust specific attributes. Once you click OK, all text already using that style will update instantly.

Update Style from Selection

This is an alternative to manual modification, useful when you've already made manual changes to a paragraph and want to apply those changes back to its original style:

1. Format a paragraph using manual formatting (e.g., change its font size or colour).

2. Select that formatted paragraph.

3. In the Styles Pane, click New Style from Selection ▷ Update Style. This will redefine the active style based on the current selection's formatting.

Loading Styles from Another Document/Template

You can import styles from other LibreOffice Writer documents or templates:

• Open the Styles Pane ▷ Click the Load Styles… button.

• Alternatively, go to Styles menu ▷ Load Styles.

• In the dialog, tick the categories of styles you wish to load (e.g., Text, Frame, Page, Numbering, Table). You can also choose to Overwrite styles with identical names.

• Choose the source template or file from which to import the styles. This helps maintain consistency across multiple documents or projects.

Working with Images

LibreOffice Writer provides robust tools for inserting and manipulating graphics directly within your document.

Inserting Graphics

Several methods allow you to bring images into your document:

1. Insert Menu: Go to Insert ▷ Image and then navigate to pick your image file from your computer. The standard toolbar also has an Image icon for direct access.

2. Drag-and-Drop: Simply drag an image file directly from your File Explorer (or equivalent file browser) and drop it onto your LibreOffice Writer page at the desired location.

3. Copy and Paste: Copy an image (Ctrl +C) from another application (e.g., a web browser, image editor, or another document) and paste it (Ctrl +V) into Writer. It's often best to keep the source application open until the paste operation is complete to ensure proper embedding.

4. Link instead of Embed: By default, images are embedded (copied entirely) into your document, increasing file size. To link an image (meaning the document stores only a reference to the image file, not the image itself):

   • In the Insert Image dialog, tick the Link option.

   • Alternatively, when dragging-and-dropping, hold Ctrl + Shift as you drop the image.

   • Advantage: Smaller document file size.

   • Disadvantage: Images must accompany the document when moved, or they will appear as broken links.

The Image Toolbar (View ▷ Toolbars ▷ Image)

When an image is selected, the Image Toolbar often appears automatically, or you can enable it manually via View ▷ Toolbars ▷ Image. It provides quick access to common image editing functions:

• Image Filter: Offers 11 artistic effects that can alter the appearance of your image (e.g., transforming it into a charcoal sketch or a pop-art piece).

• Image Mode: Allows you to change the colour depth of the image (e.g., Colour, Greyscale, Black-&-White, or Watermark for a faded background effect).

• Crop: Enables you to trim unwanted portions from the image edges.

• Flip Vertically / Horizontally: Reverses the image's orientation along a specific axis.

• Rotate $90^{ ext{o}}$ Left/Right; free Rotate: Rotates the image in fixed increments or allows for custom angle rotation.

• Transparency slider: Adjusts the opacity of the image, making it more or less see-through.

• Colour adjustment (RGB, Brightness, Contrast, Gamma): Offers fine-tuned control over the image's colour balance and luminosity.

Filters

Specific image filters available include, but are not limited to:

• Invert: Reverses colours (like a photographic negative).

• Smooth/Sharpen: Adjusts image clarity.

• Remove Noise: Cleans up grainy images.

• Solarize: Creates a partially inverted effect.

• Aging: Applies a sepia-toned, aged look.

• Posterize: Reduces the number of colours to create a flat, poster-like appearance.

• Pop Art: Applies vibrant, high-contrast colours.

• Charcoal: Simulates a charcoal drawing.

• Relief: Creates a 3D embossed effect.

• Mosaic: Transforms the image into a pixelated mosaic.

Transformations

Beyond the toolbar, general transformations can be applied:

• Resize: Dragging the side handles of a selected image will stretch or compress it horizontally or vertically. Dragging corner handles will resize the image proportionally, maintaining its aspect ratio. Holding Shift while dragging a corner handle will also maintain proportionality.

• Rotate: After selecting an image, activate the Rotate tool (often by clicking on the image once to select it, then clicking again to show rotation handles). Use the red rotation handles that appear at the corners to rotate the image. Clicking the center handle allows you to change the pivot point.

• Crop: Activate the Crop tool from the Image toolbar. Blue crop handles will appear around the image; drag these to define the new boundaries. Alternatively, use Format ▷ Image ▷ Properties and select the Crop tab for precise numerical adjustments.

• Delete: Select the image and press the Delete key.

Drawing Objects

LibreOffice Writer includes a comprehensive Drawing toolbar to create and insert a variety of graphic shapes, lines, and artistic text directly within your document.

Enable the Drawing toolbar via View ▷ Toolbars ▷ Drawing. It contains tools for basic shapes (lines, arrows, rectangles, ellipses), flowchart symbols, call-outs (speech bubbles), stars, three-dimensional objects, and Fontwork (stylized text).

Creating a Shape

1. Select a drawing tool from the Drawing toolbar (e.g., Rectangle, Line, Star) or navigate through Insert ▷ Shape and then choose from sub-categories like Lines / Basic / Symbol / Star / Callout / Flowchart.

2. Once a tool is selected, your cursor turns into a crosshair (+).

3. Click and drag on the document page to draw the shape to your desired size and position. Holding down the Shift key while dragging will constrain the shape (e.g., maintaining a perfect square or circle, or drawing perfectly horizontal/vertical lines).

4. Press Esc or click the Select tool (the arrow icon) on the toolbar to exit drawing mode and revert your cursor to normal.

Properties Toolbar

When a drawing object is selected, the Properties toolbar (or a similar panel depending on your UI settings) will appear, providing specific formatting options for the selected object. This includes settings for:

• Area Fill: Controls the interior of the shape (e.g., solid Colour, subtle Gradient, intricate Hatching patterns, or even a Bitmap image, or a custom Pattern).

• Line Colour/Style/Width: Defines the appearance of the shape's outline.

• Shadow: Adds a shadow effect to the object.

• Rotation: Allows precise numeric rotation.

• Anchoring: How the object is positioned relative to text.

• Text Wrapping: How text flows around or through the object.

Colour & Line Adjustments

• Fill Colour ▼: Drop-down palette to set the solid colour of the shape's interior.

• Line Colour ▼: Drop-down palette to set the colour of the shape's border.

• Line Style ▼: Drop-down to choose from various line styles (solid, dashed, dotted, etc.) for the border.

• Line Width spin-box: Allows precise adjustment of the border thickness.

Resizing & Grouping

• Resize: Similar to images, drag the handles around the selected drawing object to resize it. Corner handles maintain aspect ratio, while side handles stretch.

• Group: To treat multiple shapes as a single unit, select them all (by Shift-clicking on each one or by drawing a selection marquee around them). Right-click on any selected object and choose Drawing Object Properties ▷ Group. From this submenu, you can also Ungroup them later, or Enter Group to edit individual objects within the group, then Exit Group.

  • Benefit of Grouping: Allows you to move, resize, rotate, and format multiple objects simultaneously, ensuring they maintain their relative positions and proportions.

Positioning Relative to Text

Effectively positioning drawing objects (and images) alongside text is crucial. LibreOffice Writer offers four primary mechanisms:

1. Arrangement

   • Controls the vertical stacking of objects relative to each other and to the text layers.

   • Options: Bring to Front (top layer), Forward One, Back One, Send to Back (bottom layer), To Foreground (above text), To Background (behind text).

   • Used for layering effects.

2. Anchoring

   • Determines how an object moves or stays fixed relative to a specific point in the document. This is fundamental for predictable object placement when text is added or deleted.

   • To Page: Object position is fixed on the page, regardless of text flow.

   • To Paragraph: Object moves with its anchor paragraph.

   • To Character: Object moves with a specific character, acting as if it's part of the text flow but with more flexibility.

   • As Character: The object behaves exactly like a single character within the text line, affecting line height and breaking with the text flow.

3. Alignment

   • Aligns selected objects relative to the page, selected area, or other objects.

   • Primary options: Left / Centre / Right (horizontal alignment); Top / Centre / Bottom (vertical alignment).

4. Text Wrapping

   • Dictates how surrounding text flows around the object, if at all.

   • Wrap Off: Text ignores the object.

   • Optimal Page Wrap: Text wraps around the object, trying to find the best fit.

   • Page Wrap (Left / Right): Forces text to wrap only on one side.

   • Wrap Through: Text flows over the object (object is transparent to text).

   • In Background: Object is behind text, text flows over it.

   • In Front: Object is in front of text, obscuring it.

Table of Contents (TOC)

A Table of Contents (TOC) is an essential navigation aid in longer documents, automatically listing headings and their page numbers.

Heading Hierarchy & Chapter Numbering

• For an automatic TOC to work, you must apply consistent heading paragraph styles (e.g., Heading 1, Heading 2, up to Heading 10) to your document's titles and subtitles.

• You can configure automatic chapter numbering (e.g., "1. Introduction", "1.1. Background") by going to Tools ▷ Chapter Numbering. Here, you assign specific paragraph styles to different outline levels and select numbering formats (e.g., 1., 1.1, 1.1.1…). Changing headings automatically renumbers them throughout the document.

Inserting TOC

1. Place your cursor at the location where you want the TOC to appear, commonly after the title page or directly after a dedication/abstract.

2. Go to Insert ▷ Table of Contents and Index ▷ Table of Contents, Index or Bibliography.

3. In the Type tab of the dialog box:

   • Choose the Title for your TOC (e.g., Contents, Table of Contents).

   • Ensure the Protected against manual changes option is ticked. This prevents accidental editing and ensures the TOC can be updated automatically by the software.

4. Click OK.

5. The TOC will appear in your document, typically with a light grey shading (this shading is non-printing and indicates an automatically generated field). When viewing the document, you can Ctrl + Click on any entry in the TOC to instantly jump to that heading's location in the document.

Customising TOC

You can extensively customize the appearance and content of your TOC. Right-click on the TOC itself and select Edit Index to open a multi-tab dialog:

• Type: Allows you to change the title, manage the protection setting, and specify whether the TOC should cover the Entire Document or just the Current Chapter.

• Entries: This is crucial for defining the structure of each level within the TOC. You can add or remove elements like: E# (chapter number), E (entry text), T (tab stop), # (page number). You can also edit the separators between these elements and assign different character styles.

• Styles: Assigns specific paragraph styles to each level of the TOC (e.g., Contents 1 for Heading 1, Contents 2 for Heading 2). You can also define how separators look.

• Columns: Configures a multi-column layout for the TOC, useful for shorter entries.

• Background: Lets you set a solid Colour or a Bitmap image as the background for the TOC area. Use None to clear any applied background.

Maintenance

To ensure your TOC is always up-to-date:

• Update: After making changes to headings or page numbers in your document, right-click on the TOC and select Update Index (or use the Navigator panel to update specific indexes).

• Delete: To remove the TOC, right-click on it and select Delete Index.

Templates

A template in LibreOffice Writer (files with the .ott extension) is a blueprint for new documents. It stores a complete document skeleton, including predefined styles, page layout settings, boilerplate text, graphics (like a company logo), placeholder content, and custom menu/toolbar settings. Templates ensure consistency across multiple documents and streamline the creation of common document types.

Determining Current Template

To find out which template a document is based on:

• Go to File ▷ Properties, and then select the General tab. The Template field will display the name and path of the template used.

Using a Pre-installed Template

LibreOffice comes with several pre-installed templates (e.g., for business letters, faxes):

1. Go to File ▷ New ▷ Templates (or click the New toolbar drop-down icon and select Templates).

2. Browse and choose a category (e.g., All Categories, Business Correspondence, Presentations).

3. Select the desired template from the list.

4. Click Open. A new document based on that template will be created.

Creating & Saving a Template

To create your own custom template:

1. Design a document with all the elements you want in your template: this could include a company logo, specific default fonts and colours, custom paragraph and character styles, page layout settings (margins, headers/footers), and any placeholder text or boilerplate content.

2. Go to File ▷ Templates ▷ Save as Template.

3. In the dialog:

   • Enter a meaningful Template Name (e.g., Company Letterhead, Project Report Draft).

   • Pick a Template Category to organize it (e.g., My Templates, Business, Formal). You can create new categories if needed.

   • Optionally, select Set as default template for future new documents of that type.

4. Click Save.

Accessing Saved / Online Templates

• The Templates dialog (accessible via Ctrl + Shift + N or File ▷ New ▷ Templates) shows all local templates you've saved or installed.

• Clicking the Browse Online Templates icon (a circle arrow) from within the Templates dialog will open your web browser to https://extensions.libreoffice.org/templates. From here, you can download additional free templates (typically .ott files for templates or .oxt files for extensions that include templates). After downloading, you'll need to install them (often by double-clicking the file) so they appear in your local Templates dialog.

Import / Export / Move

Manage your templates efficiently within the Templates dialog:

• Import: Click the Import button, choose a target category (or create a new one), and then select an .ott file from your computer to add it to your local templates.

• Move: Select a template from the list, click Move, and choose a new category to reorganize your templates.

• Export: Select a template, click Export, and choose a destination folder. This creates a portable copy of the .ott file, useful for sharing or backup.

• Delete: Right-click on a template and select Delete to remove it.

• Reset default: To revert the default template for a specific document type (e.g., Text Document) back to LibreOffice's standard blank document, go to the Settings ⚙ icon in the Templates dialog and select Reset Default Template ▷ Text Document.

Applying a Template to an Existing Blank Document

While templates are primarily for creating new documents, you can apply content from a template to an existing blank document if needed:

1. Open your blank document.

2. Go to File ▷ New ▷ Templates and double-click the template you wish to apply. This will open a new document created from that template with its predefined content.

3. Select all content from this new document (Ctrl +A), copy it (Ctrl +C), switch back to your original blank document, and paste (Ctrl +V) the content.

4. Save your original document as a standard .odt file.

5. (Alternative): You can also use Insert ▷ Text from File to bring in the content of a template file into your current document, although this method may not fully transfer all styles defined in the template unless specifically set.

Track Changes (Revision Control)

Track Changes, also known as Revision Control, is an indispensable feature for collaborative editing. It allows multiple users to make changes to a document while preserving a clear record of all modifications, making the review process transparent and auditable.

Track Changes Toolbar (View ▷ Toolbars ▷ Track Changes)

This toolbar provides all necessary tools for managing revisions:

• Record Track Changes: A toggle switch (also accessible via Ctrl + Shift +C). When activated, all edits (insertions, deletions, formatting changes) are logged. Insertions typically appear coloured (often green), and deletions are struck-through and coloured (often red).

• Show Track Changes: Toggles the visibility of the markup (coloured insertions, struck-through deletions). Useful for seeing the final document without visible changes.

• Previous / Next Change: Navigates through each tracked change sequentially, highlighting it for review.

• Accept / Accept All: Approves the currently highlighted change or all changes in the document, incorporating them permanently into the text.

• Reject / Reject All: Rejects the currently highlighted change or all changes, reverting the text to its original state.

• Manage Track Changes: Opens a comprehensive dialog box that lists all changes made, along with details like the author, date, time, and any associated comments. From this dialog, you can selectively accept or reject individual changes, filter changes, and add comments.

• Insert Comment: Adds a margin note or comment bubble to a specific selection of text. These comments are distinct from tracked changes but are part of the collaborative review process.

• Protect Track Changes: Allows you to password-lock the record mode, preventing unauthorized users from turning off tracking or making changes without tracking.

• Compare / Merge: These tools enable you to compare the current document with another version (e.g., an original draft) or to merge tracked changes from multiple review copies into a single document for final reconciliation.

Workflow

1. Author Preparation: The original author enables Record Track Changes and, optionally, Protect Track Changes with a password to ensure all further edits are tracked.

2. Reviewer Edits: Reviewers make their changes. Each insertion, deletion, or format change is automatically tagged with the reviewer's name (author) and a timestamp, making attribution clear.

3. Author Review: The original author reviews the changes. They can navigate through changes using Previous/Next Change buttons or use the Manage Track Changes dialog for a comprehensive overview and selective acceptance/rejection.

4. Comments: During review, comments can be inserted (via Insert Comment button or Insert ▷ Comment) to ask questions, provide feedback, or explain changes. Comments appear in the sidebar. To manage comments, right-click on a comment bubble, and options like Delete, Delete by Author, or Delete All Comments will appear.

5. Compare Documents: If you have an original version and a modified version where Track Changes was not enabled, you can use Edit ▷ Track Changes ▷ Compare Document. Select the original file, and LibreOffice will display the differences as if track changes had been active. The Manage Track Changes dialog then lists these differences for your review.

Spreadsheet Data Analysis in LibreOffice Calc

LibreOffice Calc offers a powerful suite of tools for sophisticated data analysis, allowing users to consolidate, group, and perform what-if scenarios on their data.

Data Consolidation

Data Consolidation combines values from multiple source sheets or ranges into a master sheet, performing an aggregate function (e.g., sum, average) on corresponding data cells. This is incredibly useful for summarizing data from different periods or departments.

Steps:

1. Prepare Source Sheets: Ensure your source sheets (or ranges within a sheet) have identical labelling for rows and columns where you want to consolidate data. This allows Calc to correctly match and combine the information.

2. Activate Master Sheet: Go to the master sheet where you want the consolidated results to appear.

3. Open Consolidate Dialog: Navigate to Data ▷ Consolidate.

4. Select Function: From the Function drop-down, choose the aggregation method (e.g., Sum (default), Count, Average, Max, Min, Product).

5. Add Source Data Ranges: In the Source data ranges section:

   • Click the ▼ (Collapse) button to temporarily minimize the dialog.

   • Select the first range of data on a source sheet (e.g., in sheet 2020, select cells Sheet1.$B$3:D$10).

   • Click the Add button to include this range in the list.

   • Repeat this process for all other source ranges you want to consolidate (e.g., Sheet2.$B$3:D$10 for 2021 data).

6. Specify Copy Results To: In the Copy results to field, pick the target starting cell on your master sheet where the consolidated data will begin.

7. Choose Options (Important for matching and linking):

   • Row Labels / Column Labels: Tick these if your source ranges include row and/or column headers. Calc uses these labels to match data across different ranges, ensuring that, for example, 'Sales' figures from 2020 are added to 'Sales' figures from 2021.

   • Link to Source Data: Tick this option to create 3-D formulas (=SUM(Sheet1.B3;Sheet2.B3)) in the results sheet instead of static values. This means your consolidated results will auto-update if the original source data changes, making the consolidation dynamic.

8. Click OK. The consolidated result appears instantly.

• Naming Ranges: For easier management and reusability, consider naming your data ranges (e.g., Data2020, Data2021) using Data ▷ Define Range. These named ranges can then be easily selected in the Consolidate dialog.

Grouping & Outlining

Grouping and Outlining allows you to structure your data into collapsible sections, making large datasets easier to navigate and analyze by showing or hiding levels of detail.

• Select the rows or columns you wish to group.

• Go to Data ▷ Group and Outline ▷ Group (selected rows or columns).

• Outline symbols (numbered buttons 1, 2, 3, plus and minus signs) will appear on the left (for rows) or top (for columns). These allow you to collapse (hide details) or expand (show details) the grouped sections.

• To remove outlining, select the grouped area and go to Data ▷ Group and Outline ▷ Remove Outline.

Subtotals

Subtotals automatically calculate summary functions (like sums, counts, averages) for data groups within a list, plus a grand total. This is excellent for sales reports by region, inventory by category, etc.

1. Sort Data: It is highly recommended to sort your data by the column you intend to Group by before applying subtotals (e.g., sort by 'Sales Executive' if you want subtotals for each executive).

2. Select Range: Select the entire data range you want to apply subtotals to.

3. Open Subtotals Dialog: Go to Data ▷ Subtotals.

4. Group by: Select the column that defines your groups (e.g., 'Sales Executive', 'Region', 'Product Category').

5. Calculate subtotals for: Select the numeric columns for which you want to calculate summaries (e.g., 'Sales Amount', 'Quantity Sold', 'Profit').

6. Use function: Choose the aggregation function (e.g., Sum, Count, Average, Max, Min).

7. Click OK.

8. Calc inserts new outline levels and subtotal rows into your data. A grand total row is added at the bottom. To remove these, go back to Data ▷ Subtotals ▷ Remove.

What-If Analysis Tools

These tools help you explore the impact of changing input values on formulas, crucial for financial planning, budgeting, and solving complex problems.

Scenarios

Scenarios allow you to store and quickly switch between different sets of input values within the same sheet, each representing a distinct case or