Libre office Calc
FILE
Open (Ctrl+O) –
Open the save file.
Spreadsheet
(Ctrl+N) -
Templates
(Ctrl+Shift+N) –
Save as
template (Shift+F11) –
Save (Ctrl+S) –
Save a current Document.
Save As
(Ctrl+Shift+S) – Save a Document in Different file format.
Print (Ctrl+P)
– Print a current Document.
Print Preview
(Ctrl+Shift+O) – Preview the print Document.
Exit Libre
office (Ctrl+Q) – libre office close
EDIT
Undo (Ctrl+Z) –
Undo the current action in document.
Redo (Ctrl+Y) –
Redo the current action in document.
Repeat
(Ctrl+Shift+Y) – Repeat the action in document.
Paste
(Ctrl+V) – Paste the contents of the clipboard.
Paste
Special (Ctrl+Shift+V) –
Select
All (Ctrl+Shift+Space) – Select all words in the document.
Cell Edit Mode
(F2) –
Cut (Ctrl+X) –
Cut the selected contents of the clipboard.
Copy
(Ctrl+C) – Copy the selected content of the clipboard.
Find
(Ctrl+F) – find text to document
Replace
(Ctrl+H) – Replace text in the document.
Merge
Document - Joins the selected cells into one larger new cell.
Edit
Mode (Ctrl+Shift+M) –
VIEW
Value
Highlighting (Ctrl+F8) –
Freeze
Cells – Keep a portion of the sheet visible while the rest of the sheet
scrolls.
Show
Formula (Ctrl) – Display the formula in each cell instead of the resulting
values.
Styles
and formatting (F11) –
Navigator
(F5) -
Data
Sources (Ctrl+Shift+F4) –
Full
Screen (Ctrl+Shift+J) –
INSERT
Image
– Insert a Image from a file.
Chart
– Insert a chart to illustrate and compare data.
Object
– Insert an OLE object into the document.
Shapes
– Insert readymade shapes such as rectangles and circles, arrows, lines,
flowchart symbols and
callouts.
Font
work – Insert decorative text in your document.
Text
Box – Insert preformatted text boxes.
Pivot
Table – Click here to summarize data using a pivot table or to insert a pivot
chart.
Function
(Ctrl+F2) – Edit the formula in the current cell by choosing functions and
editing the arguments.
Comment
(Ctrl+Alt+C) – Add a comment about the selection.
Header
and Footer – Edit the header and footer in the document.
Hyperlink
(Ctrl+K) – Create a link to a webpage, a picture, an email address or a
program.
Date
(Ctrl+;) – Browse and select from a list of date function.
Time
(Ctrl+Shift+;) – Browse and select from a
list of time function.
FORMAT
Bold
(Ctrl+B) – Make the selected text Bold.
Italic
(Ctrl+I) – Italicize the selected text.
Underline
(Ctrl+U) – Under the selected text.
Strikethrough
– Draw a line through the middle of the selected text.
Cycle
Case (Shift+F3) -
Sub
script (Ctrl+Shift+B) – Create small letter below the text baseline.
Super
Script (Ctrl+Shift+P) – Create small letter above the line of the text.
Wrap
text – Make all contents visible within a cell by displaying it on multiple
lines.
Line
spacing 1.5 (Ctrl+5) –
Line
Spacing 2 (Ctrl+2) –
Decrease
Indent – Decrease the margin between the border and the text in the cell.
Increase
Indent – Increase the margin between the border and the text in the cell.
Align
Left (Ctrl+L) – Align text to the left.
Align right (Ctrl+R)– Align text to the right.
Center
(Ctrl+E) – Center text.
Justify
(Ctrl+J) – Align text to both the left and right margins adding extra space
between words as
necessary.
General
(Ctrl+Shift+6) – Choose an alternate currency format for the selected text.
Number
(Ctrl+Shift+1) –
Percent
style (Ctrl+Shift+5) – Display the value of the cell as a percentage.
Currency
(Ctrl+Shift+4) –
Date
(Ctrl+Shift+3) –
Scientific
(Ctrl+Shift+2) –
Clone
Formatting (Ctrl+M) –
Chart
– Insert a chart to illustrate and compare data.
Group - Group
objects together so that they can be treated like a single object.
Cells (Ctrl+1)
–
SHEET
Insert
Cells (Ctrl++) – Add new rows, columns, cells and sheets in your workbook.
Delete Cells
(Ctrl+-) – Delete rows, columns and cells.
Cell reference
types (F4) –
Clear cells
(Backspace) – Delete everything from cells.
To Previous
Sheets (Ctrl+ Pageup) –
To Next Sheet
(Ctrl+ Page down) –
DATA
Recalculate
(F9) –
Group (F12) –
Tie a range of cells together so that they can be collapsed or expanded.
Pivot
Table - Click here to summarize data using a pivot table or to insert a pivot
chart.
TOOLS
Spelling (F7) –
Check the spelling of text in the
document.
Automatic Spell
Checking (Shift+F7) –
Thesaurus
(Ctrl+F7) – Suggests other words with a similar meanings to the word you have
selected.
Hyphenation –
Turn on hyphenation, which allows word to break lines between the syllables of
word.
Protect Sheet –
Prevent unwanted changes to the data in a sheet by specifying what information
can be changed.
Protect
Spreadsheet – Restrict access to the workbook by preventing new sheets from
being created or by granting access only to specific people.
Trace
Precedents (Shift+F9) – Show arrows that indicates what cells affect the value
of the currently selected cells.
Trace
Dependents (Shift+F5) – Show arrows that indicate what cells are affected by
the value of the currently selected cells.
Macros – click
here to record a macro to access other macro options.
Extension
Manager (Ctrl+Alt+E) –
Option
(Alt+F12) –
Window
New Window
Close
Window(Ctrl+W)
Help
LibreOffice
Help (F1)
No comments:
Post a Comment