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

Defining a Database Range

You can define a range of cells in a spreadsheet to use as a database. Each row in this database range corresponds to a database record and each cell in a row corresponds to a database field. You can sort, group, search, and perform calculations on the range as you would in a database.

You can only edit and access a database range in the spreadsheet that contains the range. You cannot access the database range in the Office Data Sources view.

To Define a Database Range

  1. Select the range of cells that you want to define as a database range.

  2. Choose Data - Define Range.

  3. In the Name box, enter a name for the database range.

  4. Click More.

  5. Specify the options for the database range.

  6. Click OK.