\<bookmark_value\>tables; database ranges\</bookmark_value\>\<bookmark_value\>database ranges; defining\</bookmark_value\>\<bookmark_value\>ranges; defining database ranges\</bookmark_value\>\<bookmark_value\>defining;database ranges\</bookmark_value\>

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.

Warning Icon

You can only edit and access a database range in the spreadsheet that contains the range. You cannot access the database range in the LibreOffice 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 \<item type=\"menuitem\"\>Data - Define Range\</item\>.

  3. In the \<emph\>Name\</emph\> box, enter a name for the database range.

  4. Click \<emph\>More\</emph\>.

  5. Specify the options for the database range.

  6. Click \<emph\>OK\</emph\>.

Please support us!