Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo


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


Displays the normal layout view of the sheet.

Page Break

User Interface

Opens the Select Your Preferred User Interface dialogue box to let you choose the user interface layout for Office.


Opens a sub-menu to show and hide toolbars. A toolbar contains icons and options that let you quickly access Office 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.

View Grid lines

Toggle the visibility of grid lines for the current sheet.

Grid and Help Lines

Toggle the visibility of grid points and guide lines to help object moving and precise position in 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.


Display the cell comments for the current spreadsheet document.


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

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.

Freeze Cells

Freezes the first column or the first row of the current spreadsheet.

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


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 Office 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 Office.