LibreOffice A Great Free Office Suite Favorite Shortcuts

By Scott Sekinger

Do you need an offices suite, but you do not want to pay a lot of money for Microsoft Office, Corel’s WordPerfect Office, etc? If so I have some great news for you. There is great free office suite called LibreOffice. That cost $0. Yes that is right it is 100% free and legally.

Liberoffice includes a word processor, a spreadsheet, program, a presentation program, a database program, and more. LibreOffice is compatible with MS Office, and is easy to use.

CNET Download.com gave it 5 stars. They said that “LibreOffice offers up a free alternative, and we found it on par with its more popular competitor.


Read more: LibreOffice – Free download and software reviews – CNET Download.com http://download.cnet.com/LibreOffice/3000-18483_4-75337651.html#ixzz2qsOdjw2X

Below are some keyboard shortcuts for each program.

Keyboard shortcuts for Writer (the word processor)

Shortcut keysEffect
F2Formula Bar
Ctrl+F2Insert Fields
F3Complete AutoText
Ctrl+F3Edit AutoText
F4Open Data Source View
Shift+F4Select next frame
F5Navigator on/off
Ctrl+Shift+F5Navigator on, go to page number
F7Spellcheck
Ctrl+F7Thesaurus
F8Extension mode
Ctrl+F8Field shadings on / off
Shift+F8Additional selection mode
Ctrl+Shift+F8Block selection mode
F9Update fields
Ctrl+F9Show fields
Shift+F9Calculate Table
Ctrl+Shift+F9Update Input Fields and Input Lists
Ctrl+F10Nonprinting Characters on/off
F11Styles and Formatting window on/off
Shift+F11Create Style
Ctrl+F11Sets focus to Apply Style box
Ctrl+Shift+F11Update Style
F12Numbering on
Ctrl+F12Insert or edit Table
Shift+F12Bullets on
Ctrl+Shift+F12Numbering / Bullets off

You can get more shortcuts at https://help.libreoffice.org/Writer/Shortcut_Keys_for_Writer.

Keyboard shortcuts for Spreadsheets (the spreadsheet program)

Shortcut KeysEffect
Ctrl+HomeMoves the cursor to the first cell in the sheet (A1).
Ctrl+EndMoves the cursor to the last cell on the sheet that contains data.
HomeMoves the cursor to the first cell of the current row.
EndMoves the cursor to the last cell of the current row.
Shift+HomeSelects cells from the current cell to the first cell of the current row.
Shift+EndSelects cells from the current cell to the last cell of the current row.
Shift+Page UpSelects cells from the current cell up to one page in the current column or extends the existing selection one page up.
Shift+Page DownSelects cells from the current cell down to one page in the current column or extends the existing selection one page down.
Ctrl+Left ArrowMoves the cursor to the left edge of the current data range. If the column to the left of the cell that contains the cursor is empty, the cursor moves to the next column to the left that contains data.
Ctrl+Right ArrowMoves the cursor to the right edge of the current data range. If the column to the right of the cell that contains the cursor is empty, the cursor moves to the next column to the right that contains data.
Ctrl+Up ArrowMoves the cursor to the top edge of the current data range. If the row above the cell that contains the cursor is empty, the cursor moves up to the next row that contains data.
Ctrl+Down ArrowMoves the cursor to the bottom edge of the current data range. If the row below the cell that contains the cursor is empty, the cursor moves down to the next row that contains data.
Ctrl+Shift+ArrowSelects all cells containing data from the current cell to the end of the continuous range of data cells, in the direction of the arrow pressed. If used to select rows and columns together, a rectangular cell range is selected.
Ctrl+Page UpMoves one sheet to the left.In the page preview: Moves to the previous print page.
Ctrl+Page DownMoves one sheet to the right.In the page preview: Moves to the next print page.
Alt+Page UpMoves one screen to the left.
Alt+Page DownMoves one screen page to the right.
Shift+Ctrl+Page UpAdds the previous sheet to the current selection of sheets. If all the sheets in a spreadsheet are selected, this shortcut key combination only selects the previous
sheet. Makes the previous sheet the current sheet.
Shift+Ctrl+Page DownAdds the next sheet to the current selection of sheets. If all the sheets in a spreadsheet are selected, this shortcut key combination only selects the next sheet. Makes the next sheet the current sheet.
Ctrl+ *where (*) is the multiplication sign on the numeric key padSelects the data range that contains the cursor. A range is a contiguous cell range that contains data and is bounded by empty row and columns.
Ctrl+ /where (/) is the division sign on the numeric key padSelects the matrix formula range that contains the cursor.
Ctrl+Plus keyInsert cells (as in menu Insert – Cells)
Ctrl+Minus keyDelete cells (as in menu Edit – Delete Cells)
Enter (in a selected range)Moves the cursor down one cell in a selected range. To specify the direction that the cursor moves, choose Tools – Options – LibreOffice Calc – General.
Ctrl+ ` (see note below this table)Displays or hides the formulas instead of the values in all cells.

You can get more shortcuts at https://help.libreoffice.org/Calc/Shortcut_Keys_for_Spreadsheets.

Keyboard shortcuts for Impress (the presentation program).

Shortcut KeysEffect
EscEnd presentation.
Spacebar or Right arrow or Down arrow or Page Down or Enter or Return or NPlay next effect (if any, else go to next slide).
Alt+Page DownGo to next slide without playing effects.
[number] + EnterType a number of a slide and press Enter to go to the slide.
Left arrow or Up arrow or Page Up or Backspace or PPlay previous effect again. If no previous effect exists on this slide, show previous slide.
Alt+Page UpGo to the previous slide without playing effects.
HomeJump to first slide in the slide show.
EndJump to the last slide in the slide show.
Ctrl+ Page UpGo to the previous slide.
Ctrl+ Page DownGo to the next slide.
B or .Show black screen until next key or mouse wheel event.
W or ,Show white screen until next key or mouse wheel event.

You can get more at https://help.libreoffice.org/Impress/Shortcut_Keys_for_Impress.Shortcuts for Database.

Shortcut KeysResults
Ctrl+PgUpJumps between tabs.
Ctrl+PgDnJumps between tabs.
F6Jump between windows.
TabSelection of the control fields.
Shift+TabSelection of the control fields in opposite direction.
Ctrl+EnterInserts the selected control.
Arrow keyCtrl+arrow keyMoves the selected control in steps of 1 mm in the respective direction. In point edit mode, it changes the size of the selected control.
Ctrl+TabIn point edit mode, jumps to next handle.
Shift+Ctrl+TabIn point edit mode, jumps to previous handle.
EscLeaves the current selection.

You can get more keyboard shortcuts at https://help.libreoffice.org/Common/Database_Shortcut_Keys.

Head over to http://www.libreoffice.org/default/, and check it out .You would not great it,