Pick a task, follow a short checklist, and open the source for the complete instructions.
A starting point for 24 spreadsheet tasks, with direct links to official instructions. These guides describe LibreOffice Calc; Excel and Google Sheets can work differently. Menu names can vary by version.
Sources reviewed 2026-10-17 by an AI assistant. Links are checked against Wren’s current site admission rules. A source in this guide may not yet be in Wren’s search index.
Keep headings visible while scrolling
Freeze rows or columns for scrolling; repeating headings on paper is a separate setting.
Read the official instructions ·
Search Wren for this task
Open a CSV file
Choose the text import settings when opening a CSV, including the separator used by the file.
Read the official instructions ·
Search Wren for this task
Preserve leading zeros
Choose text entry for identifiers or a number format for display; those choices affect calculations differently.
Read the official instructions ·
Search Wren for this task
Format amounts as currency
Choose an explicit currency and locale for the displayed amount; formatting does not convert exchange rates.
Read the official instructions ·
Search Wren for this task
Change displayed decimal places
Displayed decimal places change the appearance of a number, not its stored precision.
Read the official instructions ·
Search Wren for this task
Highlight negative amounts
Use a number format that gives negative values a different color.
Read the official instructions ·
Search Wren for this task
Format cells based on their values
Conditional formatting uses rules and requires automatic calculation to be enabled.
Read the official instructions ·
Search Wren for this task
Store numbers as text
Apply text format before entering numbers. Changing existing cells to text format alone does not convert their contents.
Read the official instructions ·
Search Wren for this task
Convert numeric text to numbers
The guide explains automatic numeric conversion and its limits. Locale-dependent decimals need additional care.
Read the official instructions ·
Search Wren for this task
Rename a sheet
Change the worksheet tab name independently of the document filename.
Read the official instructions ·
Search Wren for this task
Adjust column width
Adjust a row or column boundary or use the optimal size option.
Read the official instructions ·
Search Wren for this task
Wrap long text inside a cell
Choose automatic wrapping or insert a manual line break inside a cell.
Read the official instructions ·
Search Wren for this task
Show formulas instead of results
Switch the view between formulas and the values they calculate.
Read the official instructions ·
Search Wren for this task
Copy a formula to other cells
Copy or drag a formula; relative references change with its position.
Read the official instructions ·
Search Wren for this task
Calculate elapsed time
The example handles a time interval crossing midnight. Intervals spanning several days need date information.
Read the official instructions ·
Search Wren for this task
Filter a table with dropdowns
Select the intended data range and use column dropdowns to show matching rows.
Read the official instructions ·
Search Wren for this task
Sort rows by a column
Check the selected range before sorting so related values remain together.
Read the official instructions ·
Search Wren for this task
Turn rows into columns
Paste Special can transpose a selected range; check the destination before replacing cells.
Read the official instructions ·
Search Wren for this task
Keep a cell reference fixed
Use dollar signs to fix row or column references when copying formulas.
Read the official instructions ·
Search Wren for this task
Reference a cell on another sheet
Reference another sheet by name; names containing spaces need single quotes.
Read the official instructions ·
Search Wren for this task
Create a pivot table
Choose source data with headings and arrange fields into the pivot layout.
Read the official instructions ·
Search Wren for this task
Print only a selected area
Define a print range; the guide also explains differences for files opened in Excel format.
Read the official instructions ·
Search Wren for this task
Repeat headings on printed pages
Set rows or columns to repeat for printing; freezing the view does not do this.
Read the official instructions ·
Search Wren for this task
Protect cells from accidental editing
Cell protection takes effect when the sheet is protected. It prevents accidental editing and is not secure access control.
Read the official instructions ·
Search Wren for this task
Read and save pages in Firefox
For Firefox on a desktop computer. Menu labels can vary by operating system and version.
Sources reviewed 2026-10-17 by an AI assistant. Source links follow current admission rules; inclusion does not guarantee a page is in the search index.
Keep a transferable copy of your bookmarks
An HTML export moves bookmarks between browsers. It is not a backup of passwords or your entire browser profile.
- Open Bookmarks, then Manage bookmarks.
- In the Library, choose Import and Backup, then Export Bookmarks to HTML.
- Save the file somewhere you can find again. Keep it private if your saved links contain personal information.
Mozilla’s export instructions ·
Search Wren for this task
Bring saved bookmarks into Firefox
HTML import adds bookmarks to those already present, so duplicates are possible. Restoring a Firefox JSON backup is a different operation that can replace bookmarks.
- Back up your existing bookmarks from the Library’s Import and Backup menu.
- Choose Import Bookmarks from HTML and open the saved HTML file.
- Look for the added links in the Bookmarks Menu and check a few of them.
Mozilla’s import instructions ·
Search Wren for this task
Make an article easier to read
Reader View is offered only on compatible pages. It does not make a restricted article publicly available.
- Look for the Reader View icon in the address bar and select it when available.
- Use its text and theme controls to adjust size, spacing and background.
- Select the icon again or go back to return to the original page.
Mozilla’s Reader View instructions ·
Search Wren for this task
Print an article with less clutter
Simplified format is not available for every page. Check the preview for missing content before printing.
- Open Print from the Firefox menu, then More settings.
- Under Format, select Simplified if offered.
- Review the preview and print. You can also enter Reader View first, then open Print.
Mozilla’s simplified printing instructions ·
Search Wren for this task
Your first sourdough starter and loaf
A reading path through King Arthur Baking’s beginner instructions. Start with the full recipe for quantities, equipment and baking directions; these checkpoints help you choose the next step.
Sources reviewed 2026-10-17 by an AI assistant. Source links follow current admission rules; inclusion does not guarantee a page is in the search index.
Make a starter from flour and water
Allow several days of regular feeding. Readiness depends on activity, not just the day on the calendar.
- Read the day-by-day guide and gather a roomy container, flour, water and preferably a gram scale.
- Follow the feeding schedule and watch how the starter changes.
- Use the guide’s signs of readiness before moving on to bread.
King Arthur’s starter guide ·
Search Wren for this task
Turn an active starter into a loaf
Keeping a starter alive and preparing it to raise bread are different jobs. This recipe relies on an active starter for its rise.
- Check the starter’s readiness against the guide before measuring the ingredients.
- Follow the illustrated sequence for mixing, resting, kneading, folding and shaping.
- Use the recipe’s proofing and baking directions, and retain starter for the next bake.
King Arthur’s illustrated baking guide ·
Search Wren for this task
Keep your starter between baking days
Storage changes the feeding schedule: this guide recommends weekly feeding in the refrigerator and twice-daily feeding at room temperature.
- Choose the storage method that matches how often you bake.
- Follow the guide’s feeding quantities, using weight for consistency.
- Before baking again, allow time for feeding until the starter is active enough for your recipe.
King Arthur’s maintenance guide ·
Search Wren for this task