This menu contains commands for controlling the on-screen display of the document.


Displays the normal layout view of the sheet.

Page Break


Opens a sub-menu 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 formulae. 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 content in different colours, depending on type.

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.


Divides the current window at the top left corner of the active cell.


The Sidebar is a vertical graphical user interface that primarily provides contextual properties, style management, document navigation and media gallery features.

Styles in Calc

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.


Opens the Gallery deck of the Sidebar, where you can select images and audio clips to insert into your document.


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.


Reduces or enlarges the screen display of LibreOffice.

Please support us!