LibreOffice Calc Notes
File Menu
File
These commands apply to the current document, open a new document, or close the application.
New
Creates a new LibreOffice document.
Open
Opens a local or remote file, or imports one.
Recent Documents
Lists the most recently opened files. To open a file in the list, click its name.
Close
Closes the current document without exiting the program.
Wizards
Guides you through creating business and personal letters, faxes, agendas, presentations, and more.
Templates
Lets you organize and edit your templates, as well as save the current file as a template.
Reload
Replaces the current document with the last saved version.
Versions
Saves and organizes multiple versions of the current document in the same file. You can also open, delete and compare previous versions.
Save
Saves the current document.
Save As
Saves the current document in a different location, or with a different file name or file type.
Save All
Saves all modified LibreOffice documents.
Export
Saves the current document with a different name and format to a location that you specify.
Export as PDF
Saves the current file to Portable Document Format (PDF) version 1.4. A PDF file can be viewed and printed on any platform with the original formatting intact, provided that supporting software is installed.
Send
Sends a copy of the current document to different applications.
Preview in Web Browser
Creates a temporary copy of the current document in HTML format, opens the system default Web browser, and displays the HTML file in the Web browser.
Print Preview
Displays a preview of the printed page or closes the preview.
Prints the current document, selection, or the pages that you specify. You can also set the print options for the current document. The printing options can vary according to the printer and the operating system that you use.
Printer Settings
Select the default printer for the current document.
Document Properties
Displays the properties for the current file, including statistics such as word count and the date the file was created.
Digital Signatures
Adds and removes digital signatures to and from your document. You can also use the dialog to view certificates.
Exit
Closes all LibreOffice programs and prompts you to save your changes. This command does not exist on macOS systems.
Edit Menu
This menu contains commands for editing the contents of the current document.
Undo
Reverses the last command or the last entry you typed. To select the command that you want to reverse, click the arrow next to the Undo icon on the Standard bar.
Redo
Reverses the action of the last Undo command. To select the Undo step that you want to reverse, click the arrow next to the Redo icon on the Standard bar.
Repeat
Repeats the last command. This command is available in Writer and Calc.
Cut
Removes and copies the selection to the clipboard.
Copy
Copies the selection to the clipboard.
Paste
Inserts the contents of the clipboard at the location of the cursor, and replaces any selected text or objects.
View Menu
This menu contains commands for controlling the on-screen display of the document.
Normal
Displays the normal layout view of the sheet.
Toolbars
Opens a submenu to show and hide toolbars. A toolbar contains icons and options that let you quickly access LibreOffice commands.
Formula Bar
Shows or hides the Formula Bar, which is used for entering and editing formulas. The Formula Bar is the most important tool when working with spreadsheets.
Status Bar
Shows or hides the Status bar at the bottom edge of the window.
Column & Row Headers
Shows column headers and row headers.
Grid Lines for Sheet
Toggle the visibility of grid lines for the current sheet.
Value Highlighting
Displays cell contents in different colors, depending on type.
Insert Menu
The Insert menu contains commands for inserting new elements, such as images, text boxes, object, media, cell names and much more into the current sheet.
Images
Inserts an image into the current document at the current cell position.
Chart
Inserts a chart.
Pivot Table
Opens a dialog box where you can select the source for your pivot table, and then create your table.
Media
The submenu presents various sources that an image, audio or video can be insert from.
Object
Inserts an embedded object into your document, including formulas, 3D models, charts and OLE objects.
Shape
This submenu contains common shapes like a line, circle, triangle, and square, or a symbol shape like a smiley face, heart, and flower that can be inserted into the document.
Function
Opens the Function Wizard, which helps you to interactively create formulas.
Named Ranges and Expressions
Allows you to name the different sections of your spreadsheet document. By naming the different sections, you can easily navigate through the spreadsheet documents and find specific information.
Text Box
Draws a text box with horizontal text direction where you drag in the current document. Drag a text box to the size you want anywhere in the document, and then type or paste your text. Rotate the text box to get rotated text.
Comments
Inserts a comment around the selected text, presentation slide, drawing page or at the current spreadsheet cursor position.
Floating Frame
Inserts a floating frame into the current document. Floating frames are used in HTML documents to display the contents of another file.
Fontwork
Opens the Font work dialog from which you can insert styled text not possible through standard font formatting into your document.
Hyperlink
Opens a dialog that enables you to create and edit hyperlinks.
Special Character
Allows a user to insert characters from the range of symbols found in the installed fonts.
Formatting Mark
Opens a submenu to insert special formatting marks like non-breaking space, soft hyphen, and optional break.Date
Inserts the current date in the cell.
Time
Inserts the current time in the cell.
Field
Opens a submenu for selecting the date, sheet name or document title in the cell.
Headers & Footers
Allows you to define and format headers and footers.
Form Control
This submenu contains form controls like a textbox, checkbox, option button, and listbox that can be inserted into the document.
Signature Line
Insert a graphic box representing a signature line of the document.
Format Menu
The Format menu contains commands for formatting selected cells, objects, and cell contents in your document.
Text
Opens a submenu where you can choose text formatting commands.
Clear Direct Formatting
Removes direct formatting and formatting by character styles from the selection.
Cells
Allows you to specify a variety of formatting options and to apply attributes to the selected cells.
Row
Sets the row height and hides or shows selected rows.
Column
Sets the column width and hides or shows selected columns.
Sheet
Sets the sheet name and hides or shows selected sheets.
Merge and Center Cells
Combines the selected cells into a single cell or splits merged cells. Aligns cell content centred.
Page
Opens a dialog where you can define the appearance of all pages in your document.
Print Ranges
Manages print ranges. Only cells within the print ranges will be printed.Character
Changes the font and the font formatting for the selected characters.
Paragraph
Modifies the format of the current paragraph, such as indents and alignment.
AutoFormat
Use this command to apply an AutoFormat to a selected sheet area or to define your own AutoFormats.
Conditional Formatting
Choose Conditional Formatting to define format styles depending on certain conditions.
Anchor
Sets the anchoring options for the selected object.
Alignment (Objects)
Aligns selected objects with respect to one another.
Alignment (Text Objects)
Set the alignment options for the current selection.
Arrange
Changes the stacking order of the selected object(s).
Flip
Flips the selected object horizontally, or vertically.
Group
Groups keep together selected objects, so that they can be moved or formatted as a single object.
Graphic
Opens a submenu to edit the properties of the selected object.
Control
Opens a dialog for editing the properties of a selected control.
Form
In this dialog you can specify, among others, the data source and the events for the whole form.
Sheet Menu
This menu contains commands to modify and manage a sheet and its elements.
Insert Rows
Insert rows above or below the active cell.
Insert Columns
Inserts columns to the left or to the right of the active cell.
Insert Page Break
This command inserts manual row or column breaks to ensure that your data prints properly. You can insert a horizontal page break above, or a vertical page break to the left of, the active cell.
Delete Cells
Completely deletes selected cells, columns or rows. The cells below or to the right of the deleted cells will fill the space. Note that the selected delete option is stored and reloaded when the dialog is next called.
Delete Page Break
Choose the type of page break that you want to delete.
Fill
Automatically fills cells with content.
Deleting Contents
Specifies the contents to be deleted from the active cell or from a selected cell range. If several sheets are selected, all selected sheets will be affected.
Moves or copies a sheet to a new location in the document or to a different document.
Show Sheet
Displays sheets that were previously hidden with the Hide Sheets command.
Delete Sheet
Deletes the current sheet after query confirmation.
Sheet Tab Color
Opens a window where you can assign a color to the sheet tab.
Sheet Events
Assigns macros to program events. The assigned macro runs automatically every time the selected event occurs.
Data Menu
Use the Data menu commands to edit the data in the current sheet. You can define ranges, sort and filter the data, calculate results, outline data, and create a pivot table.
Sort
Sorts the selected rows according to the conditions that you specify. LibreOffice automatically recognizes and selects database ranges.
Sort Ascending
Text fields are sorted alphabetically, numerical fields are sorted by number.
Sort Descending
Text fields are sorted alphabetically, number fields are sorted by number.
AutoFilter
Automatically filters the selected cell range, and creates one-row list boxes where you can choose the items that you want to display.
Filters
Shows commands to filter your data.
Define Range
Defines a database range based on the selected cells in your sheet.
Select Range
Selects a database range that you defined under Data - Define Range.
Refresh Range
Updates a data range that was inserted from an external database. The data in the sheet is updated to match the data in the external database.
Pivot Table
A pivot table provides a summary of large amounts of data. You can then rearrange the pivot table to view different summaries of the data.
Calculate
Commands to calculate formula cells.
Validity
Defines what data is valid for a selected cell or cell range.
Subtotals
Calculates subtotals for the columns that you select. LibreOffice uses the SUM function to automatically calculate the subtotal and grand total values in a labelled range. You can also use other functions to perform the calculation.
LibreOffice automatically recognizes a defined database area when you place the cursor in it.
Form
Data Entry Form is a tool to make table data entry easy in spreadsheets. With the Data Entry Form, you can enter, edit and delete records (or rows) of data and avoid horizontal scrolling when the table has many columns or when some columns are very wide.
Live Data Stream
Live data stream for spreadsheets
XML Source
Import XML data in a spreadsheet.
Data Provider for Spreadsheets
Data Provider for Spreadsheets
Multiple Operations
Applies the same formula to different cells, but with different parameter values.
Text to Columns
Opens the Text to Columns dialog, where you enter settings to expand the contents of selected cells to multiple cells.
Consolidate
Combines data from one or more independent cell ranges and calculates a new range using the function that you specify.
Group and Outline
You can create an outline of your data and group rows and columns together so that you can collapse and expand the groups with a single click.
Statistics
Use the data statistics in Calc to perform complex data analsis.
Show Formula
Display the cell formula expression instead of the calculated result.
Grid and Help Lines
Toggle the visibility of grid points and guide lines to help object moving and precise position in the current sheet.
Freeze Rows and Columns
Divides the sheet at the top left corner of the active cell and the area to the top left is no longer scrollable.
Split Window
Divides the current window at the top left corner of the active cell.
Sidebar
The Sidebar is a vertical graphical user interface that primarily provides contextual properties, style management, document navigation, and media gallery features.
Styles
Use the Styles deck of the Sidebar to assign styles to cells and pages. You can apply, update, and modify existing styles or create new styles.
Gallery
Opens the Gallery deck of the Sidebar, where you can select images and audio clips to insert into your document.
Navigator
Activates and deactivates the Navigator. The Navigator is a dockable window.
Function List
Opens the Function List deck of the Sidebar, which displays all functions that can be inserted into your document.
Data Sources
Lists the databases that are registered in LibreOffice and lets you manage the contents of the databases.
Full Screen
Shows or hides the menus and toolbars in Writer or Calc. To exit the full screen mode, click the Full Screen button or press the Esc key.
Zoom
Reduces or enlarges the screen display of LibreOffice.
Paste Special
Inserts the contents of the clipboard into the current file in a format that you can specify.
Select All
Selects the entire content of the current file, frame, or text object.
Find
Toggle the visibility of the Find toolbar to search for text or navigate a document by element.
Find & Replace
Finds or replaces text or formats in the current document.
Track Changes
Lists the commands that are available for tracking changes in your file.
Compare Document
Compares the current document with a document that you select. The contents of the selected document are marked as deletions in the dialog that opens. If you want, you can insert the contents of the selected file into the current document by selecting the relevant deleted entries, clicking Reject, and then clicking Insert.
Merge Document
Imports changes made to copies of the same document into the original document. Changes made to footnotes, headers, frames and fields are ignored. Identical changes are merged automatically.
Links
Lets you edit the properties of each link in the current document, including the path to the source file. This command is not available if the current document does not contain links to other files.
Image Map
Allows you to attach URLs to specific areas, called hotspots, on a graphic or a group of graphics. An image map is a group of one or more hotspots.
Object
Lets you edit a selected object in your file that you inserted with the Insert - Object command.
Edit File
Use the Edit File icon to activate or deactivate the edit mode.
Tools Menu
The Tools Menu contains commands to check spelling, to trace sheet references, to find mistakes and to define scenarios. You can also create and assign macros and configure the look and feel of toolbars, menus, keyboard, and set the default options for LibreOffice applications.
Checks spelling manually.
Automatic Spell Checking On/Off
Automatic Spell Checking On/Off Automatically checks spelling as you type, and underlines errors. Automatic Spell Checking On/Off Typing errors are highlighted in the document with a red underline.
Thasaurus
Thesaurus Opens a dialog box to replace the current word with a synonym, or a related term. To access this command... Choose Tools - Language - Thesaurus. Command Ctrl+F7
Language
Opens a submenu where you can choose language specific commands.
Auto Correct Options
Sets the options for automatically replacing text as you type.
Auto Input
Switches the AutoInput function on and off, which automatically completes entries, based on other entries in the same column. The column is scanned up to a maximum of 2000 cells or 200 different strings.
Image Map
Allows you to attach URLs to specific areas, called hotspots, on a graphic or a group of graphics. An image map is a group of one or more hotspots.
Goal Seek
Opens a dialog where you can solve an equation with a variable.
Solver
Opens the Solver dialog. A solver allows you to solve mathematical problems with multiple unknown variables and a set of constraints on the variables by goal-seeking methods.
Detective
This command activates the Spreadsheet Detective. With the Detective, you can trace the dependencies from the current formula cell to the cells in the spreadsheet.
Scenarios
Defines a scenario for the selected sheet area.
Protect Document
The Protect Sheet or Protect Spreadsheet Structure commands prevent changes from being made to cells in the sheets or to sheets in a document. As an option, you can define a password. If a password is defined, removal of the protection is only possible if the user enters the correct password.
Macros
Lets you record or organize and edit macros.
Extension Manager
The Extension Manager adds, removes, disables, enables, and updates LibreOffice extensions.
XML Filter Settings
Opens the XML Filter Settings dialog, where you can create, edit, delete, and test filters to import and to export XML files.
Customize
Customizes LibreOffice menus, context menus, shortcut keys, toolbars, and macro assignments to events.
Options
This command opens a dialog for a customized program configuration.
Comments
Post a Comment