Contents

# 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 LibreOffice Data Sources view.

To define a database range

1. कक्ष दायरा चुनें जिसे आप डाटाबेस दायरा के रूप में निर्धारित करना चाहते हैं.

2. Choose Data - Define Range.

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

4. Click Options.

5. डाटाबेस दायरा के लिए विकल्प निर्धारित करें.

6. Click OK.

Related Topics

Sorting Data

Filtering Cell Ranges

Database Functions

Define Range

Database Table Reference

Please support us!