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

Named Ranges and Expressions

Allows you to name the different sections of your spreadsheet document. By naming the different sections, you can easily navigate through the spreadsheet documents and find specific information.

To access this command...

Choose Insert - Named Range or Expression.

Define

Opens a dialogue box where you can specify a name for a selected area or a name for a formula expression.

Insert

Inserts a defined named cell range at the current cursor's position.

Apply

Allows you to automatically name multiple cell ranges.

Labels

Opens a dialogue box in which you can define a label range.