Note for Mac users
Some keystrokes and menu items are different on a Mac from those used in Windows and Linux. The table below gives some common substitutions for the instructions in this chapter. For a more detailed list, see the application Help.
| Windows or Linux | Mac equivalent | Effect |
|---|---|---|
| Tools > Options menu selection | LibreOffice > Preferences | Access setup options |
| Right-click | Control+click or right-click depending on computer setup | Opens a context menu |
| Ctrl (Control) | ⌘ (Command) | Used with other keys |
| F5 | Shift+⌘+F5 | Open the Navigator |
| F11 | ⌘+T | Open the Styles and Formatting window |
Contents
Contents
Copyright2
Contributors2
Feedback2
Acknowledgments2
Publication date and software version2
Note for Mac users2
What is Calc?5
Spreadsheets, sheets, and cells5
Calc main dialog5
Title bar5
Menu bar6
Toolbars7
Formula bar7
Spreadsheet layout8
Individual cells8
Sheet tabs8
Status bar9
Sidebar10
Properties10
Styles and Formatting10
Gallery10
Navigator10
Function Wizard11
Creating, opening and saving spreadsheets11
Creating and opening11
Using templates11
Opening CSV files11
Saving spreadsheets13
Saving in other formats13
Password protection15
Navigating within spreadsheets15
Cell navigation15
Sheet navigation16
Keyboard navigation17
Customizing the Enter key18
Selecting items in a sheet or spreadsheet18
Selecting cells18
Single cell18
Range of contiguous cells19
Range of non-contiguous cells19
Selecting columns and rows19
Single column or row19
Multiple columns or rows19
Entire sheet20
Selecting sheets20
Single sheet20
Multiple contiguous sheets20
Multiple non-contiguous sheets20
All sheets21
Working with columns and rows21
Inserting columns and rows21
Single column or row21
Multiple columns or rows21
Deleting columns and rows21
Single column or row21
Multiple columns or rows22
Working with sheets22
Inserting new sheets22
Moving and copying sheets23
Dragging and dropping23
Using Move/Copy Sheet dialog23
Deleting sheets24
Renaming sheets24
Viewing Calc24
Changing document view24
Freezing rows and columns24
Unfreezing25
Splitting the screen25
Splitting horizontally or vertically25
Removing split views26
Using the Navigator26
Using document properties28
General28
Description29
Custom Properties29
Security29
Font30
Statistics30