How To Set Up A Database In EXCEL Which Is Searchable.

Asked By 0 points N/A Posted on -
qa-featured

Excel helps us to budget, report, forecast etc. It can also act as a spreadsheet database. It includes features like sorting etc. how to set up a database in EXCEL?

SHARE
Answered By 10 points N/A #91389

How To Set Up A Database In EXCEL Which Is Searchable.

qa-featured

STEPS TO SET UP A DATABASE:

1) Type the labels in the first row. Each row defines a record.

2) From the top bar select the view tab and go to Freeze Panes item.

3) From the drop-down menu press on Freeze Top Row. This will keep the the header visible even when we scroll down.

4) Type in your information in the rows.

5) Select all the cells in the worksheet.

6) Click on the filter button from the Sort and Filter group.

7) From the drop-down menu select any option as per the operation you want to carry out.

8) Choose from the number or texts Then click OK.

9) From the filter button disable the filtering.

Related Questions