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

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

6. Click OK.

Related Topics

Sorting Data

Filtering Cell Ranges