Libre Office Calc

• By Default file name – Untitled 1

◦ Extension name - .ods

• By Default font name – Liberation Sans

• By Default font size – 12

◦ Minimum font size – 6

◦ Maximum font size – 96

• By Default zooming – 100%

◦ Minimum zooming – 20%

◦ Maximum zooming – 400%

• Row – 1048576 (1,2,3,….)

◦ It is horizontaly (left to right)

◦ Go to last row – Ctrl + Down arrow

• Column – (AMJ) 16384 (A,B,C,….)

◦ It is vertically (up to down)

◦ Go to last column – Ctrl + Right arrow

• By default sheet – 1

◦ Maximum sheet – 10000

• Insert date – Ctrl + ;

• Insert time – Ctrl + Shift + :

• Insert cell – Ctrl + +

• Delete cell – Ctrl + -

• Row Height – 0.18”

• Column Width – 0.89”

• Total menus – 11

Standard Toolbar

• New – Ctrl + N

• Open – Ctrl + O

• Save – Ctrl + S

• Save As – Ctrl + Shift + S

• PDF – Portable Document Format

• Print – Ctrl + P

• Toggle Print Preview – Ctrl + Shift + O

• Cut – Ctrl + X

• Copy – Ctrl + C

• Paste – Ctrl + V

• Clone Formatting – It means copy formatting from one place and apply it to another.

◦ Clear Formatting – Ctrl + M

• Undo – Ctrl + Z

• Redo – Ctrl + Y

• Repeat – Ctrl + Shift + Y

• Find and Replace – Ctrl + H

• Spelling check – F7

◦ Automatic spelling check – Shift + F7

◦ Thesaurus – Ctrl + F7

• Insert Row

• Insert Column

• Sort- Arrange in sequence wise.

◦ Ascending order

◦ Descending order

• Auto filter

• Insert Image – Insert a picture from a file.

• Insert Chart – The selected cells are used as source data for the chart to be created.

• Pivot Table -

• Insert Special Characters

• Inset Hyperlink – Ctrl – K

• Insert Comment – Ctrl + Alt + C

• Header and Footer

• Define Print Area

• Freez rows and columns

• Split Window

• Show Draw Function

Formatting Toolbar

• Font name – By default font name Liberation Sans

• Font size – By default font size 10

◦ Minimum – 6

◦ Maximum – 96

• Bold – Ctrl + B

• Italic – Ctrl + I

• Underline – Ctrl + U

• Font Color – By default Dark Red 2

• Highlight Color – By default Yellow

• Alignment -

◦ Left – Ctrl + L

◦ Center – Ctrl + E

◦ Right – Ctrl + R

• Wrap Text

• Merge and Center Cells

• Align Top

• Center Vertically

• Align Bottom

• Format as Currency – Ctrl + Shift + 4

• Format as Percent – Ctrl + Shift + 5

• Format as Number – Ctrl + Shift + 1

• Format as Date – Ctrl + Shift + 3

• Format as Scientific – Ctrl + Shift + 2

• Format as General – Ctrl + Shift + 6

• Add Decimal Place

• Delete Decimal Place

• Increase Indent – The increase indent button moves the text/number one tab stop to the right.

• Decrease Indent – The decrease indent button moves the text/number one tab stop to the left.

• Insert Border

• Border Style

• Border Color – By default Blue

• Conditional Formatting

Other Short cut keys -

• Side bar – Ctrl + F5

• Select all – Ctrl + Shift + Space / Ctrl + A

• Cell Edit Mode – F2

• Value Highlighting – Ctrl + F8

• Styles – F11

• Navigator – F5

• Data Source – Ctrl + Shift + F4

• Full Screen – Ctrl + Shift + J

• Insert Function – Ctrl + F2

• Format cell – Ctrl + 1

• Cyle case – Shift + F3

• Help - F1

• Close Window – Ctrl + W

• Exit Libre Office – Ctrl + Q